Joins, Cursors and Updatable Recordsets with RDO 
Author Message
 Joins, Cursors and Updatable Recordsets with RDO

Another little question...

I've been trying to use the 'new, optimized for SQL Server' Remote
Data Objects to access a resultset which was created as a result of
an outer join on two tables.  (using the a WHERE statement in a SQL
statement.)

However, it seems that the resulting resultset is only read-only- I get an
error that 'Cursor is read only'..  Is there anyway to set the cursor
so that I can update the resultset again?

Or is it impossible to update an rdoResultset that is based on two tables
in the database?

It seems a little odd that the objects would behave like this, at least to
my mind.

Thanks,
Duncan.



Tue, 16 Jun 1998 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. updatable? Jet Recordset with LEFT JOIN

2. SQL Server JOINed recordsets not updatable?

3. Dynaset using JOIN not updatable?

4. AddNew into updatable join ?

5. Updatable Joins

6. AddNew into updatable join ?

7. Static cursors updatable?

8. Connection cursor location vs. Recordset cursor location

9. Creating a new recordset by joining 2 existing recordsets

10. How to make recordset updatable

11. Recordset not updatable

12. recordset updatable for me, but not for other users

 

 
Powered by phpBB® Forum Software