Hi Jesus,
You shouldn't use Multiple Update because this service is intended to update
more then one table and you have only one table to be updated.
Your problem is that DW can't find which rows are to be inserted and which
updated because all the rows are retrieved via an outer join and DW "thinks"
that all that rows exists in the database and can be only updated or deleted.
The way to tell the DW that a row is to be inserted or updated is to set its
status to NewModified! or DataModified! But in this case it's up to you to
decide how to set the status before Update() function. It would be also more
useful to set the status of each row right after retrieve, because all further
behavior would be then as usual.
The problem is how to detect which status the row has to be given. You should
retrieve and test the primary or foreign key column in table3, which would have
to be null only when the row doesn't exists in the database. That's the flag to
decide on the status that has to be set.
Does it work ?
Regards,
Zvonimir Kuntic
[EMAIL PROTECTED]
----- Original Message -----
From: Jesus Acosta <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, 01. September 2000. 06:09
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]
