[Valentina] FIXED: SQL Bug on INSERT of escaped string into TEXT

[Ruslan Zasukhin]

on 1/3/03 11:02 AM, Yennie at aol.com at Yennie at aol.com wrote:

Hi Brian,

This bug is fixed. 


> Ruslan,
> 
> It looks like I have found an easy to reproduce bug which results in a crash
> every time for me.
> 
> 1). Create a new database with one BaseObject and one TEXT field
> 2). Try to insert a record with escaped single quote in INSERT.
> 
> Example:
> 
> BaseObject: CrashME
> FieldName: TestField
> 
> INSERT INTO CrashME (TestField) VALUES ('Brian\'s Test')
> 
> For me this is a crash every time with VXCMD.
> 
> Also if I do instead with double quotes:
> 
> INSERT INTO CrashME (TestField) VALUES ("Brian's Test")
> 
> It works. 
> 
> But if I want to escape double quotes inside like this:
> 
> INSERT INTO CrashME (TestField) VALUES ("Brian says \"Crash\" now")
> 
> Then I get no crash, but the field value includes the backslash!
> 
> The crashes only seem to happen with TEXT fields: String and VarChar are OK.
> 
> Let me know if you need more information, but until then I can't figure out
> 100% safe way to use INSERT or UPDATE with escaped values on a TEXT field.
> (Yes, crash happens for UPDATE also).
> 
> Brian
> 

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------