Jump to content

Data Table implementation issue

Athur B.

Recommended Posts

I'm trying to make a selection page for a project. The page allows you to select a reference in a Data Table with 500 entries. To save time I would like to enter only the first 2 or 3 characters of the reference in a text box. So the line of the Data Table jumps directly to the first corresponding entry. Basically what I want is a search tool like a "CTRL+F" tool for a Data Table.
I tried to use "Find DTI Column Value" Ladder function, but it needs the exact entry of the
Data Table. If someone have an idea how I can apply this function by ignore the end of the reference or something like that  it's solve my problem.

Thanks to read and have a Nice Day :D ,
Arthur B.

Link to comment
Share on other sites

Hello Arthur,

i think that you have to work in reverse mode; after digit the "small" string that you want find you have to push the "enter" button in the keyboard...at this button you can couplead an action that will set one BIT...this BIT will enabled a start an UDFB this function will check the lenght of the String that you have insert and load the Strings in the colum of your DT, one by one, and check the firstly positions (the same quantity of your String)...if the result is ok you will stop the search and return the line where the complete string is stored.

I hope that I explained clearly what I mean.

  • Upvote 1
Link to comment
Share on other sites

Hello Orso,

Thank for reply, yesterday I leave my Job Early soo I haven't see your message :(.

But Yesterday after write this topic I have found a solution 100% like you say haha. By usign string lenght and check all my entry in DT and it's Work !

However thank to comfort my idea as the right solution !!

Arthur B.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...