-
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
-
This problem occures only with my temporary columns. Updating a column like sanr, sabz works correct - even with MS SQL Server 7.0
-
Have you tried a temporary table?
