I also tested it and was surprised that on the SDF
Append with the Fields clause the
field default is not firing. I do most of my imports with
low level file functions so I have not experienced this.
I would think this is a bug and should be reported.
As a kludge I had read in a message thread that you
can update a field within the Dbc.Table.Update. (I
have not tried this.) Maybe you could put something
like:
IF EMPTY(RecKey)
REPLACE RecKey WITH GetKey()
ENDIF
Again, this is not something I have experimented with.
-myron kirby-
===========================================
>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