SQLexecute UPDATE error (V4MD 1.11)

[Giacomo Vernoni]

No, I didn't ignore the 3 parameters... in fact, I had to change most 
of my vCursor when I upgraded from Xtra 1.9.7 to 1.11.

Most (not all) of the queries are: 1 (client), 1 (no lock), 2 (random).

All worked with "old" version 1.11, but I will try to make ALL VCURSORS 
NO-LOCK and I will let you know.

Giacomo



On 25 mar 2005, at 14:58, Ruslan Zasukhin wrote:

> 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
> -------------------------------------------------------------
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>