Re: SQL Forms

In article <C7Jr4J.KIK@cbnewsm.cb.att.com> kz@cbnewsm.cb.att.com (khalid.zia) writes: } } I have shipping information (like, item_code, quantity_shipped, shipping_date) } in "item" table, and stock information (like, item_code, quantity_on_hand) in } "stock" table. } } My problem is to update stock.quantity_on_hand automatically, when } item.quantity_shipped is entered for a certain item_code. } INFORMIX-SQL FORMS do not allow updating fields across tables. } Is there a work-around for this problem? Any help will be appreciated. } Yeech... FourGen Forms. You are right, the code generator will not allow you to create code to do this. What you must do is find a trigger in the generated code and use that trigger to insert your 4GL code to do that update. By using a trigger, the next time you regenerate the code, your trigger will be added automagically. If you can't find an appropriate trigger, you'll have to use the "featurizer" and do pretty much the same thing. (Personally, I bagged the triggers and went with the featurizer exclusively) DAS -- David Snyder @ Snide Computer Services - Folcroft, PA Current Release is db4glgen-3.12 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com