Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Who should create the PK, view or table?
Message
 
To
14/09/2004 05:17:33
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00941514
Message ID:
00941945
Views:
16
I am late here, but I have thought about this in my own framework and determined my old ways were the best. I have a separate table with PK values in them and have the biz object increment from this table at the time the view record is added.

This alleviates a lot of problems, but mainly having the PK available for child view records before I save them all. If the view is never saved, then the number is wasted, but you can always create another field for things like order numbers (that you don't want missing values in) that gets added at the time the record is saved.
Scott McDaniel
MCP VFP Desktop
Previous
Reply
Map
View

Click here to load this message in the networking platform