Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL JOIN using AT()
Message
From
03/06/2004 07:48:37
 
 
To
02/06/2004 17:10:00
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00909403
Message ID:
00909505
Views:
6
>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
>
If the ALLTRIM(UPPER() evaluates to 0, it will return an error. Could you match on a prtion of the string, say SUBSTR('TextString',3,4)?
Duty is ours, the results are God's - John Quincy Adams
Previous
Reply
Map
View

Click here to load this message in the networking platform