V4RB v1 Problem with SQL

[Ruslan Zasukhin]

On 4/4/06 2:12 PM, "Cindy Brown" <cindy at kowhaiprogramming.com> wrote:

Hi Cindy,

> Can anyone please tell me what characters cannot be used in an SQL query and
> how I can get the SQL query to allow me to use them. For example, I'm using
> the following SQL query:
> 
> select Invoices.Description from Students,Invoices,Payments,Family  WHERE
> invoices.cid = payments.cinvid AND family.cstuid = students.cid AND
> Invoices.cstuid = students.cid AND ((Invoices.Description LIKE '\AYr 1/2
> Stationery (Rm11 & Rm14) $21.00\Z' no_case )) AND family.bReceives_Invoice =
> '1' ORDER BY Invoices.Description
> 
> The query doesn't work at all for this description. If I have a description
> that doesn't have brackets ( or ) or dollar signs $, then the query works
> without any problems. What do I use to get the query to accept these sorts
> of characters?

You need escape string using Valentina.EscapeString()

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]