Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL JOIN using AT()
Message
From
02/06/2004 17:10:00
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL JOIN using AT()
Miscellaneous
Thread ID:
00909403
Message ID:
00909403
Views:
55
I thought this would work as both sides of the equal sign would evaluate to a logical, but I get "Expression could not be evaluated" when comparing the two AT equations in the Debug window and an error when running the actual JOIN in code. I'm trying to find matches where a specific text string exist in the two fields in both cursors.
JOIN MyCursor1 ON AT('TEXTSTRING',ALLTRIM(UPPER(MyCursor1.MyField)))>0 = AT('TEXTSTRING',ALLTRIM(UPPER(MyCursor2.MyField)))>0
Next
Reply
Map
View

Click here to load this message in the networking platform