Home » Developer & Programmer » Forms » COUNT_QUERY
COUNT_QUERY [message #113558] Mon, 04 April 2005 10:55 Go to next message
dbarone
Messages: 20
Registered: March 2005
Junior Member
Hi I have a problem, I can't find a way to count exactly how many records have been fetched from a query. Is there a built-in or a function that counts the total records fetched..I have already tried with GET_BLOCK_PROPERTY(QUERY_HITS) but the problem is that if I have max 10 records displayed the query hits returns 10 and then when I go down with the scrollbar at the last record I get the total. The fact is that I want the total of the records immediately.
Re: COUNT_QUERY [message #114682 is a reply to message #113558] Mon, 04 April 2005 23:45 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Go to the block and perform a count_query before you do the execute_query.
Previous Topic: how'll we get the correct format of text in the report which is enterd into db through frm editor
Next Topic: Granting Privaleges on Menue Then Recreating It On Runtime
Goto Forum:
  


Current Time: Wed Sep 18 19:55:24 CDT 2024