Paradox Community

Items in pnews.paradox-programming

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).


Copyright © 2004 thedbcommunity.com