GETPROPERTY TABLE 'tablename->FILTEREDRECORDCOUNT' ' varname' Returns the number of records after using the individual filter.
GETPROPERTY TABLE 'tablename->RECORDCOUNT' 'varname' Returns the number of records without filter (as called the form) GETPROPERTY TABLE 'tablename->FILTEREDWHERE' 'varname' Returns the additional WHERE clause of the filter including keyword 'WHERE' Hints: If you like to represent the variable values within the same form. Take care - to declare the variables as TEXT within On Before Design Action to store with correct type in form design - to declare the variables as TEXT within On Before Start EEP to set/reset the values to zero before visualize the form - to use RECALC VARIABLES after GETPROPERTY to refresh the view of displayed variables Best Regards Adrian > -----Ursprüngliche Nachricht----- > Von: [email protected] [mailto:[email protected]] Im Auftrag von Dr. Fritz > Luettgens > Gesendet: Sonntag, 9. November 2014 11:05 > An: RBASE-L Mailing List > Betreff: [RBASE-L] - enhanced db grid with filter bar: GETPROPERTY DBGrid1 > 'RECORD->COUNT' 'varname' > > Situation: -enhanced db grid with filter bar > Location: i.e. db grid "on click eep" > Task: after using the filter bar I want to count the number of records of > the filter result > Question: > I find > GETPROPERTY DBGrid1 'COLUMNS->COUNT' 'varname' > but can not find > GETPROPERTY DBGrid1 'RECORD->COUNT' 'varname' > Is there a GETPROPERTY COMMAND like this that my clouded eyes don´t find > anymore ? > Thank´s > Fritz > > --- RBASE-L > =======================3D======================= > D= > TO POST A MESSAGE TO ALL MEMBERS: > Send a plain text email to [email protected] > > (Don't use any of these words as your Subject: > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) > =======================3D======================= > D= > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [email protected] > In the message SUBJECT, put just one word: INTRO > =======================3D======================= > D= > TO UNSUBSCRIBE: > Send a plain text email to [email protected] > In the message SUBJECT, put just one word: UNSUBSCRIBE > =======================3D======================= > D= > TO SEARCH ARCHIVES: > Send a plain text email to [email protected] > In the message SUBJECT, put just one word: SEARCH-n > (where n is the number of days). In the message body, > place any > text to search for. > =======================3D======================= > D= > --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
