Re: help on forms using views?

>From: uunet!mtek.com!bud (Bud Hovell) >Subject: help on forms using views? >Date: 2 Apr 93 08:14:58 GMT >X-Informix-List-Id: <news.2959> >I'm in the middle of a small crash project using Informix SQL to define >tables and forms for someone else to later convert into a 4GL product. >Everything has gone just ducky -- until now. >I can do all the customary actions (delete, insert, update, etc.) when the >screen is referencing the tables directly, but a mystery message appears >and everything hangs up when I attempt actions on the rows selected under >a view constructed one-for-one on those tables. I've checked everything I >know to check, and even retain a faint and unhappy memory of once long ago >seeing (and pondering over) this most expertly obfuscated message, >apparently intended for original use in a dungeons-and-dragons script: > "Someone else has deleted a row which is in your list." This sounds like version 4.00 or earlier where Perform did not work on views, and that was the wonderfully informative message you got. (The other context in which you can get this message is when you have selected a list of rows, but between the time when the data set is generated and the time you step to the Nth row, someone else deletes the Nth row. In that context, the message is meaningful.) Unless you are running on a truly obscure (read ancient) platform, there should be a version 4.10 of the product available which will allow you to work on some views. ANSI SQL restricts the set of modifiable views, but one-to-one mapping views are modifiable. Are you by any chance from a DB2 background? In the Informix world, we don't normally use a view for a simple one-to-one mapping operation. We would for a sub-set of the rows or columns, or for a join view (though join views are not modifiable) Yours, Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>