Home » Developer & Programmer » Forms » Oracle Forms Check Box 'FRM-40505' (Oracle Developer 6.0 on Windows XP)
Oracle Forms Check Box 'FRM-40505' [message #324052] |
Fri, 30 May 2008 07:56 |
RickyGilles
Messages: 6 Registered: May 2008 Location: Milan
|
Junior Member |
|
|
I've to apologize for my low english, so I hope to let understand.
I've a problem with a checkbox on a form. The value when it's checked is 'S' and when it's unchecked is 'N'. Default is checked.
The same checkbox is designed in another form, with same values and same pl/sql code, but in first form he code is directly written on checkbox pl/sql code popup. In second form the chechbox call a procedure where it's written the same code.
My question is: when i uncheck the query runs. If I try to check again, the query doesn't run and I have this problem: FRM-40505.
The code of checkbox is:
DECLARE
WHRCND VARCHAR2(32000);
BEGIN
IF :CHK_LIC='S' THEN
WHRCND:=GET_BLOCK_PROPERTY('ANG',DEFAULT_WHERE);
:PARAMETER.P_WHRINZ:=WHRCND;
WHRCND:=WHRCND||' AND ANG_DTA_FIN_CTR IS NULL';
GO_BLOCK('ANG');
SET_BLOCK_PROPERTY('ANG',DEFAULT_WHERE,WHRCND);
CLEAR_BLOCK(ASK_COMMIT);
EXECUTE_QUERY;
ELSE
GO_BLOCK('ANG');
SET_BLOCK_PROPERTY('ANG',DEFAULT_WHERE,:PARAMETER.P_WHRINZ);
CLEAR_BLOCK(ASK_COMMIT);
EXECUTE_QUERY;
END IF;
END;
please help me, cuz it's important for a business environment.
Thanks
|
|
|
|
Re: Oracle Forms Check Box 'FRM-40505' [message #324829 is a reply to message #324052] |
Wed, 04 June 2008 04:26 |
RickyGilles
Messages: 6 Registered: May 2008 Location: Milan
|
Junior Member |
|
|
In display errors box I have following message on "SQL Statement in error":
SELECT ROWID, ang_cdc_sct, ang_cdc_dpn, ang_cgn, ang_nme, ang_mtr_dpn,
ang_type, ang_cdc_sct_perqll, ang_cdc_cnt, ang_cdc_qlf, ang_cdc_lvl,
ang_cdc_inl, ang_cdc_sct_perinl, ang_cdc_ses, ang_via, ang_cap, ang_cit,
ang_cdc_prv, ang_cdc_nzn, ang_cdc_sde, ang_cdc_sct_persdi, ang_cdc_stb,
ang_cdc_sct_perstb, ang_cdc_rpt, ang_cdc_sct_perrpt, ang_cnt_cst,
ang_cdc_sct_perccs, ang_pos_crt, ang_cdc_sct_perpos, ang_cdc_mns,
ang_cdc_sct_permns, ang_cdc_ru1, ang_cdc_sct_traru1, ang_cdc_ru2,
ang_cdc_sct_traru2, ang_cdc_ru3, ang_cdc_sct_traru3, ang_cdc_ru4,
ang_cdc_sct_traru4, ang_cdc_ru5, ang_cdc_sct_traru5, ang_cdc_ru6,
ang_cdc_sct_traru6, ang_cdc_bdg, ang_crt, ang_prf_fsc, ang_cdc_sct_trafsp,
ang_cdc_sqn, ang_cdc_sct_persfs, ang_prf_ctr, ang_cdc_sct_perctm,
ang_prf_trm, ang_cdc_sct_pertrp, ang_orr_grn, ang_prc_prt, ang_orr_stt,
ang_pwd, ang_dta_spt, def_utn, ang_utn_rsp, ang_dat_inz_ctr,
ang_dta_fin_ctr, ang_cdc_sct_persce, ang_cdc_dpn_tradpn, ang_cdc_sct_tradpn,
ang_dpn_1, ang_mtv_vst, ang_nte, ang_tpo_est, ang_utn_crz, ang_utn_mdf,
ang_dta_crz, ang_dta_mdf
FROM ang
WHERE AND ang_dta_fin_ctr IS NULL
ORDER BY ang_cdc_sct, ang_cdc_dpn
and this message in "Error"
ORA-00936: missing expression
[EDITED by LF: got tired of scrolling miles left and right to view messages. Reformatted this query and added [code] tags]
[Updated on: Thu, 05 June 2008 04:39] by Moderator Report message to a moderator
|
|
|
|
|
|
Re: Oracle Forms Check Box 'FRM-40505' [message #325152 is a reply to message #324852] |
Thu, 05 June 2008 03:02 |
RickyGilles
Messages: 6 Registered: May 2008 Location: Milan
|
Junior Member |
|
|
Ok, but where I can't modify the SQL statement??? Because I have a similar problem in another form with an insert statement, that should be an update statement. Where i can find the statement code showed in display errors box?!?!
|
|
|
Re: Oracle Forms Check Box 'FRM-40505' [message #325178 is a reply to message #325152] |
Thu, 05 June 2008 04:32 |
|
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
If it is a result of EXECUTE QUERY operation, probably nowhere; it is implicitly created as a result of executing a query in a form.
Any other code can be viewed in Forms Builder by selecting "View menu - Show PL/SQL only". Other than that, there might be code in data block property palette (WHERE clause, FROM clause query if FROM statement is data source for this block), etc.
|
|
|
Goto Forum:
Current Time: Wed Dec 04 18:55:16 CST 2024
|