Infralution Support

[rp]

I switched the database my program is using from Access to Firebird, and everything has gone fine so far, except when I use the VirtualRecordSet.FindUsingPrimaryKey method it's returning -2.

The docs say it should return "-1" if the record isn't found. However, I've confirmed the record is there -- can you shed any light on this?

[Infralution]

Below is the code that the FindUsingPrimaryKey method uses to locate the record in the recordset:

[rp]

I've tried using INTEGER, BIGINT, and VARCHAR field types as the primary key. It doesn't appear to be the primary key field type causing this issue.

I think I may have found the problem. What cursor types and cursor locations does VDO support?

It appears the default cursor type and location setup for VDO is:

adUseServer
adOpenKeySet

Which the Firebird ODBC driver appears to have forced to:

adUseServer
adForwardOnly

Which in turn caused a freshly created Recordset object to do this:

Recordset.RecordCount returns -1
Recordset.AbsolutePosition returns adPosUnknown (I'm guessing this equals -1)
Recordset.EOF return False

Your code should probably check for this situation, and possibly throw an exception stating "ForwardOnly" cursors aren't supported instead of returning -2.

I think I found a workaround to this by setting the cursor location on the ADODB Connection object to adUseClient, and leaving the cursor type set to the default, adOpenKeyset. RecordCount seems to be returning correct values now.

Thank you for the clues!