Re: Lots of 1-char fields on form

In article <2bcc8oINN8fh@emory.mathcs.emory.edu> johnl@informix.com (Jonathan Leffler) writes: > }From: Bryan Klopfenstein <bryan@carsinfo.com> > }Subject: Lots of 1-char fields on form > }Date: Thu, 4 Nov 93 17:59:47 EST > }X-Informix-List-Id: <list.3057> > > }I have a customer who is trying to create a form for a table which has > }48 1-character fields. This is using Perform, but I have this feeling > }that the same problem may exist in 4GL forms also. Since it doesn't > }seem to be case sensitive, letters "a" thru "z" only cover 26 fields. > }Even if digits work (we haven't tried it), this only covers 36 fields. > }We haven't tried launching into other characters such as punctuation, > }in hopes of a better solution (that won't require trial and error to > }avoid syntax problems). Does anyone know a way to specify this many > }fields of 1-character? > > The field labels must start with an alphabetic character. > > There is no way to have more than 26 single-character fields in a form. > > Yours succinctly, > Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> Bryan, Jonathan, I don't know how supportable this is, but this solution, albeit not ideal, works for me using INFORMIX-SQL Version 4.10.UC2. The idea is to use a 2 character field width in the perform screen. ISQL handles this reather nicely, by simply truncating the 2nd character. In the table t1 below, all columns are data type char(1). Here is a sample .per file: -------------------------------------------------------------------- database blake screen size 24 by 80 { col01 [aa] col02 [bb] col03 [cc] col04 [dd] col05 [ee] col06 [ff] col06 [gg] } end tables t1 attributes aa = t1.col01; bb = t1.col02; cc = t1.col03; dd = t1.col04; ee = t1.col05; ff = t1.col06; gg = t1.col07; end -------------------------------------------------------------------- Good luck, Blake -- ``'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`' ` Blake Hughes, Trainer (415) 737-3600 ' ` bhughes@informix.com 1000 Marina Boulevard, Suite 650 ' ` Informix Software Brisbane, CA 94005 ' ``'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'`'