[VXCMD] Escaping Characters?

[Ken Ray]

Ruslan,

Did you get a chance to check the bug I reported below? I noticed a new
beta of the XCMD is out, but wasn't sure if this fix was included.

Ken Ray
Sons of Thunder Software
Email: kray at sonsothunder.com
Web Site: http://www.sonsothunder.com/ 

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Ruslan Zasukhin
> Sent: Sunday, April 27, 2003 1:53 AM
> To: valentina at lists.macserve.net
> Subject: Re: [VXCMD] Escaping Characters?
> 
> 
> 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
> 
> 
> -------------------------------------------------------------
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net 
> http://lists.macserve.net/mailman/listinfo/val> entina
>