Thread View: borland.public.cppbuilder.database.ado
2 messages
2 total messages
Started by J.Reyneke
Tue, 19 Sep 2000 00:00
CSV-Text files
Author: J.Reyneke
Date: Tue, 19 Sep 2000 00:00
Date: Tue, 19 Sep 2000 00:00
37 lines
1914 bytes
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
Re: CSV-Text files
Author: John
Date: Wed, 20 Sep 2000 00:00
Date: Wed, 20 Sep 2000 00:00
10 lines
944 bytes
944 bytes
Hi, BDE creates for ASCII tables also file .sch, which has information about structure. Here is example: [COUNTRY] Filetype=Fixed CharSet=ascii Field1=Name,Char,24,00,00 Field2=Capital,Char,24,00,24
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads