k_ride
Jun 30th, 2000, 07:12 AM
I have a database made out of a delimited ASCII file at runtime. Populating the DB is a no brainer, but I don't seem to be able to bind a flexgrid on my form to the database with success.
That is, the grid gets bound to the DB and the header columns are neatly filled with the DB keys, but when I read the data from the file to the DB (and this goes OK as a few textboxes bound to the DB show the data correctly) the grid stays as empty as my head.
So the question actually is, how can I get the flexgrid to update and add rows in sync with the database?
K
Oh, and by the way: Is there a faster way to populate the recordset than with
With rs
.AddNew
.Fields.Item("EventID") = i
'and so on...
End With
?
That is, the grid gets bound to the DB and the header columns are neatly filled with the DB keys, but when I read the data from the file to the DB (and this goes OK as a few textboxes bound to the DB show the data correctly) the grid stays as empty as my head.
So the question actually is, how can I get the flexgrid to update and add rows in sync with the database?
K
Oh, and by the way: Is there a faster way to populate the recordset than with
With rs
.AddNew
.Fields.Item("EventID") = i
'and so on...
End With
?