Information générale
Catégorie:
Codage, syntaxe et commandes
>>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement