dbpfind
Quote from s7shanbe on April 2, 2021, 10:53 amHi
In the Dbpro plugin
When using (dbpfind)
Is the number of items found stored in a variable?
Hi
In the Dbpro plugin
When using (dbpfind)
Is the number of items found stored in a variable?
Quote from Vadim on April 2, 2021, 12:01 pm@s7shanbe
Look at this special variable (you will have your own ID and your own table name)
[ID.Table.$RecCount]
Read more: https://neodbprohelp.visualneo.com/SpecialVariables.html
Look at this special variable (you will have your own ID and your own table name)
[ID.Table.$RecCount]
Read more: https://neodbprohelp.visualneo.com/SpecialVariables.html
Quote from Vadim on April 2, 2021, 12:39 pm@s7shanbe
When the search filter is applied, this variable stores the number of records found that match the search condition.
When the search filter is applied, this variable stores the number of records found that match the search condition.
Quote from s7shanbe on April 2, 2021, 1:30 pm@vadim
in "dbpquery" information is filtered and the number is displayed in $Reccount
but not in "dbpfind"
in "dbpquery" information is filtered and the number is displayed in $Reccount
but not in "dbpfind"
Quote from Vadim on April 2, 2021, 6:49 pm@s7shanbe
Yeah, I guess so.
You could try to filter before the search command and get the total number of records in the specified variable.
Yeah, I guess so.
You could try to filter before the search command and get the total number of records in the specified variable.
Quote from Gaev on April 3, 2021, 1:40 am@s7shanbe
In the Dbpro plugin
When using (dbpfind)
Is the number of items found stored in a variable?You might consider a subroutine that does this by ... following the dbpFind command with a series of dbpFindNext commands (inside a While/EndWhile block).
a) You will need to use dbpShowErrors "No"
b) [dbpError] will be null (i.e. "") until there are no more records to find
c) also, [yourDB.yourTable.$RecNum] will change with every new matching record; when no more matches, this value will not change
In the Dbpro plugin
When using (dbpfind)
Is the number of items found stored in a variable?
You might consider a subroutine that does this by ... following the dbpFind command with a series of dbpFindNext commands (inside a While/EndWhile block).
a) You will need to use dbpShowErrors "No"
b) [dbpError] will be null (i.e. "") until there are no more records to find
c) also, [yourDB.yourTable.$RecNum] will change with every new matching record; when no more matches, this value will not change