My Visual Database — Search using EditCounter

Re: Search using EditCounter

null@example.com (derek) — Fri, 10 Nov 2023 13:06:41 +0000

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.

Re: Search using EditCounter

null@example.com (tcoton) — Wed, 08 Nov 2023 15:30:18 +0000

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?

Re: Search using EditCounter

null@example.com (derek) — Tue, 07 Nov 2023 21:32:34 +0000

Hi,
Works okay for me (see the attachment).
Derek.

Re: Search using EditCounter

null@example.com (tcoton) — Tue, 07 Nov 2023 20:52:42 +0000

Hi Derek, I do not know why but your example does not find anything using the search.

Re: Search using EditCounter

null@example.com (derek) — Tue, 07 Nov 2023 12:27:46 +0000

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.

Re: Search using EditCounter

null@example.com (k245) — Tue, 07 Nov 2023 12:18:28 +0000

Sorry, it was my mistake - I forgot to set the TableName component property

Re: Search using EditCounter

null@example.com (derek) — Tue, 07 Nov 2023 11:53:53 +0000

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.

Re: Search using EditCounter

null@example.com (k245) — Tue, 07 Nov 2023 07:01:36 +0000

Result

Re: Search using EditCounter

null@example.com (k245) — Tue, 07 Nov 2023 06:59:27 +0000

Filter by button

Re: Search using EditCounter

null@example.com (k245) — Tue, 07 Nov 2023 06:52:49 +0000

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.

Re: Search using EditCounter

null@example.com (derek) — Mon, 06 Nov 2023 15:46:56 +0000

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.

Search using EditCounter

null@example.com (unforgettable) — Sun, 05 Nov 2023 18:28:00 +0000

Is there possible to show data on tablegrid for specific value or running valve in EditCounter? If yes then how?