Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Showing recent commited data of other user to me.
Message
From
09/02/2007 10:58:58
 
 
To
09/02/2007 10:53:12
Mk Sharma
Shrishti Solutions
Mumbai, India
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01193602
Message ID:
01194085
Views:
23
>When you add new data to a grid, you INSERT records to the cursor. On save point you scan the cursor, insert new records (with zero primary key) to the table, and update exisitng records
>(search by primary key) in the table.
>
>
>please explain me some more about (with zero primary key) .
>
>please explain me some more about (search by primary key) .
>
>please with example (if possible).
>
>warm regards,
>mk.

Every table is supposed to have a primary key, preferably integer number. When you fill the cursor all records carry this key. New records added during edit session will have 0 in that field. So on save point your code will recognise if record is new or existing and to update existing record you will firstly Seek in table by using the key.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform