Transferring Data Between General Fields ProgrammaticallyID: Q131306 3.00 WINDOWS The information in this article applies to:
SUMMARYIn Visual FoxPro, it is now possible to update General Fields with the INSERT SQL, UPDATE SQL, and REPLACE commands. These new capabilities are documented in this article.
MORE INFORMATIONIn Visual FoxPro, the REPLACE command has been enhanced. It is now possible to replace general field information from one table to another. For example:
You can also move information within a record in the same way. For example:
The INSERT SQL command has also been enhanced, making it possible to add a
new record to a table and place information in a general field in the table
when the information is contained in a general field of a different table.
For example:
The source table must be open; the general field is inserted from the
current record in that source table.
The UPDATE SQL command has been enhanced, making it possible to update a record with information from another table. For example:
The source table must be open; the general field is inserted from the
current record in that source table.
Additional reference words: 3.00 VFoxWin KBCategory: KBSubcategory: FxprgGeneral
|
Last Reviewed: May 22, 1998 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |