Very Computer

>Query
>Table  |  Name          |
>       |CheckPlus ~var  |

>After some search i discovered that the comma will be seen as an
>operator. That's why the query will have no result even if the name
>"John, H" appears in the table.
>Is there any workaround for this problem? i tried several thing, but no
>result.
>thanks in advance,
>Marlon

>>Hello everyone,
>>In ObjectPal i'm using a query with a ~tilde variable.
>>If i assign the varibale with something like this: var="John, H"
>>the query result will be empty.

>>Query
>>Table  |  Name          |
>>       |CheckPlus ~var  |

>>After some search i discovered that the comma will be seen as an
>>operator. That's why the query will have no result even if the name
>>"John, H" appears in the table.
>>Is there any workaround for this problem? i tried several thing, but no
>>result.
>>thanks in advance,
>>Marlon

>Put a backslash before any reserved character to render it literal.
>Such as: "John\, H"  

> > In ObjectPal i'm using a query with a ~tilde variable.
> > If i assign the varibale with something like this: var="John, H"
> > the query result will be empty.

> the other responses are close, but no cigar.. the *whole* string must
> itself start and end with quotes (as if you typed it in that way) and the
> query processor will deal with the string as-is.. in this case:

> var = "\"John, H\""

> this is actually a common issue.. two state abbreviations are OR for Oregon
> and AS for American Samoa.. consider the problems querying for those values
> in a [State] field.. it's the exact same thing you are faced with..

> --
> Steve Green
> Corel CTech - Paradox
> Diamond Software Group, Inc.
> Waldorf, Maryland  USA

> http://www.diamondsg.com