Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Primary Key : Remote View
Message
De
03/02/2003 09:21:19
 
Information générale
Forum:
Visual FoxPro
Catégorie:
CodeMine
Divers
Thread ID:
00747874
Message ID:
00748349
Vues:
28
>My ID is SQL is a uniqueidentifier with ROWDID() as default values.

Are you using a GUID as the PK value -- where is ROWDID() coming from?

>I am using Default Mode.

Presume you mean row?

>Yes, I tracked it. It is when I hit the "Save button". But, for some reason I don't know, the new record is in the buffer but not in SQL Server yet. That is why I don't get any value from GetLastPK.

What workarea value is specified in your save button?

>But right after i do a "Browse" to the view, when a new record is there but not saved, I can see the new record in SQL Server.

Browsing the view appears to be just committing any unsaved records, implying that you are row buffered.

>Do you think I should force a tableupdate ?

Definately not! The Codemine update routines work just fine. This is ultimately what they do. I am currently working with CM & SQL server and I am having no problems with it whatsoever.

>Or is it a setting problem in my view (or in the CDE) ?

This is the most likely and probably in the CDE. If browsing the view is committing the records, then the view sounds OK. So, the cursor object's settings in the CDE sound suspect. Maybe you could post the values in the cursor's property sheet - just the ones that have custom values in them (non-default).

Best
-=Gary
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform