Paradox Community

Items in pnews.paradox-programming

Subject:Re: QBE to SQL
Date:Sat, 30 May 2020 23:42:49 +1000
From:Bernie van't Hof <onrequest@somewhere>
Newsgroups:pnews.paradox-programming
LIKE operator and wildcard characters.

% for multiple characters (QBE  ..)
_ for single character (QBE @)

e.g. WHERE NameCol LIKE 'Kev%Bake_'

- Bernie
On 30/5/20 11:21 pm, Kevin Baker wrote:
> 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