Kbase 21268: SQL-92: ADO AbsolutePosition Property Always Returns -1
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/10/2008 |
|
SUMMARY:
If you are attempting to use the AbsolutePosition property of ADO (ActiveX Data Object) in a Visual Basic application with the MERANT SQL-92 driver and the AbsolutePosition property always returns -1 you can resolve this by modifying your code.
Before you open your ADO Recordset you need to insert a line of code
similar to the following (this code may be slightly different depending on how you are defining the Recordset).
SomeADORecordset.Properties("IRowsetScroll").Value = True
EXPLANATION:
The reason for having to make this modification is that (according to Microsoft Support) an OLEDB property must be enabled to support the AbsolutePosition property with any ODBC driver.