🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #6108

CSV-Text files

#6108
From: J.Reyneke
Date: Tue, 19 Sep 2000 00:00
37 lines
1914 bytes
Hi there,

I'm a student trying to use CppB3 to design transformers.

I created tables containing the data I need in Excel and saved it as both
.TXT and .CSV files.
"
k17    23.4    5.67    768
u21    45.3    6.78    544
"
I place a TTable component on the form and change the DatabaseName property
to path for the data file.
"C:\Data"
In the table name I put the filename "Coredata.csv" and I changed the
TableType property to ttASCII.
According to the help file this will tell C to expect a comma-delimited text
file.
However when I link this to a DBGrid component with the Datasource I get a
table looking like this:

Field0                          "blank"     "blank" ......
[k17,23.4,5.67,768]

All of my row's data is placed in one column.

Playing around with FieldDefs and Index properties has not helped me at all.
Nor can I specify the name for the field "FIELD0" or add more fieldnames I
don't get any visual info.
A DBEditBox does the same.

I can however scroll through the rows with a navigationbar.

Please, someone help me cause I need to complete this project ASAP.

Johann Reyneke
BIng (Electrical) IV
s9309187@student.up.ac.za
Technical Details
Message-ID: <39c76e0c_1@dnews>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,275f45c4f50ab27b,start
X-Google-Attributes: gid10698b,public
X-Google-Thread: 102541,275f45c4f50ab27b,start
X-Google-Attributes: gid102541,public
X-Google-Thread: 10bf25,275f45c4f50ab27b,start
X-Google-Attributes: gid10bf25,public
From: "J.Reyneke" <s9309187@student.up.ac.za>
Subject: CSV-Text files
Date: 2000/09/19
Message-ID: <39c76e0c_1@dnews>
X-Deja-AN: 671612974
X-Trace: 19 Sep 2000 06:45:48 -0800, 196.30.232.187
X-MSMail-Priority: Normal
X-Priority: 3
Newsgroups: borland.public.cppbuilder.database.ado,borland.public.cppbuilder.database.desktop,borland.public.cppbuilder.students
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300