Topic: Search using EditCounter
Is there possible to show data on tablegrid for specific value or running valve in EditCounter? If yes then how?
- unforgettable
- Member
- Offline
- derek
- Moderator
- Offline
Re: Search using EditCounter
If you attach your project, it helps to understand your problem.
But in principle, searching a tablegrid by editcounter is no different to any other search component (text, value, combobox, date, checkbox etc).
Derek.
3 2023-11-07 06:52:49 (edited by k245 2023-11-07 06:53:24)
- k245
- Member
- Offline
Re: Search using EditCounter
To search by the record_count field, you need to use the TdbEdit component. Using the TdbCounter component for these purposes will lead to an internal My Visual Database error, since this component is intended only for adding new values to the record_count field through the editing form.
Post's attachments
изображение_2023-11-07_095159771.png 5.28 kb, 14 downloads since 2023-11-07
Визуальное программирование: блог и телеграм-канал.
4 2023-11-07 06:59:27 (edited by k245 2023-11-07 06:59:44)
- k245
- Member
- Offline
Re: Search using EditCounter
Filter by button
Post's attachments
изображение_2023-11-07_095856230.png 30.22 kb, 14 downloads since 2023-11-07
Визуальное программирование: блог и телеграм-канал.
5 2023-11-07 07:01:36 (edited by k245 2023-11-07 07:01:53)
- k245
- Member
- Offline
Re: Search using EditCounter
Result
Post's attachments
изображение_2023-11-07_100020895.png 2.25 kb, 17 downloads since 2023-11-07
Визуальное программирование: блог и телеграм-канал.
- derek
- Moderator
- Offline
Re: Search using EditCounter
Hi Konstantin,
Very strange - I've never seen that error message before.
I've always been able to use an "editcounter" directly as a search filter (see attached).
Regards,
Derek.
Post's attachments
editcounter filter.zip 442.5 kb, 57 downloads since 2023-11-07
- k245
- Member
- Offline
Re: Search using EditCounter
Sorry, it was my mistake - I forgot to set the TableName component property 
Визуальное программирование: блог и телеграм-канал.
- derek
- Moderator
- Offline
Re: Search using EditCounter
I often do that too! 
With regard to using an 'editcounter' as a filter, although it is possible, I often find it better to copy it to an edit field anyway so you can use the 'fuzzy' search (%s%) and "incremental search" options (neither of which are possible if you use the "editcounter" directly as a filter).
Regards,
Derek.
- tcoton
- Member
- Offline
Re: Search using EditCounter
Hi Derek, I do not know why but your example does not find anything using the search.
- derek
- Moderator
- Offline
Re: Search using EditCounter
Hi,
Works okay for me (see the attachment).
Derek.
Post's attachments
CaptureWiz.mp4 82.67 kb, 62 downloads since 2023-11-07
- tcoton
- Member
- Offline
Re: Search using EditCounter
Never mind, that was my tired eyes, I was missing a 0 when typing. What is the benefit to use an edit counter for a search?
- derek
- Moderator
- Offline
Re: Search using EditCounter
Hi,
I guess it's the difference between 'search' and 'filter' (without getting weighed down in semantics 
).
When I use an editcounter (which doesn't allow 'fuzzy' searching), I'm not actually using it to search for a record that I can't find - I already know the number - I'm using it to filter out all the other rows in the tablegrid that I don't want and go directly to the record rather than always scrolling up and down; in a tablegrid with a large number of rows, it's probably the fastest way of doing it.
Typically, I use an editcounter to auto-generated invoice or order numbers.
Of course, you can always copy an editcounter into a calculated field which would allow 'fuzzy' searching if that's more applicable; as always, it depends on the actual requirement.
Derek.