Adrian, I knew a better solution is available (as always). But I could not find it.
Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Adrian Hüssy Sent: dinsdag 11 november 2014 13:10 To: RBASE-L Mailing List Subject: [RBASE-L] - AW: [RBASE-L] - enhanced db grid with filter bar: GETPROPERTYDBGrid1 'RECORD->COUNT' 'varname' 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= >
