General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Actually, I have looked at it ( a little :) ) and my reason for avoiding it is that APPEND BLANK violates the key's 'uniqueness' and so triggers an error. Lately, though I haven't been using the APPEND BLANK method, so maybe I'll revisit this issue.
You can use a Primary Key and still use APPEND BLANK - You probably want to use buffering for the tables/views you are using (at least row buffering)
and you can also set a "default value" function that will return the next available key for the Key field
Arnon
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only