Re: Lots of 1-char fields on form

In article <2bmjglINNld2@emory.mathcs.emory.edu>, Madi <gtmad@smi.mn.org> wrote: >} >} 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? >} >Use two character fields and in the specifications say >aa = field_name,picture = "X "; >Or if it is a 4GL program then use array type declaration to have >more 1 character fields I suspect that 48 1-character fields in a single form is a bit much. I've always been able to convince customers that this is infeasible with Informix and to either accept multiple forms or use a third party front end, like JYACC, which can handle such monsters with ease. ---------------------------------------------------------------------------- John Carter (H) 602-949-7319 OPTX Professional Sevices (W) 916-899-2110 Chico, CA (F) 916-899-2102 Reply to: wevans@cscihp.ecst.csuchico.edu (for John Carter) (Gee, wish I had my own email address) ----------------------------------------------------------------------------