Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get result from 3 tables
Message
 
To
09/02/2011 14:18:01
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01499447
Message ID:
01499537
Views:
29
I would additionally textmerge your "thisform.text25.value" in the SQL-Select. When the SQL processes it is expecting queries based on a table.field basis. When you throw at it a thisform.text25.value it sometimes gets confused... You might want to change like

lcFormValue = trim( Thisform.text25.Value )

then in your WHERE,

WHERE ATC( "{{lcFormValue}}", SDISC ) > 0

(using curly brackets above for post... prevented from using angled brackets)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform