[VXCMD] Escaping Characters?

[Ruslan Zasukhin]

on 4/27/03 7:04 AM, Ken Ray at kray at sonsothunder.com wrote:

> I'm having a problem where certain characters that are contained in
> 'tText' in the following query:
> 
> put "SELECT Entities.RecID FROM Entities WHERE Entities.FindName LIKE '"
> & tText & "' no_case" into tSQL
> 
> either return an error (616) or return all records.
> 
> The characters: <>;\]_~`!
> all give you an Error 616 if not escaped with a \, and will CONTINUE to
> give you an Error 616 if escaped but not found in any of the records in
> the table. 

Hmm, second phrase wonder me.

> The charcters: $*^()+{[|.?
> return all records if not escaped with a \, and will return an Error 616
> if escaped but not found in any of the records in the table.
> 
> How can I make sure I don't get any Errors at all, but still allow for
> all these characters to be in the field (Entities.FindName) of my query?

In fact Valentina lack special function EscapeString().
I MUST add it.

As for me, the best way to avoid escaping at all is binding of strings to
query. Unfortunately this works for now only for INSERT / UPDATE / DELETE
commands, but not for SELECT.

First of all I need check above problem with 616 error...

-- 
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
-------------------------------------------------------------