>Has anyone had a problem using the tilde variable in a query? I have a database field that has organization names in it such as:
>Borland International, Inc.
>The comma really messes up my query's search of the database and returns an empty answer table although I can see that there are
>records out there that it should be hitting on.
>When I hard code the name of the organization I am searching for in a query, it works fine. But when the ~ tries to pick up the
>inputted organization the query finds nothing.
>Thx in advance.
I ust tried this out and have the same trouble. If you ave a field
with a comma in it (lke the old familiar "LastName, FirstName") then
a pushbutton which has
var
s string
endvar
s=Name.value
q = query
Table.db | Name |
| check ~s |
endquery
q.executeQBE()
will not find anything if the Name field has a comma embedded.
The trick is to do
s = "\""+Name.value+"\""
before doing the query. This adds quotes around the name before the
query string is created.
--
--------------------------------------------------------------------
Coupled Climate Dynamics Group/971
NASA Goddard Space Flicht Genter
Greenbelt, MD
if I had a .sig file it would day something witty here.
by