Results 1 to 4 of 4

Thread: form utility

  1. #1
    Join Date
    May 2008
    Posts
    24

    Red face Unanswered: form utility

    HI,

    I'm getting a error when trying to open a table that exceeds 26 columns. Is it possible to cusotmize form utility to open a table with more than 26 columns?


    Thanks

  2. #2
    Join Date
    Sep 2004
    Posts
    51
    You did not state how the form was created, I am assuming that form generate was used. This will only allow 26 columns because it uses a letter of the alphabet for each column.

    Try using form edit, then add the the remaining columns manually using a2, a3, ..., etc.

    I would need the table schema to help you further.

  3. #3
    Join Date
    May 2008
    Posts
    24
    Quote Originally Posted by marymurny View Post
    You did not state how the form was created, I am assuming that form generate was used. This will only allow 26 columns because it uses a letter of the alphabet for each column.

    Try using form edit, then add the the remaining columns manually using a2, a3, ..., etc.

    I would need the table schema to help you further.
    Here is the table schema -

    create table plan
    (
    bgroup varchar(3) not null ,
    plancode varchar(4) not null ,
    reascode varchar(4),
    depcode varchar(4),
    mchgcode varchar(4),
    pchgcode varchar(4),
    acfncode varchar(4),
    swchcode varchar(4),
    mppl01x varchar(80),
    mppl02x varchar(1),
    mppl03x varchar(4),
    mppl04x varchar(4),
    mppl05x varchar(1),
    mppl06i smallint,
    mppl07x varchar(1),
    mppl08x varchar(2),
    mppl09x varchar(2),
    mppl10x varchar(1),
    mppl11r decimal(5,2),
    mppl12x varchar(1),
    mppl13x varchar(4),
    mppl14x varchar(1),
    mppl15x varchar(4),
    mppl16x varchar(4),
    mppl17i smallint,
    mppl18i smallint,
    mppl19r decimal(5,2),
    mppl20x varchar(1),
    mppl21i smallint,
    mppl22r decimal(5,2),
    mppl23r decimal(5,2),
    mppl24x varchar(4),
    mppl25x varchar(4),
    mppl26x varchar(1),
    mppl27x varchar(4),
    mppl28x varchar(4),
    mppl29x varchar(4),
    mppl30x varchar(4),
    mppl31i smallint,
    mppl32x varchar(4),
    mppl33x varchar(4),
    mppl34x varchar(1),
    mppl35x varchar(1),
    mppl36x varchar(1),
    mppl37x varchar(1),
    mppl38x varchar(4),
    mppl39i smallint,
    mppl40x varchar(4),
    mppl41i smallint,
    mppl42i smallint,
    mppl43i smallint,
    mppl44i smallint,
    mppl45x varchar(1),
    mppl46x varchar(1),
    mppl47x varchar(4),
    swchrest varchar(4),
    mppl48x varchar(1),
    mppl49x varchar(4),
    mppl50x varchar(4),
    mppl51x varchar(1),
    mppl52x varchar(1),
    mppl53x varchar(1),
    mppl54x varchar(1),
    mppl55x varchar(1),
    mppl56x varchar(1),
    mppl57x varchar(1),
    mppl58x varchar(1),
    mppl59x varchar(4),
    mppl60x varchar(1),
    mppl61i smallint,
    mppl62x varchar(1),
    mppl63x varchar(4),
    mppl64x varchar(1),
    mppl65x varchar(1),
    mppl66x varchar(4),
    mppl67i integer,
    mppl68x varchar(1),
    mppl69x varchar(1),
    mppl70x varchar(1),
    mppl71x varchar(4),
    mppl72x varchar(1),
    dater varchar(4),
    dater2 varchar(4),
    dater3 varchar(4),
    mppl73x varchar(1),
    mppl74x varchar(4),
    mppl75x varchar(4),
    mppl76x varchar(4),
    mppl77x varchar(4),
    mppl78x varchar(4),
    mltype varchar(4),
    mppl79r decimal(5,2),
    mppl80r decimal(5,2),
    mppl81x varchar(1),
    polage varchar(4),
    polben varchar(4),
    polcse varchar(4),
    capacode varchar(4),
    mppl82i smallint,
    mppl_age_basis varchar(8),
    mppl_apply_uw_load varchar(1),
    mppl_ben_basis varchar(8),
    mppl_dep_prop_perc varchar(4),
    mppl_disab_defn varchar(4),
    mppl_esc_basis varchar(4),
    mppl_hb_fac varchar(4),
    mppl_ipl_prob varchar(4),
    mppl_ipls_apply varchar(1),
    mppl_ipls_fac varchar(4),
    mppl_ipls_unit_def integer,
    mppl_level_cover varchar(4),
    mppl_loybon_factor varchar(4),
    mppl_maxben_rule varchar(8),
    mppl_pay_term smallint,
    mppl_rnd_dp smallint,
    mppl_rnd_rl varchar(2),
    mppl_sal_cap varchar(4));

  4. #4
    Join Date
    Sep 2004
    Posts
    51
    The problem is not that the table has more than 26 columns, the problem is that there are more than 26 1 character columns in the table using varchar(1). The only work around is to change them to 2 character fields varchar(2). Currently I cannot locate another workaround .

    If this is not helpful you may want to contact tech support.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •