daogu

what is the difference between Open,call & new Form in case of following point.?
Suppose your application crashed because of some malfunctioning (for example if your PC configuration is low or because any other condition) and if you have written commit_form in one of the form then that data is committed to the database or not, [...]

Hello members,
Kindly advise how to run my forms 6i application in web.
currently the architecture is client server.
please detail if any registry, configuration or service settings
have to be modified or created.
Thanks in advance
Thomas
Answer:Read Deploying Forms Applications to the Web document.
Answer:Thank your for that link.
Just answer me this – which web server does [...]

hi
how to insert data into table date time from forms 10g
(database item)
Answer:hello…
did you try this?
insert into tbl(date) values(to_date(sysdate,’DD/MM/YYYY’))
or to_date(sysdate,’dd/mm/YYYY hh24:mi’)
try it?
Answer:@kernel: TO_DATE(SYSDATE) doesn’t make any sense; SYSDATE already is a date.
@salwa: What do you, actually, want to do? Store both date AND time into a table column? If so, no problem! DATE datatype contains these [...]

Hi Gurus,
I have a problem in importing data in excel. I am getting data of my report from when-button-press trigger.But I am facing problem in filtering data (problem in passing parameters).
For below code i am getting data but without parameters.
declare
application ole2.obj_type;
workbooks ole2.obj_type;
workbook ole2.obj_type;
worksheets ole2.obj_type;
worksheet ole2.obj_type;
cell ole2.obj_type;
args ole2.list_type;
rowcount integer;
v_cust_code om_customer.cust_code%type;
cursor c1(v_cust_code om_customer.cust_code%type) is SELECT CUST_CODE [...]

hi everyone
i wont call my report name total sales
from my menu
Answer:if you working on form 6i put the following in the menu trigger
Answer:thank u islam175
but i use oracle 10g
pls help me
Answer:
begin

host(’RWRUN60 MODULE=C:\myrep.rep’||
‘ maximize=yes PARAMFORM=NO’||
‘ userid =’||’dbuser/dbpass@db’);
end;
etc.
Answer:which version [...]

i wana create a form that contain some ip addresses and check them all and show its status just i want if there is a command that read may be from ping command that return true or false or one or zero to know that i can connect to that ip address
thanks for any help,
best [...]

Hi guyz
Can you tell me how to synchronize two text item in one item
Example
1) First Name: Oracle
2) Second Name: Forms
3) Full Name:Oracle Forms
i want so synchronize 1 & 2 with item 3.
Regards
Answer:I’m not sure I understood what you are looking for, but – is it concatenation? Such as
Answer:ON WHICH TRIGGER WE WRITE THIS TRIGGER?
IT SHOULD [...]

CAN ANY ONE SEND ME A FMB FILE BY USING MSCOMM IN FORMS 6I
I NEED BADLY THIS FORM CAN ANY ONE HELP ME PLSSSS MY EMAIL:
owaisuzair2007@yahoo.com

OWAIS
Answer:Search this forum ’serial’. The question has been asked previously.
David

Hello,
Is it possible from Forms 6i to retrive the data from a Serial Port if Yes, how can it be done pls give the details to solve the following problem.
I am trying to retrive data from a Smart Card reader connected to Serial Port (COM1). When ever the Card Reader reads the data it transfers [...]

Hi,
I am facing a problem while using the "POST RECORD" Trigger at the block level.
Purpose: I am developing a custom form for PO Receiving. It is a multiple record block. One has to select some lines in the block and press the button called "RECEIVE".
If in this lines, if it is a LOT [...]

is there any array , we can use on forms 6i. im not talking about pl/sql table of records etc. if we cant.
tell the simplest way to use pl/sql array in forms
Answer:What is the problem you are trying to solve?
Consider using a dynamic ‘record_group’.
David

