Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating Query with Related fields. Answer!
Message
From
18/12/1997 07:54:40
 
 
To
18/12/1997 07:52:51
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00066852
Message ID:
00066854
Views:
31
>Hi Everybody!
>
>I had a problem in updating a query with joined tables. The problem was with the SQL I used in .RecordSource.
>
>I was using WHERE clause for joining the tables. Just the way I used in Fox! We should instead use the INNER JOIN clause.
>
>So, Fox' guys... watch out!

With the latest version of Visual FoxPro, this is now the syntax we should use. It's nice you finally fix the problem. :)
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View

Click here to load this message in the networking platform