Subject: | QBE to SQL
| Date: | Sat, 30 May 2020 09:21:04 -0400
| From: | Kevin Baker <shcsbaker@gmail.com>
| Newsgroups: | pnews.paradox-programming
|
I'm beginning to replace my QBE queries with SQL and have an issue I
can't seem to figure out. For many reasons, there are times when a var
I'm passing the the query will equal ".."
For example in building a query the user has the option to filter
records for a particular field, if they don't filter any records (they
want them all), the var gets the value of ".."
The QBE gets passed this var by use ~gsvar (with gsvar having the value
of ..)
I'm not sure what I need to change this to for SQL. In the SQL query I
would still pass the var ~gsvar, but when gsvar has a value of .. the
query fails. I tried ANY and ALL, but both of those cause an error
(invalid use of keyword).
|