All,
"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"
Correct me if I'm wrong, my analysis is he SHOULD use the Multiple Table
Update Service because:
"one of our developers created a new table with the proper Pk's and the
Notes field"
Sounds to me like he has a child table with a 0:1 relationship.
Sounds like the Multi Table Update RI (referential integrity) Extension
developed by Stephen Pareles and available from the PFC-Guide website may
be just the ticket...
Lester
-----Original Message-----
From: Laforce, Lester
Sent: Friday, September 01, 2000 7:17 AM
To: 'Jesus Acosta'
Subject: RE: PFCSIG Multiple Update Service.
Yes...
IMHO, 'sounds like a job for...
Multitable Update DataWindow Service
(n_cst_dwsrv_multitable, the DataWindow multitable update service object)
You may be interested in this link:
http://www.pfcguide.com/faq/faq_mtupd.asp
You may find this useful also;
Multi Table Update RI Extension.
http://www.pfcguide.com/extensions/ext_0006.asp
HTH
Buenas suerte,
Lester LaForce
[EMAIL PROTECTED]
Sr. Software Developer (Contractor)
Future Technologies, Inc.
Armed Forces Institute of Pathology
Washington DC
-----Original Message-----
From: Jesus Acosta [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 12:10 AM
To: [EMAIL PROTECTED]
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]
