Skip to Content
0
Former Member
Dec 13, 2011 at 05:46 AM

problem in no genereation in char field

16 Views

i have used a char field length 10 in my ztable as gate pass no.

also created a module pool which generates gate pass no.

commands used.

select max(gatepass no) from ztable into var.

it select 9 as max however maximum gate pass no currently present in ztable is 10.

also when i sort my ztable in ascending:

it sorts like this:

1

10

2

3

4

5

6

7

8

9.

instead if i use numeric in case of char then gate pass no generates like this 0000000009. after condense statement.

suggest some solution.