I kinda got lost...
Here's how I interpret your question... if that's wrong, my answer might not
fit... let me know.
You have three tables, table1, table2 and table3. Table3 is a notes field.
Not all combination of table1 and table2 records have a corresponding table3
record so you use an outer join. You want to be able to add a new table3
record if someone types in a notes field.
My solution:
Create the datawindow and set table3 as your update. In the datawindow
itemChanged event for the note column, set the key values for table3 based
on the values from table1 (or table2). Then the update should insert (or
update) only table3.
Let me know how that works.
D
----- Original Message -----
From: Jesus Acosta <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 31, 2000 11:09 PM
Subject: PFCSIG Multiple Update Service.
> Hi,
> We have a DW in a tabpage and one has SELECT
> statement as a source, something like this, for
> example:
>
> select A.col1, A.Col2, B.Col3
> from table1 A, table2 B
> where A.col1 = B.col1
> and A.col1 = "X"
> union
> select A.col1, A.Col2, B.Col3
> from table1 A, table2 B
> where A.col1 = B.col1
> and B.Col2 = "Y"
>
> (The union has no sense is this example but I just
> added as an example to give an idea of the original)
>
> Originally this DW was only a report, but now the
> user had the great idea to write Notes in a new
> column.
>
> The SELECT is kinda long and complicated and one of
> our developers created a new table with the proper
> Pk's and the Notes field, lets say table3. Right now
> this table has no rows.
>
> It's posible to show this new field in the DW, with
> and outer join, but what we want to do is when user
> type information in the Notes field insert a row Only
> in this table3 from the DW.
>
> Any ideas?
> Should I use the multiple Update Service?
>
> Thanks for your help, I'd really appreciate it
> Jes
>
>
>
>
> =====
> ~~~~~~~~~~~~~~~~~~~~~~~~
> Jes�s Acosta P.
> [EMAIL PROTECTED]
> ~~~~~~~~~~~~~~~~~~~~~~~~
> Dance like no one's watching, love like you'll never be hurt, sing like no
one's listening, live like it's heaven on earth. -- William Pukey
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS,
ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help
pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
>
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
