Hi George,

Thanks for your reply.
Im using PFC multitable update service.
I found this site which is the best solution to my
situation.http://www.dvl-software.com/pbtips/multitable.html
The problem is, download link is broken.

Maybe someone had this extension before. Please post it here.

Thanks
JB




________________________________
From: "Mikhailovsky, George" <George.Mikhailovsky@...>
To: "PowerObject@yahoogroups.com" <PowerObject@yahoogroups.com>
Sent: Friday, July 3, 2009 23:44:58
Subject: RE: [PowerObject] multitable update with left join...





Hi JB,

I think that if you change Table to Update, make all the columns of the 1st
table not updateable and all the columns of the second one updateable, and
finally change status of each (or each modified?) row from DataModified! to
NewModified! it will work although never tried this myself.

But I would implement another solution that needs far less coding:

Ø Update your DataWindow and update its Table to Update (1st table).

Ø Create another DataObject with the same SQL but with 2nd table as Table to
Update and respectable updateable columns.

Ø Create DataStore and associate created DataObject with it.

Ø After updating your DataWindow insert/copy its rows in a loop into created
DataStore.

Ø Update the DataStore.

Thank you,

George

From: PowerObject@ yahoogroups. com [mailto:PowerObject@ yahoogroups. com] On
Behalf Of J B
Sent: Thursday, July 02, 2009 8:43 PM
To: PowerObject@ yahoogroups. com
Subject: [PowerObject] multitable update with left join...

Hello guys,

I have a datawindow with left join...I want to UPDATE the first table and do an
INSERT on the other table.
How can I do this in multitable update service? Im thinking of manipulating it
thru setitemstatus. ..but im not sure if this one will work.
Anyone encounter this situation?

Cheers,
JB

Get your preferred Email name!
Now you can @ymail.com and @rocketmail. com.
http://mail. promotions. yahoo.com/ newdomains/ aa/

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





New Email names for you!
Get the Email name you&#39;ve always wanted on the new @ymail and @rocketmail.
Hurry before someone else does!
http://mail.promotions.yahoo.com/newdomains/aa/

[Non-text portions of this message have been removed]