How to use autonumber of Access?

[ajith]

Hello,

I was trying to use the nextnum: option of AccessControl. I want to know, if I have specified it correctly. The code is used was

#(Access

'StkTrades'

nextNum: #(field: 'sT_Key', table: 'tradenum', table_field: 'tradenum')

)

The field sT_Key is the field in the StkTrades table which needs to be filled with autonumber.I presumed the following: tradenum is the table which will store the autonumber in the field tradenum. This table and column are specified only the purpose of the autonumber and are not that of StkTrades. If I am right till now, this is bringing up an error – “query: select: nonexistent columns: (getnextnum_reserved_till)”; otherwise, guide me on the correct use. Even if I do create getnextnum_reserved_till column in tradenum table, it gives another error: GetNextNum failed, no records in: tradenum . What is wrong?

Thanks in advance,
ajith

[amckinlay]

I think you are using it correctly.

You can use GetNextNum.Create(table, field, num) to create the table with the required fields and output an initial record to it.

[ajith]

Hello,
That has corrected the problem,
Thanks,
ajith

[Author]

Posts