At 08:42 AM 23/04/2004, you wrote:

>Hello all,
>
>Sometimes we need to import data into our database and many times the key
>primary key field is supplied during the import. Is there a way for me to
>check each generator against the table that uses it, see what the highest
>value of the pk field is and increment the generator used for that field by
>one more?
>
>Or is it something I will to hard code for each table? I would be nice to
>create either a SP or a tight looping routine from the client do it.

Why are you importing the PK? Having had to do this often before, why don't
you let each table generate its' own PK values?

Regards

Tim


[Non-text portions of this message have been removed]