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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement