Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Handling ODBC Errors with CursorAdapter
Message
De
10/06/2003 09:36:09
Omar Jonsson
Baendasamtok Islands
Iceland
 
 
À
06/06/2003 17:24:42
Omar Jonsson
Baendasamtok Islands
Iceland
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00797306
Message ID:
00798337
Vues:
29
>"My memory may be faulty on this, but I do not think Remote Views of SQL Server or Oracle tables returned errors when an update was issued via TABLEUPDATE() on a record that no longer existed."
>
>This should be easy to test and for me it is essential to know if this is a new issue with the CursorAdapter or something I have missed when using Remote Views.

And now have tested this on my Remote Views using Oracle 9 and Client Access for DB2 ODBC drivers
and I get " Update Conflict" and Tableupdate() returns .F. when I try to update deleted record.

And when I tested the example on bottom of page 6 in the Code Magazine Article on my remote views, I was not able to produce the same results as
it reported for CursorAdapters. Tableupdate() did always return false
when the update was unsuccessful and true when the update was successful.

So my conclusion is that Remote Views using Oracle 9 and Client Access for DB2 ODBC drivers handle updates correctly.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform