Re: how to use multiple tables on one screen(add'l info)
Path: emory!sol.ctr.columbia.edu!samsung!uunet!trac2000!das13!dave From: dave@das13.snide.com (Dave Snyder) Newsgroups: comp.databases.informix Keywords: tables Message-ID: <1551@das13.snide.com> Date: 6 Dec 91 03:19:59 GMT References: <jc.691956868@tau> <jc.691964328@tau> Organization: Snide Inc. - Folcroft, PA In article <jc.691964328@tau>, jc@mips.com (J.C. Webber III) writes: > jc@mips.com (J.C. Webber III) writes: > >I'm setting up a data entry screen that crosses multiple tables. > >Is there a way to force the table switch to happen automatically > >upon the filling of the last field of the previous table. I don't > >want to make the user hit 'esc', then 't', then hit 'a' to go back into > >the add mode. I've been through the manuals already, and I'm going > >back into them again to see if I missed something, but I thought maybe > >one of my fellow informix hackers might have solved this problem > >already. I hate re-inventing the wheel. > > I forgot to include some details about my environment: > Informix SQL version 2.10.03K > Risc/OS 4.5 > Attempting to accomplish this task useing Perform. That's your problem... Perform just can't the mustard. I suggest you write it in 4GL. If you're new to 4GL, try my code generator "db4glgen". Here's the info... You can reach "das13" through the archive-server or ANONUUCP (ANONFTP is available through "mathcs.emory.edu"), the info you need follows... ANONFTP: If you've never used anonymous ftp, here is a quick primer, in the form of a sample session, with comments in {}. Lines with a "<<<" at the end are where you type something. % ftp mathcs.emory.edu {IP Address = 128.140.2.1} <<< Connected to mathcs.emory.edu. 220 emory FTP server (SunOS 4.1) ready. Name (mathcs.emory.edu:dave): anonymous <<< 331 Guest login ok, send ident as password. Password: dave@snide.com {use your name and host here} <<< 230 Guest login ok, access restrictions apply. ftp> cd pub/informix/das13 <<< 250 CWD command successful. ftp> get ls-lR <<< 200 PORT command successful. 226 ASCII Transfer complete. . . {repeat this step for each file you want} . ftp> quit <<< 221 Goodbye. % ANONUUCP: Create one or more of the following entries in your Systems (or L.sys) file: das13 Any;1 FAST 9600 1-2154614007 "" \\r\\c in:-\\r-in: anonuucp das13 Any;1 ACU 2400 1-2154614007 "" \\r\\d\\r\\c in:-\\r-in: anonuucp das13 Any;1 ACU 1200 1-2154614007 "" \\r\\d\\r\\d\\r\\c in:-\\r-in: anonuucp This is a call to Philadelphia, PA USA If you've never used anonymous uucp, try this for your first command... uucp das13!~/ls-lR /usr/spool/uucppublic ARCHIVE-SERVER: To access the archive-server, send mail to: archive-server@das13.snide.com In the Subject: put the word "help" (w/o the quotes). Leave the rest of your mail blank since it'll be ignored anyway. You will receive mail back explaining in detail what the archive-server is and how to use it. Any problems or questions should be mailed to: dave@das13.snide.com DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.2 UUCP: ..!uunet!das13!dave INTERNET: Dave.Snyder@snide.com