VXCMD1: Single quote in a query

Sean Wilson snw at paradise.net.nz
Tue Jul 19 16:03:00 CDT 2005


>SELECT ... WHERE fld1='John's car'
>
>How does one treat the internal single quote within such a query? I imagine
>it has to be somehow escaped but cannot find a reference anywhere.

Most (all?) development environments for Valentina have an escapeString() 
method that should do what you need. Check the docs for the XCMD - it 
should be in there somewhere.

HTH,
-Sean. 




More information about the Valentina mailing list