[VJDK] Valentina DB

[Ruslan Zasukhin]

On 4/22/05 5:42 PM, "Tomas Dikk" <t.dikk at se-dd.com> wrote:

> hi ruslan
> 
> thanks for your answers, i solved the problem with the parameter on sqlselect,
> so that the cursor has no lock. (yes you were right, i use java). all is ok
> now!
> 
> can you answer me one more question:
> 
> why does
> 
> cursor = db.sqlSelect("SELECT MAX(id) FROM fingerprint");
> 
> not need the "no lock parameter" (it works with default settings for cursor
> lock on records and all is ok)

Because it build new TMP table I think, so it not locks original table.
The same do GROUP BY, DISTINCT

> and
> 
> cursor = db.sqlSelect("SELECT * FROM fingerprint WHERE userid = " +
> user.get_id(), (short)1, (short)1, (short)1);
> 
> needs to be changed to "no lock option" so that it works (without additional
> parameters it doesnt work)
> 
> thanks and have a nice weekend!

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