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