Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary Key : Remote View
Message
From
03/02/2003 09:21:19
 
General information
Forum:
Visual FoxPro
Category:
CodeMine
Miscellaneous
Thread ID:
00747874
Message ID:
00748349
Views:
27
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform