SQLexecute UPDATE error (V4MD 1.11)

[Giacomo Vernoni]

Hi Ruslan,

I have made no-lock ALL the queries in my application (many many of 
them!).
Before now, only some of the queries (the main ones) were nolock.

Everything seems to work! (For now...)

I think you can compile the Windows version... I will do some more 
tests during the week-end and I will eventually let you know next week 
if there is any problem.

Just let me know when the file is available on the server.

Thank you very much, Ruslan.

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
>