[U2] Unidata Limits

2012-07-10 Thread Kevin King
I was asked a question today that ... well, it stumped me. Is there a practical limit to an incrementing number on Unidata and if so, what is that limit? I seem to recall something way back on Reality that said that numbers could count to 1+e38 or something ridiculous like that, but is that

Re: [U2] Unidata Limits

2012-07-10 Thread David A. Green
Since it is stored as a string it can be any length. If it is used as a Key or ID of the record you're limited by to 126 characters or whatever your LIMIT command shows. And if you need to do math with it you might have to use string math. David A. Green (480) 813-1725 DAG Consulting

Re: [U2] Unidata Limits

2012-07-10 Thread Daniel McGrath
Hi Kevin, As with most software systems, yes there are some very real limitations you need to be aware of if you are working with large numbers. There is a native limit you will hit as UniData converts the number to a double and eventually will lose precision. If working with something like a