topic increment in Application Development and Automation Discussions

increment

Former Member — Sun, 27 Apr 2008 09:49:02 GMT

Hi!

How must a field be declared for a transparent table when it has to be auto incremented and

is takes the incrementation place ?

Regards

Ertas

anversha_s — Sun, 27 Apr 2008 09:52:01 GMT

decalre it as INT

Former Member — Sun, 27 Apr 2008 10:00:14 GMT

INT1, INT2 or INT4 ?

Whats is about incrementing and getting the next number. Automatically ?

regards

ertas

anversha_s — Sun, 27 Apr 2008 10:04:37 GMT

Hi,

declare it as INT4.

Also when u update a record in data base, use the function module. - NUMBER_GET_NEXT.

This will create a next number. save it in data base.

Please keep in your mind that, database table cannot automatically increment the number. That you have to do programatically.

Regards,

Anversha

anversha_s — Sun, 27 Apr 2008 10:15:16 GMT

for number range refer the links