-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|