Forms :: How To Save Tlist Items In Database
Sep 25, 2010my question is this that i have tlist items like
example:
A
B
C
D
E
F
G
H
how to save tlist items in database.
ADVERTISEMENT
Forms :: How To Handle TList
Jul 7, 2010I handle newly the Tlist. I have Tlist Which is generated on runtime by the following code
Declare
cursor C1 is select 'A' col
from table
union
select 'B' col
[code]......
The list have 3 element now. But when i try get the element count in tlist using Get_list_element_count. i am not getting anything.
Forms :: How To Bind Hierarchy Tree Items To Text And Other Items
Jan 31, 2012I have already done a hierarchy tree. Now I'd like to make it bind to text items. When i click a node, it should automatically be bound to text items.
My tree is about sections of students, now when i click a specific section to view its corresponding subjects it would be displayed on text items.
For example:
+Sections
+First Semester
+LM2
+LM3
+Second Semester
+LM4
+LM5
When i would click on LM2 node, its subjects should appear immediately.
Forms :: Multiple Items With Same Database Column Name
Dec 28, 2010I am coming across a requirement wherein a databse cloumn is shred by 2 fields..( need to append the value to the data-base column for the 2nd field.
I dint test it yet but the form compiled with warning FRM-30431: Warning: Duplicate column name in same block...is it ok to further go or its not allowed at all?
Forms :: Save Images In Database From 6i
Mar 16, 2006 I have seen many times that people are confused for how to save and retrieve images in Oracle Database from forms. Here I have created a sample form. All the coding is there. And also required scripts are also written in this post. Please download the form create the scripts and run the form.
Here we go:
Database : 9i
Forms : 6i
Create Scripts:
CREATE TABLE DOCS_COMP_DOCUMENTS
(
DOC_ID VARCHAR2(10),
DOC_NAME VARCHAR2(100),
DOC_SCANNED_COPY LONG RAW,
FILE_NAME VARCHAR2(50),
FILE_EXTENSION VARCHAR2(3)
)
[code].......
Note: This Procedure is to find the file name and extension and store it as well in database. Create this procedure in database.
To retrieve images just press F7 & F8 in forms
Download the attached .fmb module and run it.
Forms :: How To Save File (PDF / Image) To Database From 6i
Oct 4, 2010I want to store file from form to database:
1. what is the good way (best solution) to store file means into Database or folder on sever.
2. In either case how can we do it means i need in detail on both sides (means on form side and also on database side).
3. Every file related to a record and may contain 1 or more then 1 files and maybe update files for one record many time and we must keep track of each update.
Forms :: Take Pic From Cam Window And Save It To Field In Database
Dec 21, 2012I have a requirement to take pic from a cam window and save it to forms field in database.
View 2 Replies View RelatedForms :: Unable To Save Record In Database
Jun 4, 2010I developed one form having 3 blocks(query_find,Summary and detail). If i do some changes in the 3rd block then press F4 key it's prompting "Do u want to save the Changes?[YES/NO/CANCEL].
If i press "YES" it displays message "1 Records applied and Saved. But the record is not saved in the database.
Forms :: Enable User To Select And Save Any Document Into Database?
Dec 6, 2012how can i enable user to select and save any document into oracle database and later on choose to retrieve and display it.it should be like windows file open save.
View 2 Replies View RelatedForms :: FRM-40404 Post Command In Save Procedure To Apply Some Record In Database Temporary
Sep 26, 2011I am working on form 10g, here i am using post command in save procedure to apply some record in database temporary.
But Frm-40404 Message raise during saving record i need post commond but i dont want to this message should popup, is there any method to avoid the message only?
Forms :: Filter Hard Coded Values In List Item (Tlist) Based On Value Entered In Text Item
May 22, 2010I have 2 items in my form:
1) Text Item
2) Tlist
Upon form load, TList will be populated with predefined item. The behavior i am trying to achieve is to have a text item so user could entered specific text which will then filter the values in TList .
Forms :: Image Path Save In Database And Image Name As Design Number?
Jun 3, 2009I create a simple table for image
CREATE TABLE image_table (
Design_no varchar2(10),
filename VARCHAR2(255) PRIMARY KEY,
image LONG RAW);
Then i create simple block of image_table
its show me in this website [URL] My question is i don't want to give my form path always.i want to save my picture path in my database and the name of my picture always same as my design_no column.
For example i want to save a picture in my database i will copy my picture in d:shahzaib1234.jpg now i want the path d:shahzaib save in database and when i copy my picture which path= d:shahzaib and file name = Design no its will automatically save in database.
SQL & PL/SQL :: Save Outlook Parameter In Database?
Jun 21, 2011Can we save the Microsoft outlook incoming and outgoing mails parameters(to,from,cc, subject,desc) in oracle database table online.
View 5 Replies View RelatedForms :: How To Go Through All Items In The Form
Jul 6, 2010is there any way or loop to go through all items in a form and check them with a condition ???
View 5 Replies View RelatedSQL & PL/SQL :: Collections - Save Associative Array In Database?
Jan 10, 2011We can save Associative array in data base, if not why?.
View 3 Replies View RelatedForms :: How To Add Text Items At Runtime
Dec 24, 2012I want add a text item at run time depending on the number of values retrieved i want to change the number of text items. Is it possible at run time to add a text item?
View 1 Replies View RelatedForms :: Items On Tab Page Getting Invisible?
Oct 12, 2010when i am selecting a record from a LOV which is associated with a button on a tab page of a tabbed canvas; all the items on the tab page getting invisible. But when i navigate to another tab page and then come back to the former tab page all items reappearing.
What could possibly be the reason for this and how to restrict items from disappearing?
Forms :: Populating List Items
Jun 7, 2010there are 3 radio buttons and 1 list item
i want different options to appear in the list item when choosing different radio buttons.
i've tried to compile the codes and there are no errors.
I dunno what went wrong.
B_DEV IS THE BLOCKNAME
LIST_ITEM IS THE NAME OF THE LIST ITEM
SEVEN_ELEVEN, MANNINGS, GNC ARE THE RADIO BUTTONS NAMES
FOR_BANNERS IS THE RADIO GROUP NAME
the following is my
DECLARE
[Code]....
Forms :: 6i / Validating Text Items?
Nov 24, 2010I am working on form 6i.
i need to write validation on text fields like first name,last name,phone no,email id
i have to not allow special char.
Forms :: Dynamic List Items
Apr 21, 2011I want to create two list items. one is for deptno and another is for empno in a single form.
Based on the selected deptno value from first list item i want to populate corresponding empno from second list item. I tried with the fallowing code, it's work fine but the second list is not clears with the existing empno's.
Code for Deptno List item
declare
cursor c is select deptno from dept;
cnt number := 1;
begin
clear_list('LI_DEPTNO');
[Code]...
Code for Empno list item in when_list_changed trigger for deptno list item
declare
cursor c is select empno from emp where deptno = :LI_DEPTNO;
cnt number := 1;
begin
it_id := Find_Item('LI_EMPNO');
clear_list(it_id);
for i in c loop
add_list_element('LI_EMPNO',cnt,i.empno,i.empno);
cnt := cnt + 1;
end loop;
end;
Forms :: Numeric Listbox Items?
Apr 12, 2010I've got a colleague that is trying to populate a list box item with a group of numeric values that represent highway route numbers.
The database view defines the route as a "number".
How can we create a numeric list box? The built-in functions populate_group, and populate_list both expect to get varchar2 parameters.
Forms :: Queries On Long / Lob Items?
Feb 2, 2013how can I have queries on long/lob items in form.
View 1 Replies View RelatedForms :: Two Control Items With Dependent LOV?
Jun 28, 2011I have created two control items like organization and location and both items contains lovs.here i have to make location lov is dependent on organization.one org contains multiple locations. how to make this change?
View 1 Replies View RelatedForms :: Triggers In 6i / Which Is Applicable To All Items
Jan 24, 2012May i know the triggers in forms 6i, which is applicable to all items,blocks and form.
View 9 Replies View RelatedForms :: Moving Data Between Two List Items
Dec 8, 2010My form has two list boxes and two buttons add and remove. As and when i click add button, the selected value from left hand side list item should get populated to right hand side list item. And When I click Remove button, it should do vice versa.
View 10 Replies View RelatedForms :: Hangs With Large Text Items
Oct 4, 2010I'm facing a strange problem with one of my client.
Sometimes the application hangs when they are typing in text item defined with 2000 or 4000 char long.
The application needs to be close manually.
The first time we faced the problem, we tought it was due to database locks but the DBA confirmed that everything was OK.
The OAS admin also tried to log the application but nothing special. So we tried to run the application using JRE instead of JINITIATOR and the problem disappeared.
So, my question is, is there known bug about using large text item in Forms 10G? and especially with JInitiator? I tried to find informations on metalink but found nothing.
Forms :: Beans Items To Manage Movies
Apr 27, 2010My technical envirment is Winxp, dev9i AS vers9.0.2, Jinit vers1.3.1.9, OracleDB9i.
i want to create a form conatining a BEAN item through which i want to insert and select a BLOB movie from a Table in a database.
Forms :: Quit From Form With Items Having Primary Key?
Aug 21, 2010I have build a form based on a table with 2 columns,one of which isprimary key. I have created a Button with name "Quit".For that i used when-button-pressed trigger with built in "exit_form". But when I run the form,with out any execution of query or any action if I press "Quit" button,it is not working
The error message is "FRM-40202 : Field must be entered" Then I used a trigger to the item with primary key.when-new-item-instance:
set_item_instance_property('CUTOMER.CUSTID',CURRENT_RECORD,REQUIRED,PROPERTY_FALSE);
While using this,the error is "unable to resolve reference to item customer.custid" Cutomer is block name & custid is textitem with primary key. canvas used is Tab canvas with 3 tab pages with master detail relation b/w thwm. The primary key is required compulsory at the time on inserting.
Forms :: Disabling Default Menu Items In Oracle 10g?
Aug 3, 2010How to disable the Default Menu Items like (Edit - copy,Paste) in oracle Forms 10g.
View 1 Replies View RelatedForms :: How To Insert Column Values Into Text Items
Dec 30, 2011I have created the Textitem with five instances.
i am trying to assign column values to text item through query.
if my table contain one record,it shown in textitems.But if my table contains more records it is showing ora-1422 err.how to solve it.