hi,
– how can determine what will be the size of the exported data before the exporting process is done ?,
– and is it possible to associate a synchronized progress bar to the exporting process?
thanks
Answer:Count me in for this post also.
If you are using EXPORT utility which is executed on command prompt then I think [...]

Hi Friends,
I want to add list item values based on another list item.
which means
I have the country names in one list item
when I pressed one value [...]

IS Oracle Forms/Reports 4.5 supported on database 9i?

My application is running on Form/Reprots 4.5 and 7.3.4 database in WIN2003 server. we have upgraded the database to 9i Release 2. After the upgrade terminate, i become unable to connect to my database from my application forms 4.5.
TNSNAME is OK.
Listener is OK.
Can i connect from Forms/Reports 4.5 [...]

Hi guyz,
I have the below table
Master Table
ID_NO VARCHAR2(15)
[...]

hello all
im working currently on dev.6i
why when i put this
select 1, level,ename , null, empno from emp
start with ename = ‘KING’
connect by prior empno=mgr
not work but when i put
select 1, level,ename , null, to_char(empno) from emp
done well
while in 10g not need to do that ??
how could i create a dynamic hierarchical [...]

Hi all,
I am facing an issue in a form which i have to modify to fix the bug. Can any one tell me which of the below takes the priority in displaying the values in a LIST ITEM.
1. Add_List_Element
2. List elements defined in the Property Pallete of the LIST ITEM.
I am populating the list with [...]

when i execute the form,last record displays default.
but i want to know execute the form all the fields are empty.
send solution plz.urgent
Answer:Remove default item values.
Answer:how to remove the default values?
Answer:Opet item’s Property Palette. Go to Initial Value property and erase what’s in there.
Answer:thank you sir

Hi,
When I set the option DESTYPE as MAIL, and DESFORMAT
as PDF.
By default it is creating "Report.pdf".
But I need to specify my own file name.
How?

Joneto
Answer:Try setting DESNAME parameter

Forget this, desname is not working for report name when sending output to mail. i am still searching for this
Answer:What version of report you are using?
Because in [...]

I created a form it contains 2 text items exam_code,Course_name
There is a table Question_paper holding some colums
Sno Questions Exam_code and Course_name
1 …. 7 sql
2 [...]

Hi,
I’m facing problem in installing Forms6i ,
I had installed Oracle 9i database , then Reports 6i
now am in need to install Forms6i.. but it gives me this error:
(SQL*Net is being used.Please stop Oracle applications
and services before continuing to install )
I’ve stopped all the oracle services but still getting the same error while installing [...]

Hi, i want export to excel from form.
Code is working for Office xp but not working with office 2003.
the error code is ora-106555…
I searched but found nothing to do.
Can you help me?

PROCEDURE EXCEL IS
erow number(12):=2;
AppID PLS_INTEGER;
path varchar2(200);
ConvID PLS_INTEGER;
BEGIN
erow := 2;
win_api_utility.Copy_File(’c:\urt_rapor_genel.xls’,’c:\Genel\urt_rapor_genel.xls’,true, FALSE);
path := win_api_environment.Read_Registry(’HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\WINDOWS\CURRENTVERSION\APP PATHS\EXCEL.EXE’,’PATH’,FALSE);
AppID [...]

Hi,
Assume that i have a form with 3 field. However, only one field is allowed to have input. Let pick an example:
Form TEST has 3 fieds: A | B | C
if A has data, and user attempts to enter data at field B or C, the error should be raise and force [...]

I am using oracle deveoper 2000 forms 6i.
i have got 2 question to ask…
1> How to make a field activated baed on the value of the other field?
e.g. I have 1 filed call ‘charge’(to be activated) and another field emergency which has 2 values viz ‘yes’ and ‘no’. If ‘yes’ is been selected the charge [...]

Hi,
When i try to commit the from im getting the error like below.
Thank in advance
wbr
kanish
Answer:Check the constraint. Rebuild it if necessary at FORM level and if problem still not solve then at database level.
Regards,
Azam Khan
Answer:hi
Actually it was working properly before i introduce a column.
on a table.
Answer:Did you recompile and regenerate [...]

