FORMS CRASH

[maxim]

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.

[bhavani]

Hi,

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

Regards,

Shanker