ADO 2.1 and MSSql Server 7.0

[MartinE]

I use an ADO 2.1 SP2 control to connect to an MS SQL Server.

I have a recordset (Cursorlocation=ClientSide, Cursortype=Static, LockType=Optimistic)with following SQL statement: "SELECT sanr, sabz, 0 AS sel, 0 AS abspos FROM PSA ORDER by sabz"

As you can see i use the select statement to produce new temporary columns (sel, abspos) for my application.

After i have opened the recordset i update the abspos field (rs!abspos=index, rs.Update).

Everything works right with an SQL Server 6.5, but using SQL Server 7.0 generates an error when i update the abspos field.

Thanx in advance

Martin

[MartinE]

This problem occures only with my temporary columns. Updating a column like sanr, sabz works correct - even with MS SQL Server 7.0

[JHausmann]

Have you tried a temporary table?