Hi, I wonder how to access the list of blocks and the list of fields in a form written on Forms 6i that is stored in the database. I created the database tables but it seems that the old ones (FRM40_BLK and others) are not present.
Thanks in advance.
Answer:Look at the list of tables that exist [...]

My form includes Master and Detail Block.
Master block is just to find the Item_id, User can find Item by click ‘Find’ Button and choose one of them from LOV.
but when I try to insert new record(of detail) it’s always try to insert to master.
Please help me.
Answer:Don’t use master-detail in this situation. Use a [...]

Hi
i want to disable the login which appears every time i run a form.
i mean is it possible?
like when we run a form it asks for user name, password and connect
string…..
now what i want is that is there any way to stop that login appearing every time i run a form?
like is there [...]

Hello sir,
I have one table organized by index.
This table is used by the D2K form for insert, update, delete activities.
When i try to update table’s data from this form, it gives me the error
FRM-40657 with message "record changed or deleted by other user"
But there is no other application or user using this table or [...]

Hello ,
I have a table :
QL> create table rel ( parent varchar2(20), child varchar2(20) ) ;
Table created
SQL> insert into rel values ( ‘babar’,’humayun’);
1 row inserted
SQL> insert into rel values ( ‘humayun’,’akbar’);
1 row inserted
SQL> insert into rel values ( ‘akbar’,’Jehangir’);
1 row inserted
SQL> insert into rel values ( ‘akbar’,’Salem’);
1 row inserted
SQL> insert into rel values ( [...]

hi,
i m working on hospital management system..In that application i want to print bill after inserting data in that bill form..I just want to do is to create a button with both save and print trigger.. Can i???
Answer:Dear yes you can. On that button do 2 thinks one issue commit and [...]

hi,
can one put background image in form and which will set according to form??
Answer:you can import image through import option in developer.
Regards,
Azam Khan
Answer:hi azamkhan,
i m confused..can u tell me in detail about background image??
Answer:hi,,
sorry brother..got your answer..thanxs a [...]

hi,
i have made a table called "reg".. in that form there are two columns ..one is emergency and another is rate..
i just want that when i select emergency to yes then automatically rate feild should show "300".. and when i select no to emergency then rate should be [...]

Dear Friends,
In my form I want the user to select a operation system directory and after that all the file names in that directory comes into my form.
Is there any way of getting all OS filenames in a specific directory into my forms?
It can be done by using D2K utility but I dont want to [...]

How can I attach or include .olb library in application?
I did not find in Help/
Oracle Forms Builder 10.1. Windows
Answer:Search this forum for ‘attach olb’ or ‘attach object library’.
David

How to populate a tree in Oracle forms.plz send me the code.

Thanks in Advance
Answer:Look:
You can use the Populate_Tree Built-In, check the Forms Help.
Or use the search tool and search for "populate tree".
Regards!

Copy/ Paste Functionality dowesn’t work in Oracle Developer forms builder 10 for Linux, It doesn’t work in Report Builder 10g for Linux as well.
Answer:Thank you for sharing this information.
David

Hi All,
I created a push button and wanted to make it iconic.
I pasted the image in the following path:
Oracle_home\FORMS60\java\oracle\forms\icons
Here there are other images too.
If I use an image which is already in this folder, then it shows up.
However the new picture which I had saved in this folder is not showing up.
Why is this so [...]

I want to pass the http url from forms to server.The web.show_document displays the output on the screen.I dont want to see the output screen on client.Only i want to send the URL from forms to server.
How can i pass the URL FROM FORMS?
Any idea about using webutil for this?
Answer:And what is the server [...]

Hello Everyone,
When I using ‘when-tree-node-selected’ trigger in forms , it is worked only when clicked on tree node but not worked by pressing down arrow or up arrow.
I want when pressing down or up arrow ‘when-tree-node-selected’
trigger will fire.
How can I solve this problem. Could you plese help me.
Thanks
Aftab
Answer:Have you solved your problem?
David
Answer:No
Answer:Does the ‘down arrow’ [...]

I have a problem the scene is
I have two tables in one i have specified all the parameters against products and tests
in the other table i have all of these columns a value column also in which when i call i give values against each parmameter and then i m using a function to [...]

Hi,
I have encountered the following oracle forms 9i error: frm-10221: cannot read file menu, frm-41810: error creating menu. I have placed my menu the same with my form and recompile my menu but still I encountered the same problem. Any help is appreciated. Thanks and God bless!
Answer:I already solved the problem…..
Answer:I’m glad you [...]

Dear All,
I don’t know where I have to post this Question.
I have an application which is working well,
Now a days, it is getting closed suddenly without showing any warning.
As it gets closed, a log file is generated in the desk top.
I am attaching the log file.
Please advice me.
Thanks & Regards,
Sasi…
Answer:This sounds like one of those [...]

Hi
I have created form containing two data block having master detail relation ship
Both data block have one control item
For first control item(account number) i have attached LOV(this is derived from other data block which have custmer id common) which fetched account number & customer id and second control item(Engine model)which fetch engine model & engine [...]

DEAR ALL
I HOPE TO HELP ME HOW CAN I USE ORDER OF CREATE RECODGROUP AND POPULATE_LIST AND WHAT’S KIND OF ITEM’S AND TYPES SHOULD BE USED AN
IT’S URGENT
THANKS
Answer:i use code of create record group and populate_list but result is null and appear this message frm 41334
how can i avoid it
thanks
Answer:paste your code ,
Answer:by the [...]

Hi to all,
I have a tabular block, I want to know how to disable or enable the current text item in the block not all the instances of it.
the funciton: set_item_instance_property doesnt have any attribute to disable the item only can control update_allowed. but I don’t want that.
Regards
Answer:According to SET_ITEM_PROPERTY instructions, current item’s ENABLED [...]

Hi , Can i check the fmx file whether exists or not before call them through menu? if so please tell me how to do it?
Upd: Remove ‘code’ tags.
Answer:I don’t know; but you may trap the exception once it is raised. Use the ON-ERROR trigger and FRM-40108 error code.
Answer:When ever you issue call form or [...]

Hello
I am getting such errors which are related to srw built in package.
I am using oracle 10gDS
Help me….
Answer:Have you searched this forum?
David

Hello,
I have requirement, in which i want to lock a record if one user has queried it, so that another user cannot query it again.
How to do this?
Answer:Create a ‘user_parms’ table, in it have columns that match the key fields of your main table. When the user selects a record for update, place its [...]

hello friends,
I need a technical guidance to integrate forms and reports in oracle application server. I have designed some portal pages, and now i need to add the generated forms and reports into those pages. kindly help me.
bharath
Answer:Have you tried placing [...]

HI ALL
I DISPLAY THE DATA OF MY REPORTS IN PDF FORMAT FROM MY FORMS , MY CODE IS WORKING ALRIGHT. AND PDF FILE IS BEING LOADED THE WAY I WANT.
HERE IS THE CODE
.
THE ISSUE IS WITH THE COLORED CODE.
I HAVE TO GIVE THE PATH OF EXE FILE OF ADOBE READER [...]

hello
i display a picture to exexute query;
now i want this picture zoom in / zoom out
[MERGED by LF]
Answer:hello
i display a image at run time, and want this image zoom in / out
i use Oracle developer 10g . developer help file say "Show Palette property =YES"
but i an not finding this image property
help , urgent
Answer:i write [...]

Hi,
Iam having a problem with using a procedure i created in SQL Plus in Oracle Forms 9i. When i create a new program unit in Forms and transfer the code over it compiles fine, i have ammended the code so the parameters are the text item boxes within the form which also compiles. [...]