General information
Category:
Coding, syntax & commands
>>I need to import tables with long column names from an accounting database (btrieve) to tables in a new VFP database (New.DBC). Views for the accounting tables are already defined in a different database (Old.DBC).
>>
>>I wrote a procedure that creates New.DBC and scans Old.DBC to obtain name of all remote views. I though it would be possible to simply SELECT * FROM RemoteView and add the created table to New.DBC, but the created table only has 10 character column names. If a cursor was created instead of a table long names would persist, but then how would you add it to New.DBC?
>>
>>What is the simplest way to import the data with long column names?
>>
>>TIA,
>>
>>Alex
>
>If you created a cursor with correct names, can you just copy structure to the new table which is part of DBC and then insert from the cursor? This is just a thought.
Thank you Naomi.
Alex
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only