RE: NewEra 3.0 Question

Hi all Candy Wrote> }>I have a design issue that I would like to get some feedback on and see how }>other users >have approached the }>problem. I have a table in our application with many columns that cannot all }>fit on one >window. In 4GL, we had the }>table represented in several screens with no problem: the user could browse }>through the >screens and when he/she }>was ready to change a record, could choose Change in a ring menu and the }>selected >record would be locked and the user }>make the changes, then save the changes (thus unlocking the record). I }>would like to >accomplish something }>similar In NewEra, using the supertable functionality. Thus, I have painted }>the table over >several windows, requiring }>a supertable per window, all referencing the same table in the database. }>I'm using >pessismistic locking, so the }>record is locked immediately when the user starts changing a field. This is }>fine, except the >same table is being }>referenced in all the windows, so when the table is locked in one window, }>when the user >makes changes in another }>window, the record is already locked, thus causing the obvious problems. It }>appears that I >need to update the changes }>on each window before the user can move to another window. Has anyone else }>>encountered this situation and how did }>you deal with it? }>Thanks for your ideas and help! In the Informix New Era users Manuals (sorry - I forget which one ) they describe a tabbed window approach for multiple tables in one window. This allows the user to highlight tabs to capture more information in a master detail scenario. I am sure with a little hacking here and there you could use this procedure for a single table maintenance screen. It would also save you the hassle of managing multiple windows, I will also have a look around for some sample code and mail it to you if you like. Good luck David } }david@west.co.za }Senior Software Consultant }The West Solutions Group }Friends help you move...REAL friends help you move bodies! }