Search found 132 matches

Go to advanced search

by mirza_rehan
Fri Jul 21, 2006 5:35 am
Forum: General / Others
Topic: how i control then Decimal
Replies: 2
Views: 2074

Use round function

Round(Column_Name,3);


take care

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family
by mirza_rehan
Wed Jul 19, 2006 2:12 am
Forum: Oracle Forms & Reports
Topic: Number of Character left in Text Item
Replies: 0
Views: 2385

Number of Character left in Text Item

Here is sample for number of text left in Text item

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family
by mirza_rehan
Wed Jul 19, 2006 2:00 am
Forum: Oracle Forms & Reports
Topic: Search in T-List
Replies: 0
Views: 1293

Search in T-List

Here is good sample for search in T-List with 3 different Techniques [img]/images/icon_zip.gif[/img] <b>Attachment:</b> search_tlist.zip <i>( 10881bytes )</i> Best regards, R E H A N M I R Z A System Analyst / Senior Oracle Developer Cell: +92-304-2120807 When ever you pray Please remember me and my...
by mirza_rehan
Tue Jul 18, 2006 10:17 am
Forum: Oracle Forms & Reports
Topic: which event use for checking befor delete
Replies: 2
Views: 1725

Write thers code in <b>PRE-DELETE</b> trigger at block lavel select count(*) into :CHQFOUND from voumaster where cheqno=:rchqno; if :CHQFOUND>0 then message('Can not be del this chq is use'); message('Can not be del this chq is use'); Raise Form_Trigger_Failure; else Message('delete your cheq'); mes...
by mirza_rehan
Thu Jul 13, 2006 3:57 pm
Forum: Oracle Forms & Reports
Topic: GL ERD
Replies: 5
Views: 2926

What sort of help you needed, You need system flow???? or any other info??? please tell.. You need it for professional working or only for study???

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family
by mirza_rehan
Thu Jul 13, 2006 3:56 pm
Forum: Oracle Forms & Reports
Topic: Invetory control ERD
Replies: 1
Views: 1519

What sort of help you needed, You need system flow???? or any other info??? please tell.. You need it for professional working or only for study???

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family
by mirza_rehan
Tue Jul 11, 2006 3:17 pm
Forum: General / Others
Topic: Screen capture utility
Replies: 3
Views: 2468

Really its very good software, thanks for give us such good software

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family
by mirza_rehan
Tue Jul 11, 2006 8:54 am
Forum: Oracle Forms & Reports
Topic: Data Import and Export from Text file
Replies: 1
Views: 1881

Data Import and Export from Text file

Here is example for import and export data in Comma seperated text file [img]/images/icon_zip.gif[/img] <b>Attachment:</b> data_imp_exp_Oracleforms6i.zip <i>( 12027bytes )</i> Best regards, R E H A N M I R Z A System Analyst / Senior Oracle Developer Cell: +92-304-2120807 When ever you pray Please r...
by mirza_rehan
Mon Jul 10, 2006 4:44 am
Forum: General / Others
Topic: need every first character are upper in query
Replies: 2
Views: 2208

Aamir there are 2 ways for this, if you are using PL/Sql function then user initcap function. For example your function name is <b>SpellNumber</b> <b>Initcap(SpellNumber(1251));</b> If you are using this way <b>select to_Char(To_Date(Sal,'j'),'Jsp') splSal from emp</b> Then you you set date formate ...
by mirza_rehan
Fri Jul 07, 2006 4:00 pm
Forum: Oracle Forms & Reports
Topic: how order by use in master detail form
Replies: 1
Views: 1250

Set Block property <b>'Order By'</b> write yours column name in this property

take care

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family
by mirza_rehan
Fri Jul 07, 2006 7:22 am
Forum: Oracle Forms & Reports
Topic: Navigate Canvas items
Replies: 8
Views: 3320

check this code , Bold letter are solved yours new requirement Declare v_NxtItm Varchar2(30) := Get_Block_Property('B1',First_Item); v_Val Varchar2(50); Begin Loop if Get_Item_Property(v_NxtItm,Item_Type) = 'DISPLAY ITEM' then <b>v_Val := Name_In(v_NxtItm); Message(v_Val);</b> Set_Item_Property(v_Nx...
by mirza_rehan
Fri Jul 07, 2006 5:13 am
Forum: Oracle Forms & Reports
Topic: how to handle the LOV
Replies: 5
Views: 2767

Where you want to type ??? in any field or on list of values????

please reply

take care
Allah Hafiz

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family
by mirza_rehan
Thu Jul 06, 2006 8:43 am
Forum: Oracle Forms & Reports
Topic: Navigate Canvas items
Replies: 8
Views: 3320

Here is sample code for yours required task, hope it will help you. I assue first item is button and this trigger code put on that buttion <b>Declare v_NxtItm Varchar2(30) := :System.Trigger_Item; Begin Loop v_NxtItm := Get_Item_Property(v_NxtItm,NextItem); if Get_Item_Property(v_NxtItm,Item_Type) =...
by mirza_rehan
Thu Jul 06, 2006 8:21 am
Forum: Oracle Forms & Reports
Topic: how to handle the LOV
Replies: 5
Views: 2767

Confused question please write yours question again correctly

take care

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family
by mirza_rehan
Wed Jul 05, 2006 2:11 am
Forum: Oracle Forms & Reports
Topic: try this but not work
Replies: 3
Views: 2762

Use same logic as this link

topic.asp?TOPIC_ID=181

take care
Allah Hafiz

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family

Go to advanced search