General information
Category:
Coding, syntax & commands
Title:
Primary Key Stored Procedure not firing on Append From
got m'self a cheap and cheerful (and effective) stored procedure for assigning primary keys which is called from the default value for the relevant field.
It works for "append blank" or "insert into" but not for "append from"
I can see that "append from" may, of course, add a whole bunch of records and thus call the routine a whole bunch of times. But a) I've never come across anything that says it can't be done that way and b) if it is going to fall over I'd have expected to fall over at the second appended record. It doesn't even manage one.
what have I missed? and, if it can't be done that way for "Append From", how else can we do it?
Harry
Next
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