Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Primary Key : Remote View
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
CodeMine
Titre:
Primary Key : Remote View
Divers
Thread ID:
00747874
Message ID:
00747874
Vues:
57
Hi. I have a DataFormManager wich is based upon a CDE dataenvironment. I defined a remote view in the CDE. When I try to save a new record, it always says : "Server could not assign primary key". The table on SQL Server generates the ID. I looked in the code and found that the line "SELECT @@IDENTITY AS Pk" does return a null value instead of the actual ID. If I run a query in SQL Server, the new record is not there yet. If I open the Data Session window and "Browse" the remote view, then the new record appears in the query in SQL Server. So, if I make a "Browse" before I save, it will work.

What event does a "Browse" launch that makes a buffered remote view to get updated ?

Thx

André
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform