FORMS CRASH
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: FORMS CRASH

  1. #1
    Join Date
    Feb 2001
    Posts
    35

    Question

    I have Forms 6.0.5.0.2 on Windows Nt 4.0 SP 6

    When i create Record Group to use it List through LOV with such query Forms crashes:


    SELECT NVL (RPAD (acc_n_tare, 11, ' '), '-----------')
    || ' '
    || NVL (RPAD (nom_n_t, 11, ' '), '-----------')
    || ' '
    || NVL (RPAD (index_t, 15, ' '), '---------------')
    || ' '
    || NVL (RPAD (serial_n_t, 20, ' '), '-------------------')
    || ' '
    || NVL (RPAD (place, 12, ' '), '------------'),
    ct_tare_acc.tare_id
    FROM admnio5.ct_tare_acc
    WHERE admnio5.ct_tare_acc.acc_n_tare IS NOT NULL
    AND storage_t = 21
    ORDER BY ct_tare_acc.acc_n_tare,
    ct_tare_acc.nom_n_t,
    ct_tare_acc.index_t,
    ct_tare_acc.serial_n_t,
    ct_tare_acc.place


    But if i create such query it is ok:


    SELECT NVL (RPAD (acc_n_tare, 11, ' '), '-----------')
    || ' '
    || NVL (RPAD (nom_n_t, 11, ' '), '-----------'),
    ct_tare_acc.tare_id
    FROM admnio5.ct_tare_acc
    WHERE admnio5.ct_tare_acc.acc_n_tare IS NOT NULL
    AND storage_t = 21
    ORDER BY ct_tare_acc.acc_n_tare,
    ct_tare_acc.nom_n_t,
    ct_tare_acc.index_t,
    ct_tare_acc.serial_n_t,
    ct_tare_acc.place


    When i want to add 1 or more field to concatenate with others it crashes.

    I made this operation on different machines, on Windows NT SP 5, applied Patch 7 Forms 6.0.5.35.3 and everywhere is this situation.

    Help please.


  2. #2
    Join Date
    Nov 2000
    Posts
    38
    Hi,

    Try by giving alias. I don't have forms. I feel it may work. Let me also know the same.

    Regards,

    Shanker

Posting Permissions

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



Click Here to Expand Forum to Full Width