>Hello all
>
>how to update the view which doesn't have a key field.any examples please.
>what should be the buffering value for this type of view.
>
>txs for any help

You can use something like this:

sqlexec(gnConnHandle, "Update TABLE_NAME SET COLUMN_NAME = VALUE WHERE...)

But still WHERE clause must contain something to uniquely identify the particular record.