What is the SQL Syntax for updateing fields returned from a Binary Link ?

[Barry G. Sumpter]

Excellent!

Never would have nutted that one out myself!

Thanks

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ruslan Zasukhin
Sent: Friday, 14 September 2007 4:19 PM
To: valentina at lists.macserve.net
Subject: Re: What is the SQL Syntax for updateing fields returned from a
Binary Link ?

On 14/9/07 1:40 AM, "Barry G. Sumpter" <BarrySum at BigPond.Net.AU> wrote:

Hi Barry,
 
> I'm trying something like this but it's not happening.
> 
> UPDATE MenuItems
> SET MenuItems.Caption = "xxx"
> FROM Menus Left Outer JOIN MenuItems ON link_menus_1_M_menuitemsWHERE
> (((Menus.RecID)=2) AND ((MenuItems.Itemno)=100));

There is no such syntax

    UPDATE ... FROM ... WHERE

Exists 
    UPDATE ... WHERE.

I think more correct is something as

UPDATE MenuItems
SET MenuItems.Caption = "xxx"
WHERE
    RecID IN 
        ( SELECT MenuItems.RecID
          FROM Menus LEFT OUTER JOIN MenuItems
                     ON link_menus_1_M_menuitems
          WHERE Menus.RecID = 2 AND
                MenuItems.Itemno = 100
        );

Note, not tested.


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


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina