Using datatype Text (SQLServer) or PM (Access) with ADO
Posted on 1999-01-15
After I have inspected the value of a column with datatype PM (or Text in SQLServer) using an ADO recordset the value vanishes into thin air!
dim varA as variant, varB as variant
'varA now contains data
'varB now contains NULL
Also, if I reference the value of a PM-column that is located AFTER a column of another type, before I reference the other column, the values of the column before my PM-column is reset.
Ex: If the table looks like this:
PM1 Int1 Int2 PM2
If I reference PM2 before I reference Int1 or Int2 the
values in Int1 and Int2 become zero.
Help me, anyone...?