[VXCMD] Escaping Characters?

[Ruslan Zasukhin]

on 4/27/03 7:04, 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. 
> 
> 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?

Hi Ken,

We have add new function ExcapeString() to C++ SDK.

I think in nearest day of 2 I will work on VXCMD, to add all new staf.
Please watch for list. Then test this new function and let me know if any
problems.

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