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