cannot update recordset

[frank ashley]

My code calls a DLL which executes a command object which calls a stored proc' on SQL7 which is then passed out as a recordset into my calling app'.

All hunky-dory except that I cannot update any of the values in the recordset.

The recordset properties are as follows;

CursorLocation=adUseClient
Locktype=adOpenStatic

Is the command object the culprit?

[Clunietp]

Is your command object passing back a disconnected recordset?

[JHausmann]

Does the recordset contain objects from more than one table?

[frank ashley]

Clunietp

No


JHausmann

Other calls in the DLL will (just writing a code stub at the moment, trying to establish the principle).