>Hi,
> How could I know which field is uniquness in run time in order to take proper action to recover error?
>
>Thank you
Not sure. It depends on how things are set up I guess(I don't know enough about your program).
You can test which fields are keys using some sqlgetprop commands if you are working with remote views or sql pass thru.
You can figure it all out ahead of time and store the key fields in a table.
Does that help? If it doesn't can you tell me more about what you are doing?
Are you using a server database?
Native tables?
tables in a .dbc?
Why don't you know the key fields of your own application?
etc...
--Todd Sherman
-Wake Up! Smell the Coffee!