by > 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..
Thanks very much for your response, it helped me on the right track.
In another case the variable itself comes from a table.
So when the user is interacting with the data through dialog
boxes the variable he choose will be stored in a table.
It's like this: (paradox 7 for win95/NT)
empTC.open(Table)
Var1=empTC.Field
empTC.close
So Table contains the value of the variable (Var1) that actually must be
searched for in another table (Table2).
Query
Table2 | Field2 |
| Check ~Var1 |
The solution mentioned above won't work in this case.
I hope you can help me with this one
Thanks in advance,
Marlon
Sent via Deja.com http://www.deja.com/
Before you buy.