Re: [WebDNA] Query re: autonumber
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 105527
interpreted = N
texte = > I recently used it and it bombed out - i.e all the autonumbers generated by> the append were the same and were negative! I think this was because one of> the record IDs had been generated using [cart].There's a limit to the number of digits in a "number" in webdna, and the [cart] tag probably creates values that exceed this limitation. I think the rule is to not use values with more than 12 digits to the left of the decimal place in order to avoid this issue.> Also what happens if records are deleted, i.e. the IDs are not all fully> sequential - does autonumber work OK in this situation?Yes, it's fine. The way I understand it, autonumber finds the highest value in the field at the time of the append, then adds 1.
Associated Messages, from the most recent to the oldest:
> I recently used it and it bombed out - i.e all the autonumbers generated by> the append were the same and were negative! I think this was because one of> the record IDs had been generated using
[cart].There's a limit to the number of digits in a "number" in webdna, and the
[cart] tag probably creates values that exceed this limitation. I think the rule is to not use values with more than 12 digits to the left of the decimal place in order to avoid this issue.> Also what happens if records are deleted, i.e. the IDs are not all fully> sequential - does autonumber work OK in this situation?Yes, it's fine. The way I understand it, autonumber finds the highest value in the field at the time of the append, then adds 1.
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:
[WebDNA] Limits? (2009)
WCS Newbie question (1997)
TCPConnect / TCPSend to Solaris NN Enterprise (2002)
can webcat determine an image's pixel dimensions? (2000)
Search crashing server (1998)
Shell on MacOSX (2004)
Email notification to one of multiple vendors ? (1997)
Sendmail doesn't (was Queertrons?) (1997)
WC 2.0 frames feature (1997)
PSC recommends what date format yr 2000??? (1997)
Quitting WebMerchant ? (1997)
WebCat2 - storing unformatted date data? (1997)
RE: Problems with dbcatalog.exe (1997)
multi-paragraph fields (1997)
WCS Newbie question (1997)
NT Setup (1998)
Simple Database close connection (2001)
Sku numbers (1997)
multiple search commands (1997)
[FileInfo] (1998)