Neither is any liability assumed for damages resulting from the use of the information contained herein.For information, please contact: Visual Fox Pro has excellent facilities for database application development utilising a client-server database management system to store data as a replacement for the native Fox Pro table files. Field1But when I try to execute this statement using the OLE DB connection I getthe following error:"Command contains unrecognized phrase/keyword"Is there another way to what I am trying to do above to make it work? Raj Post by Raj Parulekarspecifically I need to set the value of a field in one table to thevalue of a field in another table based on a join.Now this can bedone in SQL Server (or I would think in any other ANSI SQL compliantdatabase)Post by Raj Parulekar I am trying to Update some fields in a VFP database through an "OLE DBUPDATE t1SET t1. It contained the fastest PC-based database engine available at the time.Fox Technologies merged with Microsoft in 1992, after which the software acquired further features and the prefix "Visual".Learn how to build a data access layer to communicate with either DBFs or SQL Server.Even cooler, you'll do it with no code to change when you move from DBFs to SQL tables, and an upsizing wizard to migrate the data for you.
Although every precaution has been taken in the preparation of this document, the publisher and author assume no responsibility for errors or omissions.
Hi, I am trying to Update some fields in a VFP database through an "OLE DBProvider for VFP" connection (from within a DTS package), specifically Ineed to set the value of a field in one table to the value of a field inanother table based on a join. I guess we would not be able to useco-related subqueries then either, right?
Now this can be done in SQL Server (or Iwould think in any other ANSI SQL compliant database) using the followingsyntax: UPDATE t1SET t1. Thanks for your response, I lookforward to your feedback. Raj Post by Raj Parulekarspecifically I need to set the value of a field in one table to thevalue of a field in another table based on a join.
The use of the If you are not familiar with making connections to client-server databases and the use of table buffering with Visual Fox Pro you will need further study or purchase of the redware Fox Pro SQL Server Handbook (available from
Optimisation features are also not covered in this document which will be integrated into the next edition of the Handbook.