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


> Hi
> > Out of these tables two are billhd, billdt which stores information about the billno , customer , item , quantity etc
> > the header table contains of logical field as isauth which when set to .t. posts the billdt information into bin tables
> >
> > i am using scan command to do it,
> > i want to know whethe i can use sql statment to post the data from billdt table to bin tables.
> >
> > the quantity should get minus ,
>
> If you mean a statement in form:
>
>
> INSERT INTO [table] SELECT [fields] FROM [table]
> 

>
> Then the answer is no! This type of query is not supported by VFP 6.0, you need to upgrade to V9.0 for that.
>
> Regards
> Andy Kramek
> Microsoft MVP (Visual FoxPro)
> Akron, OH, USA

I Understood ???
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 ??









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