Insert new row in dddw

[Sjoker]

Hi,

In a column with a dropdowndw I select values from a ref table. How can I insert a new record in the ref table by inserting a new record in the dropdowndw column?

 

[mbalent]

You can create a SQL statement and then 'EXECUTE IMMEDIATE'
or you can use imbedded sql to insert the value as part of a normal dw save routine.

 

[PowerObject]

DDDWs are generally lookup/reference tables undermining them. Usually, there will be data-entry screens to update/insert/delete the lookup/reference data. If you have one, you may update the lookup screen directly.

If you are sharing the DDDWs data from another source, you may insert a row in the Primary dw/ds that would show up in the DDDW.

If you are interested in inserting a row just on the fly in the DDDW without having to update the dB, do a GetChild() and then insert a row in the child-dw. Whether this would save data referenced on the main dw depends on the table constraints. If the DataObject attached to the DDDW is updateable, you can update the underlying table using the child-dw.Update().

As a last resort, you may do a raw INSERT into the table and refresh the DDDW.

---
PowerObject!
-----------------------------------------

http://Groups.Yahoo.com/group/PowerObject

PowerBuilder / PFC Developers' Group