06-21-2003, 07:21 PM
Join Date: Oct 2002
Somebody wrote this example for me but I do not understan this SQL Statement.
This procedure supose to read data from a DBGrid each column and write to the Database in a recordset.
'dimensions of a variable, based on number of colums
'All the cells of a row are read into RowContents variable and then
'put into a database. After one row is processed, we proceed to the
For i = 0 to .Rows - 1
.Row = i
For j = 0 to .Cols - 1
.Col = j
RowContents(j) = .Text
'put the values in a database
sSQL = "UPDATE YourTable SET Field1 = '" & RowContents(1) & "' ..."
Somebody please, should tell me how to write to the recordset fields?
Thanks & Regards