Re: Numbering Scheme

2018-10-12 Thread Gene Wirchenko
At 07:48 2018-10-12, Alan Bourke wrote: Easy for the staff to count, or difficult for the opposition to count. Pick one. In situations like this, aren't there supposed to be three things with a choice of two? Especially on a Friday. Sincerely, Gene Wirchenko

Re: Numbering Scheme

2018-10-12 Thread Frank Cazabon
It doesn't have to be either or. I have put forward the various suggestions to the client and will let them decide how they want it done. Thanks to everyone for their contribution. Frank. Frank Cazabon On 12/10/2018 10:48 AM, Alan Bourke wrote: Easy for the staff to count, or difficult for

Re: Numbering Scheme

2018-10-12 Thread Alan Bourke
Easy for the staff to count, or difficult for the opposition to count. Pick one. -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

Re: Numbering Scheme

2018-10-12 Thread Frank Cazabon
d ENDFUNC -- rk -Original Message- From: ProfoxTech On Behalf Of Frank Cazabon Sent: Wednesday, October 10, 2018 3:25 PM To: profoxt...@leafe.com Subject: Numbering Scheme I have a client who issues tickets in numerical sequence (it's a pawnshop). The sequence helps them balance thi

Re: Numbering Scheme

2018-10-11 Thread Joe Yoder
> >> > ELSE > >> > m.lcRetval=m.pcRandomChar+m.lcRetval > >> > ENDIF > >> > ENDIF > >> > RETURN m.lcRetval > >> > ENDFUNC > >> > > >> > FUNCTION ReturnRandom > >> > LOCA

Re: Numbering Scheme

2018-10-11 Thread Frank Cazabon
Retval >> > ENDFUNC >> > >> > FUNCTION ReturnRandom >> > LOCAL m.lcRandomSeed AS Character, m.lIsGood AS Boolean >> > *!* get a bunch of values to work with which will hopefully give at >> least one alpha not in monkeyship >> > m.lcRandomSeed=SY

Re: Numbering Scheme

2018-10-11 Thread Stephen Russell
YS(2015)+SYS(2015)+SYS(2015) > > m.lIsGood=.f. > > FOR m.y=LEN(m.lcRandomSeed) TO 2 STEP -1 && don't need to check > first char in sys(2015) > > IF ISALPHA(SUBSTR(m.lcRandomSeed,y,1)) AND NOT > UPPER(SUBSTR(m.lcRandomSeed,y,1))$[MONKEYSHIP] > >

Re: Numbering Scheme

2018-10-11 Thread Jean MAURICE
so to improve this solution : print the time and then add the sequential number as milliseconds such as : 172543.124 : the ticket has been printed at 17h25m43s and is the 124th ... The Foxil Le 11/10/2018 à 17:12, Frank Cazabon a écrit : That may work! Frank. Frank Cazabon On 11/10/2018

Re: Numbering Scheme

2018-10-11 Thread Koen Piller
What I would do: at a 3digt random prefix and a 2 digit random suffix to your seq number of fixed lengte. So you will end up with something like 45600198 67000261 45800377 Aso If you print the list like this you will see at one glance the seq number but your competetiors are not Abel to see that

Re: Numbering Scheme

2018-10-11 Thread Frank Cazabon
LOL! Frank. Frank Cazabon On 11/10/2018 11:06 AM, Ted Roche wrote: On Thu, Oct 11, 2018 at 10:54 AM Frank Cazabon wrote: Thanks, Obscuring the number is not a problem, but I think they want to be able to read the number off the ticket at the end of the day in sequential order and I don't

Re: Numbering Scheme

2018-10-11 Thread Frank Cazabon
That may work! Frank. Frank Cazabon On 11/10/2018 10:59 AM, Vassilis Aggelakos wrote: Try to put the real number between two 1 single digit other numbers. For example 3452 --> 3=dummy 45 = real sequence 2--> dummy. No math needed, just this little trick! Hope this helps. On Thu, Oct 11,

Re: Numbering Scheme

2018-10-11 Thread Frank Cazabon
Thanks Frank. Frank Cazabon On 10/10/2018 06:45 PM, Charles Hart Enzer, M.D. wrote: How about table with two columns in an Array: - Column One is sequential by one - Column Two is generated by Random Number Generator with IF THEN - If Random Number Exists, reGenerate -

Re: Numbering Scheme

2018-10-11 Thread Vassilis Aggelakos
If you want it a bit more sophisticated, the last digit it could denote how many digits are dummy in the begining. E.g: 45672 --> 45=dummy --> 67 real number and 2 dummy indicator. On Thu, Oct 11, 2018 at 6:03 PM Ed Leafe wrote: > On Oct 11, 2018, at 9:59 AM, Vassilis Aggelakos > wrote: > > >

Re: Numbering Scheme

2018-10-11 Thread Frank Cazabon
They actually have barcodes on the ticket but never use the scanners to actually read them, they just read the number (printed below the bar code). Frank. Frank Cazabon On 10/10/2018 06:19 PM, Mike wrote: Print the sequential number using a barcode font. If a customer has a barcode scanner,

RE: Numbering Scheme

2018-10-11 Thread Richard Kaye
The people in the know memorize the rebus. But you mentioned nobody wants to think so... -- rk -Original Message- From: ProfoxTech On Behalf Of Frank Cazabon Sent: Thursday, October 11, 2018 10:54 AM To: profoxt...@leafe.com Subject: Re: Numbering Scheme Thanks, Obscuring the number

Re: Numbering Scheme

2018-10-11 Thread Frank Cazabon
ch-boun...@leafe.com] On Behalf Of Frank Cazabon Sent: Wednesday, October 10, 2018 2:25 PM To: profoxt...@leafe.com Subject: Numbering Scheme I have a client who issues tickets in numerical sequence (it's a pawnshop). The sequence helps them balance things back at the end of the day (read that as chec

Re: Numbering Scheme

2018-10-11 Thread Ted Roche
On Thu, Oct 11, 2018 at 10:54 AM Frank Cazabon wrote: > Thanks, Obscuring the number is not a problem, but I think they want to > be able to read the number off the ticket at the end of the day in > sequential order and I don't see how I can come up with a simple way to > do this. > Invisible

Re: Numbering Scheme

2018-10-11 Thread Frank Cazabon
I would guess they are more concerned about overestimating, but that's just a WAG. Frank. Frank Cazabon On 11/10/2018 10:55 AM, Alan Bourke wrote: Do you care more about competitors overestimating or underestimating the amount of business being done?

Re: Numbering Scheme

2018-10-11 Thread Ed Leafe
On Oct 11, 2018, at 9:59 AM, Vassilis Aggelakos wrote: > > Try to put the real number between two 1 single digit other numbers. For > example 3452 --> 3=dummy 45 = real sequence 2--> dummy. > > No math needed, just this little trick! This is the best solution so far! You could use multiple

Re: Numbering Scheme

2018-10-11 Thread Frank Cazabon
On 10/10/2018 03:41 PM, Eric Selje wrote: What difference does it make if the competition knows how much business you're doing? I really couldn't say. They seem to "spy" on their competitors this way and think their competitors also do it to them. I really don't understand their reasoning,

Re: Numbering Scheme

2018-10-11 Thread Frank Cazabon
Subject: Numbering Scheme I have a client who issues tickets in numerical sequence (it's a pawnshop). The sequence helps them balance things back at the end of the day (read that as check for stealing) when checking the various parcels received for the tickets issued (they keep a copy of the ticket

Re: Numbering Scheme

2018-10-11 Thread Vassilis Aggelakos
Try to put the real number between two 1 single digit other numbers. For example 3452 --> 3=dummy 45 = real sequence 2--> dummy. No math needed, just this little trick! Hope this helps. On Thu, Oct 11, 2018 at 5:55 PM Alan Bourke wrote: > Do you care more about competitors overestimating or

Re: Numbering Scheme

2018-10-11 Thread Alan Bourke
Do you care more about competitors overestimating or underestimating the amount of business being done? -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: Numbering Scheme

2018-10-11 Thread Frank Cazabon
, 2018 3:25 PM To: profoxt...@leafe.com Subject: Numbering Scheme I have a client who issues tickets in numerical sequence (it's a pawnshop). The sequence helps them balance things back at the end of the day (read that as check for stealing) when checking the various parcels received for the tickets

Re: Numbering Scheme

2018-10-11 Thread Frank Cazabon
That would still involve some thought on the users part (and they don't think at all). Frank. Frank Cazabon On 10/10/2018 03:46 PM, Vassilis Aggelakos wrote: Multiply the number by 3. Vassilis On 10 Oct 2018, at 22:42, Ted Roche wrote: Keep a table with the primary key (a

Re: Numbering Scheme

2018-10-11 Thread Frank Cazabon
They have a barcode on the ticket, but we also print the number. They (for whatever reason) found that using the barcode was too hard. A QR code won't make it any easier. :( Frank. Frank Cazabon On 10/10/2018 05:35 PM, Stephen Russell wrote: 01 =1 10=2 Why not print a QR Barcode and stick

Re: Numbering Scheme

2018-10-11 Thread Mike
True, but they would need several invoices to compare...which means they're "looking" for a sequence and not just "noticing". Mike Paul Hill wrote: On Wed, 10 Oct 2018 at 23:19, Mike wrote: Print the sequential number using a barcode font. If a customer has a barcode scanner, they can

Re: Numbering Scheme

2018-10-11 Thread Paul Hill
On Wed, 10 Oct 2018 at 23:19, Mike wrote: > > Print the sequential number using a barcode font. If a customer has a > barcode scanner, they can "see" the number, but they'd have to be > looking pretty hard. Or they could just use their phone. -- Paul

Re: Numbering Scheme

2018-10-10 Thread Charles Hart Enzer, M.D.
How about table with two columns in an Array: - Column One is sequential by one - Column Two is generated by Random Number Generator with IF THEN - If Random Number Exists, reGenerate - Assign numbers to items from Column Two Instead of an Array, create a Table to be used --

RE: Numbering Scheme

2018-10-10 Thread Paul H. Tarver
l H. Tarver Email: p...@tpcqpc.com -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank Cazabon Sent: Wednesday, October 10, 2018 2:25 PM To: profoxt...@leafe.com Subject: Numbering Scheme I have a client who issues tickets in numerical sequen

Re: Numbering Scheme

2018-10-10 Thread Mike
Print the sequential number using a barcode font. If a customer has a barcode scanner, they can "see" the number, but they'd have to be looking pretty hard. Meanwhile, an $80 barcode scanner (USB connection) on the office computer would let them read the sequential number. Mike Copeland

Re: Numbering Scheme

2018-10-10 Thread Stephen Russell
01 =1 10=2 Why not print a QR Barcode and stick the number in there instead? On Wed, Oct 10, 2018 at 4:24 PM Frank Cazabon wrote: > But how will the staff be able to read the binary numbers off the ticket > and know it's in sequence? > > On 10 October 2018 15:33:10 GMT-04:00, Stephen Russell

Re: Numbering Scheme

2018-10-10 Thread Frank Cazabon
So effectively display one number on the ticket but when it comes to checking, run a report displaying the sequential numbers and the random/nonsense number? On 10 October 2018 15:42:30 GMT-04:00, Ted Roche wrote: >Keep a table with the primary key (a non-data-bearing auto-incremented >integer)

Re: Numbering Scheme

2018-10-10 Thread Frank Cazabon
But how will the staff be able to read the binary numbers off the ticket and know it's in sequence? On 10 October 2018 15:33:10 GMT-04:00, Stephen Russell wrote: >Go binary! 10010110101 They are kicking ass today! > > >On Wed, Oct 10, 2018 at 2:26 PM Frank Cazabon >wrote: > >> I have a

RE: Numbering Scheme

2018-10-10 Thread Tracy Pearson
, and see the label to try to figure out the numbers. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank Cazabon Sent: Wednesday, October 10, 2018 3:25 PM To: profoxt...@leafe.com Subject: Numbering Scheme I have a client who issues tickets

Re: Numbering Scheme

2018-10-10 Thread Vassilis Aggelakos
Multiply the number by 3. Vassilis > On 10 Oct 2018, at 22:25, Frank Cazabon wrote: > > I have a client who issues tickets in numerical sequence (it's a pawnshop). > The sequence helps them balance things back at the end of the day (read that > as check for stealing) when checking the

RE: Numbering Scheme

2018-10-10 Thread Richard Kaye
ednesday, October 10, 2018 3:25 PM To: profoxt...@leafe.com Subject: Numbering Scheme I have a client who issues tickets in numerical sequence (it's a pawnshop). The sequence helps them balance things back at the end of the day (read that as check for stealing) when checking the various parcel

Re: Numbering Scheme

2018-10-10 Thread Vassilis Aggelakos
Multiply the number by 3. Vassilis > On 10 Oct 2018, at 22:42, Ted Roche wrote: > > Keep a table with the primary key (a non-data-bearing auto-incremented > integer) as the sequential number, to ensure things don't go missing out of > sequence. > > For each ticket, create a unique number

Re: Numbering Scheme

2018-10-10 Thread Ted Roche
Keep a table with the primary key (a non-data-bearing auto-incremented integer) as the sequential number, to ensure things don't go missing out of sequence. For each ticket, create a unique number that's not already in the table. Use the random functions to generate a mix of numbers and letters,

RE: Numbering Scheme

2018-10-10 Thread John Weller
ROFL. John Weller 01380 723235 07976 393631 Go binary! 10010110101 They are kicking ass today! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: Numbering Scheme

2018-10-10 Thread Eric Selje
Or Hex? What difference does it make if the competition knows how much business you're doing? E On Wed, Oct 10, 2018 at 2:33 PM Stephen Russell wrote: > Go binary! 10010110101 They are kicking ass today! > > > On Wed, Oct 10, 2018 at 2:26 PM Frank Cazabon > wrote: > > > I have a client who

Re: Numbering Scheme

2018-10-10 Thread Stephen Russell
Go binary! 10010110101 They are kicking ass today! On Wed, Oct 10, 2018 at 2:26 PM Frank Cazabon wrote: > I have a client who issues tickets in numerical sequence (it's a > pawnshop). The sequence helps them balance things back at the end of the > day (read that as check for stealing) when

Numbering Scheme

2018-10-10 Thread Frank Cazabon
I have a client who issues tickets in numerical sequence (it's a pawnshop). The sequence helps them balance things back at the end of the day (read that as check for stealing) when checking the various parcels received for the tickets issued (they keep a copy of the ticket issued to their