topic Re: numc limitation in Application Development and Automation Discussions

numc limitation

Former Member — Wed, 17 Oct 2007 04:08:04 GMT

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

Former Member — Wed, 17 Oct 2007 04:11:38 GMT

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

Former Member — Wed, 17 Oct 2007 04:16:41 GMT

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

Former Member — Wed, 17 Oct 2007 04:24:09 GMT

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

Former Member — Wed, 17 Oct 2007 05:41:58 GMT

hi atish

got it acutually it was my mistake i was assuming length as the value of places

regards

nishant