Re: SE limits of 26 one character labels
Posted in 1999
Topics: Server Administration, Security, Permissions & Auditing
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