Home » Developer & Programmer » Forms » forms 6i fetch data (11g )
forms 6i fetch data [message #677306] Wed, 11 September 2019 02:58 Go to next message
glmjoy
Messages: 187
Registered: September 2011
Location: KR
Senior Member
I had attached form and table created table.
I had made control block in which chqno1 and chqno2 and bank_code which is non data block


create table Chq_Book (Chq_No number(12),Bank_Code char(5))

i want to generate number between chqno1 and chqno2 which is input in chq_book table

for example 1001 and 1010
i want to fetch data
1001
1002
1003
.....
1010

thanks in advance
  • Attachment: Cheq_Book.fmb
    (Size: 44.00KB, Downloaded 1901 times)
Re: forms 6i fetch data [message #677308 is a reply to message #677306] Wed, 11 September 2019 04:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Have a look at this topic: row generator

Re: forms 6i fetch data [message #677310 is a reply to message #677308] Wed, 11 September 2019 04:19 Go to previous messageGo to next message
glmjoy
Messages: 187
Registered: September 2011
Location: KR
Senior Member
Thanks
Re: forms 6i fetch data [message #677351 is a reply to message #677310] Fri, 13 September 2019 01:20 Go to previous messageGo to next message
Neveen2019
Messages: 13
Registered: February 2019
Junior Member
Hi
If i have gotten your requirements then i think These Three Oracle Sequence blogs will be beneficial for you from A to Z.

[Updated on: Fri, 13 September 2019 01:21]

Report message to a moderator

Re: forms 6i fetch data [message #677353 is a reply to message #677351] Fri, 13 September 2019 01:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

No, sequence is of no use to do it.
Row generator is.

Re: forms 6i fetch data [message #677397 is a reply to message #677353] Tue, 17 September 2019 02:07 Go to previous message
glmjoy
Messages: 187
Registered: September 2011
Location: KR
Senior Member
Thanks
Previous Topic: frm-40734 internal pl/sql error
Next Topic: navigable current Record
Goto Forum:
  


Current Time: Thu Mar 28 11:34:55 CDT 2024