Hard crash during SQL execution

[Steve Albin]

On Saturday, February 10, 2007 bart.pietercil at gmail.com (Bart Pietercil) wrote:

>I don't know whether Valentina does automatic escaping of reserved  
>SQL characters.
>What has happened to me is that (for a select query) the values  
>passed in the WHERE clause contain accents ('). They could lead to a  
>misinterpretation from the queryparser that might lead to an  
>execption (usually column not found). It could explain the random  
>behaviour of the crash (depending on the values passed)

Hi Bart,

Yes, certain characters in a string will cause problems, but it has been my experience that kind of error will throw an exception - not a hard crash.  I use the Valentina EscapeString routine on my SQL strings to prevent that.

Thanks for the suggestion.

Steve

-- 
Steve Albin - Montclair, NJ
http://www.jazzdiscography.com/
http://www.steve-albin.com/