Scenario.
1.- An MS-SQL 7.0 Table with: Name, Address and a Timestamp
2.- Using ADO, retrieve some rows with some king of select statement… into a recordset
If I move the recordset into the Sheridan SSDBGRID control, the column of the timestamp value turns on “blank”!. This is a limitation of the Sheridan Datagrid Object (SSDBGRID.ocx) It can’t hold Binary data.
Question: Need a Function (VB or SQL) that allows to convert the readed Timestamp data into TEXT or DATE (something to be able to insert into the SSDBGRID), and then BACK to it’s originally Timestamp Value (in order to check if that record has been changed or not)
IF I use a Variant variable to hold the timestamp value (insted of using the grid SSDBGRID) the code works fine.
(I need the grid! not an array bounded to the datagrid !!!)
Thanks
