Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
AS Clause
Message
From
28/08/2000 11:10:45
 
 
To
28/08/2000 11:03:08
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00409807
Message ID:
00409812
Views:
28
You will have to include the full logic expression in the where clause, like this:

.. where (expression from the column)='J'

Of course, in your case you could just do

.. where Detail.avr_wtg=.t.

>Dear readers,
>
>When i execute the folowing SQL query, i get the error colomn "WTG"not found.
>
>SELECT detail.avr_ari,;
> iif(Detail.avr_wtg=.t.,'J','N') as WTG;
>FROM general!detail;
>WHERE WTG='J'
>
>Is this an impossible kind of query, to include an expressionalias in the WHERE Clause ?
>
>Any idea's how to solve this ?
>
>- Bjorn
Previous
Reply
Map
View

Click here to load this message in the networking platform