Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Handy COPY FROM functionality?
I am writing a utility to import Quickbooks customer and charge data. The IIF file (tab-delimited ascii) contains a header record which lists the field names. I need to support multiple versions of Quickbooks and I am not sure if the exported ascii files are identical in each version. However, I do believe that the field names will remain consistent (at least the basic ones I need).
What I would like to do is to create a cursor with the field names matching the field list provided in the ascii file. Then I would be able to simply reference the fields I want, and I don't need to worry about extra fields or varying field orders.
I know how to create the cursor programatically by extracting the header record, but am I missing something? Does foxpro already have a function to handle this?
Just curious?
Thanks,
David
Suivant
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