Home » Developer & Programmer » Forms » multiple records
multiple records [message #131705] Tue, 09 August 2005 01:49 Go to next message
MEEENAR
Messages: 72
Registered: May 2005
Location: CHENNAI
Member
hai,


I have a form with 3 feilds

Date - text box - sysdate
DIC No -text box
Service Type - combo box -(Delivery, inter transfer)
From -combo box -(Branch, Client)

the end user will receive more than 20 to 30 DIC Slips from a branch, so he will enter into that form and he will enter the sercvice type as inter transfer and from as Branch and we will enter all the Dic No in the dic no box , he dic no's will be seperated by a slash .

the end user can do this work by entering each dic no one by one , but that will consume a a lot oif time , so he enters all the dic no seerated by a slash.

Problem:

Now it is not possible to track whether a particular dic no has been received or not...

Solution to the problem:

if we enter 10 dic nos in the dic box then there 10 records should be saved not a single record ..

Please give a idea to solve this problem








Re: multiple records [message #131713 is a reply to message #131705] Tue, 09 August 2005 02:09 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Start with a control block. Define your fields 'a_date', 'server_type', 'a_from', and 'dic_num_txt' and a 'save' button.

Put WVI trigger on the first three fields as normal, and for 'dic_num_txt' parse the field in the WVI to make sure there are only numbers and slashes ('/').

When they press 'save' write your When-Button-Pressed to issue an 'insert' statement from within a loop that is controlled by the 'dic_num_txt' contents.

David
Re: multiple records [message #131998 is a reply to message #131713] Wed, 10 August 2005 06:19 Go to previous messageGo to next message
MEEENAR
Messages: 72
Registered: May 2005
Location: CHENNAI
Member
How to split string into an array of its substrings using specified delimiter in a pl/sql block?
Re: multiple records [message #132105 is a reply to message #131998] Wed, 10 August 2005 18:50 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Research the PL*SQL 'LOOP' statement.

David
Previous Topic: export table data to a text file by clicking a button in developer6i
Next Topic: Can anyone help me to trap ORA-03113 end-of-file on communication channel error
Goto Forum:
  


Current Time: Thu Sep 19 20:29:58 CDT 2024