SQL Confusion

[Ruslan Zasukhin]

On 9/10/07 3:00 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

> 
> I think the confusion come from this:
> 
> It is now possible to write an updatestatement within a stored
> procedure( of course using sql way, since there is no API way inside
> procedures)
> 
> But there does not seem to be a sql way to put a lock on a record
> BEFORE updating it.
> 
> INSIDE a stored procedure we cannot say
> 
> put a lock on this record
> doUpdatestatement
> release lock

But why you need this ?


Note also, in procedures exists
    DECLARE CURSOR

But they not allow control locks.


Can you just explain your TASK and your PROBLEM  ?


-- 
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]