UDF in view definition - ADO cursorType error

  • I've created a table-type UDF and use it in a view definition. Querying this view in Query Analyzer produces the correct results without error. However if I try to open an Server-side, Keyset ADO recordset on this view it always open as a ForwardOnly recordset.

    Does anybody know if/how I can open a Keyset ADO recordset on a view that uses a UDF in its definition?

  • More info - I can open a Keyset recordset okay IF the lockType is ReadOnly. Any other lockType and the cursorType gets automatically set to forwardOnly and the lockType gets automatically set to readOnly.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply