Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with SELECT
Message
From
05/08/2011 11:21:49
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Problem with SELECT
Miscellaneous
Thread ID:
01520239
Message ID:
01520239
Views:
116
Can some one tell me why the WHERE clause in this select is being ignored? It pulls all the records.
thisfield = 'current.sc1_2000'

SELECT st_name, Current.* ;
FROM tipdatabase!tip T ;
INNER JOIN tipdatabase!current  ;
ON t.tip_id = current.tip_id ;
WHERE ALLTRIM(eval(thisfield)) = "STP"
Thanks
Next
Reply
Map
View

Click here to load this message in the networking platform