Re: Need To Dummy-Down Oracle

From: Michael Smith <mds_at_teleport.com>
Date: Sun, 06 Dec 1998 00:04:05 GMT
Message-ID: <3669CA12.F5DD27AC@teleport.com>

There is no need to disable the referential integrity restraints on the database - the problem is in your datawindow. Check the "Update Properties ..." menu item for the "Rows" menu in your datawindow object and you will probably find that the columns you want to update are not specified as allowing updates.

This is one of the most common datawindow problems. When you change a datawindow after it was originally created, PowerBuilder often requires that you manually specify the new column update properties (I suspect that this is for safety purposes).

HTH,
Michael Smith
Certified PowerBuilder Developer

Doug Stone wrote:

> Hi. I have to implement, in Oracle, a db that includes duplicate column
> names.
>
> For instance, emp_id is in the employee table, and in the address table.
>
> The application was build with PowerBuilder datawindows.
>
> If I setup correct RI between all the duplicate column names, the
> datawindows will fail.
>
> Does anyone know how I can, temporarily, disable Oracle insistence on unique
> column names?
>
> Thank you,
> Doug
Received on Sat Dec 05 1998 - 18:04:05 CST