Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
 To: Giuliano Pigozzi
  Where is Giuliano Pigozzi?
 verona
 Italy
 Giuliano Pigozzi
 Tags
Subject: RE: SQL Statement to Update Records in VFP6
Thread ID: 48907 Message ID: 53423 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Tuesday, October 12, 2004 4:35:36 PM         
   



> Now I use ADO with Vc++ ...and i have this problem:
> "UPDATE [table] SET [field1] = [field2] FROM [table1 T1], [table2 T2] WHERE [T1.field = T2field]" error in runtime..... field ' ' not found.
> obviously the tables and fields exists.
> When I use the same identical query syntax in VFP6 in editor command the query has been executed. Why ??

Sorry. I have no idea. I don't use VFP 6.0 (with ore without ADO) so it's hard to guess!

Regards
Andy Kramek
Microsoft MVP (Visual FoxPro)
Akron, OH, USA

ENTIRE THREAD

SQL Statement to Update Records in VFP6 Posted by kaustubh jambotkar @ 8/12/2004 9:43:36 AM
RE: SQL Statement to Update Records in VFP6 Posted by Koen Piller @ 8/12/2004 1:02:19 PM
RE: SQL Statement to Update Records in VFP6 Posted by kaustubh jambotkar @ 8/13/2004 10:30:14 AM
RE: SQL Statement to Update Records in VFP6 Posted by Andy Kramek @ 8/13/2004 1:10:35 PM
RE: SQL Statement to Update Records in VFP6 Posted by Andy Kramek @ 8/12/2004 1:26:43 PM
RE: SQL Statement to Update Records in VFP6 Posted by Giuliano Pigozzi @ 10/12/2004 3:53:47 PM
RE: SQL Statement to Update Records in VFP6 Posted by Andy Kramek @ 10/12/2004 4:35:36 PM