OraFAQ Forum: Forms » NO. of records

Home » Developer & Programmer » Forms » NO. of records (form developer 6i second release)

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

NO. of records [message #280890]

Thu, 15 November 2007 01:58

ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq

Member

Dear all

i have a form that display the search of the employee according to a parameter
so I dont know the numbers of records that will display in my form
so how can I make a form that displays the records without entering the "number of display records" in its characteristic

best regards

Report message to a moderator

Re: NO. of records [message #280892 is a reply to message #280890]

Thu, 15 November 2007 02:23

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm not sure I understood what was the question ... but, if you'd like to know how many records will query retrieve without actually performing EXECUTE QUERY function and scrolling down the block, you might do the following:
- enter the ENTER QUERY mode
- select "Query" from the menu and choose "Count query hits"

If that's not what you are looking for, could you, please, explain it once again?

Report message to a moderator

Re: NO. of records [message #280909 is a reply to message #280890]

Thu, 15 November 2007 03:03

ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq

Member

thank you brother for your cooperation

i mean that my result form is build on a parameter
so when i enter 1 it displayes 10 records
when i enter 2 it displayes 25 records
so i want my form to display the specific records
cause if I enter the number of displayed records =25
when my form displays the result on parameter 1
then 15 records will appear empty
so i want to solve this problem

best regards

Report message to a moderator

Re: NO. of records [message #280971 is a reply to message #280909]

Thu, 15 November 2007 05:05

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Ah, I see ... so you'd like to dynamically change number of displayed records in a block, depending on number of fetched records. You are looking for something like

SET_BLOCK_PROPERTY('block_name', number_of_records, 15)

As far as I can tell, that is not possible.

Report message to a moderator

Re: NO. of records [message #280983 is a reply to message #280890]

Thu, 15 November 2007 05:38

ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq

Member

thanks alot brother

Report message to a moderator

Previous Topic:	Labeling columns dynamically (merged)
Next Topic:	Calendar Control in Forms 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 21:54:23 CST 2025