Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Multitable Update
18 views
Skip to first unread message
PowerObject!
Jul 23, 2003, 12:13:28 PM7/23/03
to
When you change the name of a column using Computed-Columns (Aliases) and
even the names of the tables in the SELECT statement, the DW fails in its
update process because it cannot find the columns/tables that were renamed
in the SQL. Unless you retain the column and table names in the SELECT
statement, your update will not work as you will get an Invalid
Table/Column name... error. Aliasing with the original column names may be
required in case of multi-table select because the dw generates its own
column names but if you want to update the tables, you need to give the
original column names in the ALIAS clauses.
even the names of the tables in the SELECT statement, the DW fails in its
update process because it cannot find the columns/tables that were renamed
in the SQL. Unless you retain the column and table names in the SELECT
statement, your update will not work as you will get an Invalid
Table/Column name... error. Aliasing with the original column names may be
required in case of multi-table select because the dw generates its own
column names but if you want to update the tables, you need to give the
original column names in the ALIAS clauses.
---
PowerObject!
-----------------------------------------
http://Groups.Yahoo.com/group/PowerObject
PowerBuilder / PFC Developers' Group
Philip_Salgannik
Jul 23, 2003, 11:55:59 AM7/23/03
to
Did you try it?
AlExis Glinski
Jul 23, 2003, 10:51:42 AM7/23/03
to
Hi.
It is possible to use multitable update in DataWindow, where I use aliases
for columns from different tables ???
Bye.
AlExis Glinski
Jul 24, 2003, 2:16:39 AM7/24/03
to
This is SQL-example:
SELECT doc.doc_number, doc.doc_date,
doc_lp1.name_short AS doc_lp1_name_short,
doc_lp2.name_short AS doc_lp2_name_short
FROM doc
LEFT OUTER JOIN doc_legal_person doc_lp1 ON doc.doc_id = doc_lp1.doc_id AND
doc_lp1.no = 1
LEFT OUTER JOIN doc_legal_person doc_lp2 ON doc.doc_id = doc_lp2.doc_id AND
doc_lp2.no = 2
How I can update doc_lp1_name_short and doc_lp2_name_short using multitable
update service ???
0 new messages