Search found 132 matches

by mirza_rehan
Tue Sep 01, 2009 9:20 am
Forum: Oracle Forms & Reports
Topic: how can we use, " Create and replace trigger"
Replies: 1
Views: 8427

Dear Sarah,

This is Database Trigger, we did not use it on forms. If any confusion please reply.

Regards,
Rehan Mirza
by mirza_rehan
Tue Sep 01, 2009 9:17 am
Forum: Oracle Forms & Reports
Topic: 1Z0-141 certification question query
Replies: 2
Views: 8142

Answers are A, D & E
by mirza_rehan
Sun Apr 26, 2009 1:18 am
Forum: Oracle Forms & Reports
Topic: how to create CheckBox
Replies: 1
Views: 7714

You can not create Check box programatically, you can change its property like label, visiable etc...
by mirza_rehan
Sun Apr 26, 2009 1:07 am
Forum: Oracle Forms & Reports
Topic: Report in Excel
Replies: 1
Views: 7553

Plese tell me which procedure you are using for exporting your data in Excel so i can help you furthor.
by mirza_rehan
Fri Apr 11, 2008 2:22 pm
Forum: Oracle Databases
Topic: How to find days b/w two dates
Replies: 4
Views: 9232

SELECT date2 - date1 FROM dual;


FOR example

SELECT TO_DATE('15-JAN-2008') - To_DATE('01-JAN-2008') diff_bet_date
FROM dual;


hope it will help you

regard
Rehan Mirza
by mirza_rehan
Sat Apr 05, 2008 5:11 pm
Forum: Oracle Forms & Reports
Topic: How to get distinct values?
Replies: 3
Views: 8990

Asslaam-o-Alaikum,

Nadia sorry for late reply.


please send me yours table structure and also send me report format and required columns


regards
Rehan Mirza
+971-50-1792629
by mirza_rehan
Sat Apr 05, 2008 5:08 pm
Forum: Oracle Forms & Reports
Topic: Help Required in a Query
Replies: 3
Views: 9309

Assalam-o-Alaikum

Dear Najm,

Sorry for late reply,


SELECT C.SNO, T.TERM,
DECODE(C.GRADE, 'C', TO_NUMBER(NULL), C.MARKS) MARKS,
C.GRADE
FROM CLASS C, TERM T
WHERE T.TNO = C.TNO;


hope it will solve it


Regards
Rehan Mirza
by mirza_rehan
Thu Oct 18, 2007 3:52 pm
Forum: Oracle Forms & Reports
Topic: Problem with Query_only
Replies: 2
Views: 8645

Please send us proper detail so we do something

take care
by mirza_rehan
Mon Apr 23, 2007 6:28 am
Forum: Oracle Forms & Reports
Topic: Change window icon at runtime
Replies: 4
Views: 10411

Assalam-o-alaikum

you need to register D2KUtil.dll, after register it remove this error "frm-40734 interna error: pl/sql......."


hope it will solve yours proble

take care
by mirza_rehan
Wed Apr 18, 2007 5:21 am
Forum: Oracle Forms & Reports
Topic: Dynamicaly population of list
Replies: 2
Views: 7977

Change Item Type property to List Item of 'SALES_CLIENT_MASTER.CLIENT_NO'

hope it will solve yours problem
by mirza_rehan
Thu Mar 01, 2007 8:43 am
Forum: Oracle Forms & Reports
Topic: Using Ocx control
Replies: 3
Views: 8699

Follow this link for yours required form
topic.asp?TOPIC_ID=107

hope it will help you
by mirza_rehan
Sat Nov 18, 2006 10:31 am
Forum: Oracle Forms & Reports
Topic: Oracle Connectivity Between 2 countries
Replies: 5
Views: 9777

Assalam-o-Alaikum

You need Fixed IP first.

According to me you go for Replication. Do not connect directly to server which is located at other country for Reporting


take care
by mirza_rehan
Tue Oct 31, 2006 5:30 pm
Forum: Oracle Forms & Reports
Topic: Help regarding MSCAL.calender control in forms
Replies: 1
Views: 7304

See below link for yours required task hope it will solve yours problem

topic.asp?TOPIC_ID=107


take care
by mirza_rehan
Tue Sep 19, 2006 7:16 am
Forum: Oracle Forms & Reports
Topic: How to get HD serial and IP of a machine?
Replies: 20
Views: 45620

No Ahmed you are absolutely wrong i will give client machine and osuser name

take care
Allah Hafiz
by mirza_rehan
Mon Sep 18, 2006 4:28 am
Forum: Oracle Forms & Reports
Topic: Need Client Info Like IP Address /OS Username
Replies: 1
Views: 7386

You can use Sys_Context for this task


for OsUser

Sys_Context('UserEnv','OS_USer')

and for IP
Sys_Context('UserEnv','IP_ADDRESS')

hope it will solve yours problem


take care