Myron,
Sorry for the confusion, I am attempting to APPEND from a text file into a table in a database. The id field in the table has a default value set from a function. When APPENDing SDF, the DEFAULT method is not firing, even if I use the FIELDS clause. I know I can append the information into a temp table without the id field and then append from the temp table into the "real" table, but I didn't want to go through the hassle. Any other suggestions???
Rex
>It will fire as long as you exclude the primarykey from the source
>file. You could use the Fields option of the Append function and
>not list the key field.
>-myron kirby-
>==============================================
>>Is there a way, using the DBC methods, of generating unique keys for records appended from another file? I am placing a unique key procedure in the DEFAULT method of a field, but it is not being triggered in the APPEND FROM statement.
>>
>>TIA
>>
>>Rex
Previous
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