At 05:17 PM 21/09/2004 +0000, you wrote:

>the sql has multiple tables in it for its select
>obviously only table is being updated
>however when the dataset is put into edit mode
>i get the above error

Set PessimisticLocking False. It is not logically valid for a joined query
unless either
a) you set a valid custom LockSQL statement
or
b) you set the KeyRelation property

In either of those cases, PessimisticLocking will still not be valid if you
do not have the correct KeyLinks settings for the dataset.

Helen