SQLexecute UPDATE error (V4MD 1.11)

[Ruslan Zasukhin]

On 3/25/05 1:37 PM, "Giacomo Vernoni" <giacomo at way-out.it> wrote:

> Hi Ruslan, I made some other tests.
> 
> It seems that some joins work, but others don't.
> 
> This query shuts down Director with an error 363:
> 
> SELECT * FROM table1, table2 WHERE table1.field1 = table2.field1 AND
> table2.field2 = 1 AND table1.field3 = 1 ORDER BY field4, field1"
> 
> 
> This query is OK:
> 
> SELECT DISTINCT field1, field2, field3, field4 FROM table1, table2
> WHERE table1.field3 = table2.field3 AND field4 >= 50.8000 AND field4 <=
> 101.6000
> 
> 
> Hope this helps...

363 -- record locks error

I assume that up to now you have ignore 3 last parameters in the
        SqlSelect()
        Vcursor()

?

Do you know about e.g. this parameters:
        ServerSide, ReadWrite, Random ?


May be you can get fast result if you will specify NoLocks for all your
cursors.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------