Hi Tony What's better than the searched result? GETPROPERTY TABLE 'tablename->FILTEREDRECORDCOUNT' ' varname' Returns exactly what Fritz search for ;) Adrian
> -----Ursprüngliche Nachricht----- > Von: [email protected] [mailto:[email protected]] Im Auftrag von Tony > IJntema > Gesendet: Dienstag, 11. November 2014 13:15 > An: RBASE-L Mailing List > Betreff: [RBASE-L] - RE: AW: [RBASE-L] - enhanced db grid with filter bar: > GETPROPERTYDBGrid1 'RECORD->COUNT' 'varname' > > 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= > > >
