Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table without PK - do I need one for View?
Message
 
 
To
25/10/2001 13:31:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00573010
Message ID:
00573293
Views:
26
>I don't think you need the NextID stuff if you need a simple PK, just add a C(10) field and populate it with SYS(2015) when a new record is added either through INSERT INTO or REPLACE.
>
>>Yes, I'm thinking, this might be necessary, and also the simplest solution. On the other hand, I now would need to add NextID table, SP, etc. I was hoping, may be there is workaround... Anyway, I just accidentally zaped this table, so adding PK would not be a big problem... :)

C(10) is more expansive than Integer. I currently decided to use composite key.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform