Re: Assigning Serialized Customer Numbers
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 15464
interpreted = N
texte = >How do I assign new customers a unique Customer Number that is>sequentially greater than the highest existing customer number?>Is there an example to look at anywhere?Maybe, but I'm not sure off-hand.Here, I'll write one for you. It should work fine if you make acouple of obvious changes (to the database and field name, ofcourse). And if you can understand how and why this works, that'seven better ... :)[append db=XXX.db]fieldName=[math]1+[searchdb=XXX.db&nefieldNamedatarq=[blank]&fieldtype=num&defieldsort=1&max=1][founditems][fieldName][/founditems][/search][/math][/append]Sincerely, Ken Gromeken@iav.comWebDNA Solutionshttp://www.smithmicro.com/webdnasolutions/...
Associated Messages, from the most recent to the oldest:
>How do I assign new customers a unique Customer Number that is>sequentially greater than the highest existing customer number?>Is there an example to look at anywhere?Maybe, but I'm not sure off-hand.Here, I'll write one for you. It should work fine if you make acouple of obvious changes (to the database and field name, ofcourse). And if you can understand how and why this works, that'seven better ... :)[append db=XXX.db]fieldName=
[math]1+[searchdb=XXX.db&nefieldNamedatarq=[blank]&fieldtype=num&defieldsort=1&max=1][founditems][fieldName][/founditems][/search][/math][/append]Sincerely, Ken Gromeken@iav.comWebDNA Solutionshttp://www.smithmicro.com/webdnasolutions/...
Kenneth Grome
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
database files in secure folder (1997)
ConverChars (1999)
Search in 2 or more catalogs (1997)
I'm new be kind (1997)
Zip Codes (2003)
Gettting IPAddress (2001)
Anybody see this before? (2006)
Web Catalog Instability (2000)
[WebDNA] Server 8 license question (2015)
More questions about serial number dishing (1997)
Upload and WebCat (1998)
Error Lob.db records error message not name (1997)
Frames and WebCat (1997)
PCS Frames (1997)
Nav. 4 probs with cart - Serious problem (1997)
Summing fields (1997)
format problem on NT? (1997)
Misc Stuff That Might Help (1997)
Claris HomePage messes up the code (1997)
Associative lookup style? + bit more (1997)