Update & SQL

[Ruslan Zasukhin]

On 23/2/07 6:06 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

Hi Bart,

> Wondering how Valentina handles locks when using the update sql syntax.
> 
> If a lock has been set on a record

By other user, right?

> and using sql (update..... where
> recid = lockedrecordrecid) what will happen?

You will get ERROR which says something as

    Record with RecID=xxx is locked.
 
> I know I could build a cursor that is readwrite but the update sql
> syntax refers to a tablename. There seems to be no way to say in sql

But UPDATE need in any case setup READWRITE lock on updated records.
 
> update mycursor set.....
> 
> Confused


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]