10-17-2007 5:08 AM
hi
i want to introduce a counter in the a table to give a unique recored number
but whne i give data type as numc it goes upto only 999999 count only it is the maximum limit what i can give for numc
but the table can have more data
so pls suggest?
regards
Nishant
10-17-2007 5:11 AM
Hi,
There is no as such limit on NUMC.
Define
Data var(15) type n.
or if you defining as table field then
NUMC and give the as many character as you want.
Regards,
Atish
Message was edited by:
Atish Sarda
10-17-2007 5:11 AM
Hi,
There is no as such limit on NUMC.
Define
Data var(15) type n.
or if you defining as table field then
NUMC and give the as many character as you want.
Regards,
Atish
Message was edited by:
Atish Sarda
10-17-2007 5:16 AM
hi atish
but when defining in table i am giving the length of the field it is not takig more than 999999 please suggest
regards
nishant
10-17-2007 5:24 AM
Hi,
I created a test table with only one field of type NUMC and length 8 and I am able to give value as 99999999.
Try at your end.
regards,
Atish
10-17-2007 6:41 AM
hi atish
got it acutually it was my mistake i was assuming length as the value of places
regards
nishant