Dynaset using JOIN not updatable? 
Author Message
 Dynaset using JOIN not updatable?

When I set a FoxPro 2.5 database dynaset and using SQL keyword JOIN to
combine two tables, the dynaset become not updatable. If I open these
tables seperately, both of them are updatable. What's the problem?

Fri, 26 Jun 1998 03:00:00 GMT  
 Dynaset using JOIN not updatable?
It seems (although my experience is with SQL Server) that the
ODBC driver doesn't allow the updating of recordsets created
from multiple tables.  Which is rather frustrating.

My work around was to write a whole bunch of code which
determines whether or not the dynaset was from mulitiple tables,
and then building an "update ... set..values" statement
manually.  Which is a royal pain.


Tue, 30 Jun 1998 03:00:00 GMT  
 [ 2 post ] 

 Relevant Pages 

1. Dynaset not Updatable (SQL Server)

2. SQL Server dynaset not updatable.

3. Help: The dynaset is always not updatable :~(

4. SQL Server JOINed recordsets not updatable?

5. updatable dynaset via OD

6. updatable dynaset via ODBC SQLServer

7. Updatable dynaset from multiple tables

8. updatable? Jet Recordset with LEFT JOIN

9. Joins, Cursors and Updatable Recordsets with RDO

10. AddNew into updatable join ?

11. Updatable Joins

12. AddNew into updatable join ?


Powered by phpBB® Forum Software