Re: SE limits of 26 one character labels

Kirill, It means that when the form is built, it generates labels a,b,c, etc for all of the one-character fields. Since there are only 26 letters in the alphabet it doesn't know what to call the 27th one-character field after a-z are used (0-9 don't seem to be an option). Maybe you could generate the form yourself and make some of them 2-character fields. Sue znanie@best.com (Kirill Sapelkin ) on 16/12/99 11:52:16 Please respond to znanie@best.com (Kirill Sapelkin ) To: informix-list@iiug.org cc: (bcc: Sue Davidson/EXE) Subject: SE limits of 26 one character labels In trying to build a form using ISQL and the SE 7.20 to look at the table built as per schema below, I get an error message: exccded its limits of 26 one character lablels. Press Return. Does this mean that one can only look at tables with less that 26 fields? I was able to look at a table of 41 fields. Thanks for any help. Kirill { TABLE "dba".stocntrc row size = 484 number of columns = 74 index size = 0 } create table "dba".stocntrc ( prt_oe_ack char(1), prt_bl_ack char(1), prt_bl_rls_ack char(1), prt_bo_ack char(1), disc_frght char(1), disc_misc char(1), tax_frght char(1), tax_misc char(1), taxable char(1), st_tx_code char(6), co_tx_code char(6), ci_tx_code char(6), warehouse_code char(3), drop_ship_whse char(3), retention_days smallint, due_days smallint, cm_reason char(3), dm_reason char(3), ar_acct_no integer, cash_acct_no integer, visa_acct_no integer, sales_acct_no integer, disc_acct_no integer, frght_acct_no integer, misc_acct_no integer, inv_acct_no integer, cog_acct_no integer, scrap_acct_no integer, use_department char(1), oe_doc_no integer, oe_inv_doc_no integer, oe_post_no integer, sub_ord_no integer, so_no integer, tab1_name char(18), lock1_required char(1), tab2_name char(18), lock2_required char(1), tab3_name char(18), lock3_required char(1), tab4_name char(18), lock4_required char(1), tab5_name char(18), lock5_required char(1), tab6_name char(18), lock6_required char(1), tab7_name char(18), lock7_required char(1), tab8_name char(18), lock8_required char(1), tab9_name char(18), lock9_required char(1), tab10_name char(18), lock10_required char(1), tab11_name char(18), lock11_required char(1), tab12_name char(18), lock12_required char(1), tab13_name char(18), lock13_required char(1), tab14_name char(18), lock14_required char(1), tab15_name char(18), lock15_required char(1), tab16_name char(18), lock16_required char(1), tab17_name char(18), lock17_required char(1), tab18_name char(18), lock18_required char(1), tab19_name char(18), lock19_required char(1), tab20_name char(18), lock20_required char(1) ); revoke all on "dba".stocntrc from "public"; -- Kirill Sapelkin znanie@best.com