Building a database: Zowie!

[Steve Tyron]

Holy smokes! I opened a VSC data file, gave it a name to save it as a 
test, and created a new procedure, pasting in your supplied info.

Sure I would need to tweak something, I ran it to find out where it 
stumble on my machine. Zap! There was my database with nice new column 
names and the date purged of the info record.

Thank you very much.

Steve

Vic Glassley wrote:
>> Related to my question about importing a CSV file vs. simply opening a
>> CSV file:
>>
>> I can create a CSV file with column headers as record No. 1, and give it
>> a specific name, but when I simply OPEN that file, my columns are
>> numbered and the first record holds the names they should have.
>>
>> Looking through options in the "info(" choices, it looks like all I can
>> get would be the count of records, etc.
>>
>> Question: what method would let me collect all contents of Record 1 into
>> an array ("lineNum, title, author, blurb..." etc) and then set the names
>> of the columns with that array?
>>     
>
> Maybe this will help. Someone on the list helped me with this some time ago.
>
> //€ Import data and have first record be field names.
>
> Local folder,file,type,FirstRow
> OpenFileDialog folder,file,type,"TEXT"
> if file = "" stop endif
> OpenFile  folderpath(folder) + file
> FirstRow = exportline()
> GoDesignSheet
> Field "Field Name"
> FormulaFill array(FirstRow,seq(),chr(9))
> NewGeneration
> GoSheet
> ClearRecord
>
> Good luck
> vic
>