Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Interesting old bug?
Message
From
15/12/1998 09:48:38
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Interesting old bug?
Miscellaneous
Thread ID:
00167660
Message ID:
00167660
Views:
49
Hi All ---

Was running a simple outer join against two remote views (SQL Server) in VFP6. Kept getting "Column action_ID" not found for one of the tables (which is bogus). Changed the view definition so that the field name is "actionid" in the remote view, everything works.

Went back to some old VFP3 notes and found that I had the same problem way back when with SELECT statements using the JOIN keyword and fields with underlines in them whether or not local or remote views.

Anyone else ever run into this or could shed some light on this?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Next
Reply
Map
View

Click here to load this message in the networking platform