5/18/2023 7:42 AM | |
Joined: 2/8/2009 Last visit: 11/21/2024 Posts: 11 Rating:
|
I have another question. On TP1200 Comfort I have to implement barcoding system. I have to have arround 10000 data records. All data records have same variables. If I use only one group then could have max 500 data records. Code from barcode looks like 3KKB46. I organized it in groups. For group name I use first four characters (e.g. 3KKB). Last two characters always are numbers and could be from 00 to 99. It works fine as long as customer need new group which is not in recipes base. Then I have to create new group with my software. It is not acceptable for customer. I created groups like Group 1, Group 2, Group 3 up to Group 300 (which is max allowed group numbers). Then I wrote script which search data records in each group (from 1 to max allowed 500 data records in one group). It means 300 Groups with 500 data records per group. E.g. barcode scaner was read 3KKB36. Then script searching if in Group 1 (group No is 1) exist 3KKB36. It search per data records numbers from 1 to 500 ( if data record No 1 is 3KKB36 then it stops with searching. If not goes to data record No 2 and so on. If data record is not found in Group 1 start searching in Group 2 and so on. When scaned code is found searching stops. This takes long time. Is exist some way how to handling recipes smarter and faster? Please advice me. Thank you. Stef_63 Below is my script: Sub VBsearchLegacy_1() ------------------------------------------------------------------------------------------ |
Last edited by: Stef_63 at: 05/18/2023 07:44:25Last edited by: Stef_63 at: 05/22/2023 06:23:59Last edited by: Jen_Moderator at: 05/22/2023 12:33:09New subject after splitting. |
|
Follow us on