×
Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...
unique number generation
- VENKI6694
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 21
- Thank you received: 0
7 years 4 months ago #20642
by VENKI6694
unique number generation was created by VENKI6694
HI everyone I'm new to t24,
I've created a template with acc.id, customer name, and debit card number fields.
I want to generate 16 digit random unique id .
please help
Thank you
I've created a template with acc.id, customer name, and debit card number fields.
I want to generate 16 digit random unique id .
please help
Thank you
Please Log in or Create an account to join the conversation.
- VK
-
- Offline
- Platinum Member
-
- Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
Less
More
- Posts: 1116
- Thank you received: 150
- VENKI6694
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 21
- Thank you received: 0
7 years 4 months ago #20645
by VENKI6694
Replied by VENKI6694 on topic unique number generation
HI,
If I use RND() there are chances for repetation of ID.
I need unique ID's.. Any other way to generate such unique ID.
I also tried with UNIQUEKEY() . But the ID's generated were alpha, and I need the ID's to be in numeric.
Thank you
If I use RND() there are chances for repetation of ID.
I need unique ID's.. Any other way to generate such unique ID.
I also tried with UNIQUEKEY() . But the ID's generated were alpha, and I need the ID's to be in numeric.
Thank you
Please Log in or Create an account to join the conversation.
- VK
-
- Offline
- Platinum Member
-
- Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
Less
More
- Posts: 1116
- Thank you received: 150
7 years 4 months ago #20646
by VK
Cheers
VK
Replied by VK on topic unique number generation
Hi
use RND() not once but several times (like 4 times each time generating 4 digits).
After you get the result, try to read the record with this ID. If record exists (very small chance of that) - repeat all once again.
use RND() not once but several times (like 4 times each time generating 4 digits).
After you get the result, try to read the record with this ID. If record exists (very small chance of that) - repeat all once again.
Cheers
VK
Please Log in or Create an account to join the conversation.
- VENKI6694
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 21
- Thank you received: 0
7 years 4 months ago #20647
by VENKI6694
Replied by VENKI6694 on topic unique number generation
Thank you..I'll try and share the results
Please Log in or Create an account to join the conversation.
Time to create page: 0.103 seconds