on 12/19/03 6:29 AM, Sidney at activeducation at comcast .DOT net wrote:
> Ruslan,
> I have a SELECT statement. The question is about escaping special
> characters. I'm testing out the Valentina COM from VB6. SQL-92 spec. says
> to get apostrophes in a string use apostrophe as escape:
>
> However this did not work with Valentina
> WHERE object = 'Joe''s umbrella'
>
> But this did
> WHERE object = 'Joe\'s umbrella'
>
> Is this Valentina implementation specific? Please comment.
Hi Sidney,
Yes, here Valentina 1.x differ from SQL92
In Valentina 2.0 we have implement standard way also
--
Best regards,
Ruslan Zasukhin [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan@paradigmasoft.com
web: http://www.paradigmasoft.com
To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------
_______________________________________________
Valentina mailing list
Valentina at lists .DOT macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2003 Ruslan Zasukhin |
