Some Miscellaneous Questions on 4GL

Path: emory!att!cbnews!mvctm From: mvctm@cbnews.cb.att.com (carl.t.mosley) Newsgroups: comp.databases.informix Keywords: informix Message-ID: <1991Dec26.161921.9278@cbnews.cb.att.com> Date: 26 Dec 91 16:19:21 GMT Organization: AT&T Bell Laboratories I have some questions on writing 4GL apps....I am using 2.10 for DOS: I would really like to use a scroll cursor for handling query results but allowing the user to "fetch previous" gets confusing if they also have the ability to do a delete because the delete is done on the table in the database and not in the temporay place where the scroll cursor data is kept. The manual says to not use scroll cursors for this reason - has anyone worked around this? It seems that in the SQL product, when you "run" a form, you are using some kind of ready-made scroll cursor for "Next" and "Previous" on the menu and yet if you "Remove" the current row it is gone from the active set also. I think I have seen the following question before: using the input array statement, I prompt the user "Are you sure?" if they hit the delete key to delete the current row of the array. If they say yes, fine, but if not then is the only recourse to dump out of the input array altogether to avoid the delete? There seems to be no way to back out of a delete. I believe there is a new text datatype in the 4.00 products when using an ON-LINE engine. In my little DOS apps though, with the older products, I constantly have the need for at least a small text memo to go with a database record. Has anyone managed to achieve maybe some kind of simple word wrap on a form using a group of char fields? Just using a half-dozen char(80) fields without wrap is not convenient for the user to edit. Thanks Carl Mosley AT&T NS ctm@mvune.att.com