| || |
Recordset Vs Timestamp fields
I was stuck while trying to store records of
a table into a recordset,by some trial & error
I figured out that the problem was due to
some of the timestamp data type fields in the
table,is there a way to cast the timestamp
fields into date time fields,I would like to cast
only the timestamp fields from a table with 50
columns with 10 timestamp columns.
Note:I got stuck with the following code due to the timestamp fields in the table
sqlQuery = "select * from current order by curr_id"
Set Rs_01 = db.Execute(sqlQuery)
If not Rs_01.EOF then arr_01 = Rs_01.GetRows
Re: Recordset Vs Timestamp fields
I guess you would need to write the query in any case and that would mean listing all the 50 fields and i dont think there is any other way around it except generating the query also at the run-time.