Re: SE limits of 26 one character labels
Posted in 1999
No, it means you can only have 26 single character fields, if you have
more than that then tweak the form by hand so that some of the 1 char
field descriptors are 2 chars i.e. change [a] to [aa] in the form
--
Paul Watson #
WF Software # If it was easy
Tel ++44 1436 674729 # Everybody could do it
Fax ++44 1436 678693 #
www.wfsoftware.com/informix #
Kirill Sapelkin wrote:
>
> 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