Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append from two tables into a cursor
Message
From
24/09/2007 18:19:42
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01256480
Message ID:
01256513
Views:
16
>The two tables have almost the same structure, but one of the
>the tables may have one field or two more
>(VFP 9)

If you want to retain the extra fields you can
SELECT * FROM tableWithExtraFields INTO CURSOR newCursor
APPEND FROM tableWithMissingFields
The extra fields will be filled with the default value for that data type.

If you want only the common fields you can
SELECT * FROM tableWithMissingFields INTO CURSOR newCursor
APPEND FROM tableWithExtraFields
Previous
Reply
Map
View

Click here to load this message in the networking platform