Author Topic: Problem editing a multi line unterminated SQL string  (Read 3879 times)

Ranophile

  • Junior Community Member
  • Posts: 3
  • Hero Points: 0
Problem editing a multi line unterminated SQL string
« on: September 18, 2006, 03:36:34 pm »
I have a problem editing a line in a C++ file.  This line is part of a multi-line SELECT statement, where some of the lines do not have terminating double quotes (").  When I try to add the double quote, SlickEdit crashes.  I got around the problem with notepad (eeuw).  Once all the double quotes are present, I have no problem editing the lines.  I can edit the line contents, and delete and restore double quote characters. 

Has anyone else experienced this problem?

Best Regards,

Adriano Baglioni

====================

Here is the info from the About screen:

SlickEdit Version 10.0.3 Copyright 1988-2005 SlickEdit Inc.
...
Build Date: October 27, 2005
Emulation: Brief

OS: Windows XP
Version: 5.01.2600  Service Pack 2

Installation Directory: C:\Program Files\SlickEdit\ (non-removable drive,NTFS)
Configuration Directory: C:\Documents and Settings\abaglioni.VR-SIMSBURY\My Documents\My SlickEdit Config\10.0.3\ (non-removable drive,NTFS)
Configuration Drive Usage: 31748MB / 156191MB

Memory Load: 37%
Physical Memory Usage: 780MB / 2095MB
Page File Usage: 588MB / 4032MB
Virtual Memory Usage: 64MB / 2097MB


Here is the code, reduced to a small example that has this problem.  Put this in the file junk.cpp, go to line 12 (the one that ends with "e.TimeStamp as ETS,") go to the end of the line and type the double-quote character.

---------------------->8--------------------------------------------
CValid TankInfoImpl::getDeliveryResults( const char *userQuery,
                                         TankIDL::DeliveryResultSequence_out report)
  throw (CORBA::SystemException)
{
   std::string  sqlQuery(
      ConstructQuery( userQuery,
         " SELECT b.TankID, b.AvgFuelTemperature as BT, "
         "b.FuelHeight as BFH, b.FuelVolume as BFV, "
         "b.TcFuelVolume as BTCFV, b.TimeStamp as BTS, "
         "b.UllageVolume as BUV, b.WaterHeight as BWH, "
         "b.WaterVolume as BWV, e.AvgFuelTemperature as ET, "
         "e.FuelHeight as EFH, e.FuelVolume as EFV, e.TcFuelVolume as ETCFV, e.TimeStamp as ETS,
         "e.UllageVolume as EUV, e.WaterHeight as EWH, e.WaterVolume as EWV,
         "b.ItemID as EventID FROM InventoryHistory b, InventoryHistory e where
         "b.ItemID = e.GroupID and b.EntryType = 1 and e.EntryType = 2;

                       " FROM DeliveryHistory "));

}
---------------------->8--------------------------------------------


Graeme

  • Senior Community Member
  • Posts: 2443
  • Hero Points: 322
Re: Problem editing a multi line unterminated SQL string
« Reply #1 on: September 19, 2006, 09:53:16 am »

I can confirm that slick 10.0.2 crashes as you say - I didn't get round to installing 10.0.3. 
Slick 11.0.2 doesn't crash - for me anyway.

Graeme

Dennis

  • SlickEdit Team Member
  • Senior Community Member
  • *
  • Posts: 2932
  • Hero Points: 438
Re: Problem editing a multi line unterminated SQL string
« Reply #2 on: September 19, 2006, 06:19:51 pm »
I can confirm that this exact bug was fixed in 11.0.x.