SQL Confusion

[Bart Pietercil]

Hi Ruslan,

On 9-okt-07, at 12:26, Ruslan Zasukhin wrote:

>
>
> Bart, Cursor.Update()
>
>     this is NOT Class way!!!
>     this is SQL/API way in our terminology.
>
> Please read this article:
>
> http://www.valentina-db.com/dokuwiki/doku.php? 
> id=paradigma:public:en:documen
> tation:articles:coding_style
>

where in this article you work with cursor.Update()?. I only find  
cursor.UpdateRecord().

Okay, probably you mean cursor.UpdateRecord(), right?

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

Am I seeing this wrong?


THX

Bart