escapes?

[Ruslan Zasukhin]

on 12/19/03 6:29 AM, Sidney at activeducation at comcast.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 at paradigmasoft.com
web: http://www.paradigmasoft.com

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