OraFAQ Forum: Forms » forms 6i fetch data

Home » Developer & Programmer » Forms » forms 6i fetch data (11g )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

forms 6i fetch data [message #677306]

Wed, 11 September 2019 02:58

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 2542 times)

Report message to a moderator

Re: forms 6i fetch data [message #677308 is a reply to message #677306]

Wed, 11 September 2019 04:00

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Have a look at this topic: row generator

Report message to a moderator

Re: forms 6i fetch data [message #677310 is a reply to message #677308]

Wed, 11 September 2019 04:19

glmjoy
Messages: 187
Registered: September 2011
Location: KR

Senior Member

Thanks

Report message to a moderator

Re: forms 6i fetch data [message #677351 is a reply to message #677310]

Fri, 13 September 2019 01:20

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

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

Re: forms 6i fetch data [message #677397 is a reply to message #677353]

Tue, 17 September 2019 02:07

glmjoy
Messages: 187
Registered: September 2011
Location: KR

Senior Member

Thanks

Report message to a moderator

Previous Topic:	frm-40734 internal pl/sql error
Next Topic:	navigable current Record

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 22:30:42 CST 2025