SQLexecute UPDATE error (V4MD 1.11)

[Giacomo Vernoni]

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

Giacomo

On 25 mar 2005, at 12:01, Ruslan Zasukhin wrote:

> On 3/25/05 12:01 PM, "Giacomo Vernoni" <giacomo at way-out.it> wrote:
>
>> I had an appointment on Friday 25 (today in Italy) and I managed to
>> postpone it to next week, but I don't know what to say the next 
>> time...
>> please help me!
>
> Please download again V4MD_Carbon.
>
>     Xtra should be todays build.
>
> Let me know if this one works.
>
> Then I will build Windows version.
>
> -- 
> 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
>