Please help with simple query

[meishern]

Hi.

Please help me.

Table 'Counter' has a date field and an integer field. I want to auto increase the integer field by 1 using the update statement. I DO NOT want to first run a select statement to find out the initial value of the integer field prior to incrementing it. how would i go about doing this?

Thanks a lot!

 

[johnwm]

Depending on which SQL you are using, but most SQLs have an AUTOINCREMENT field type

Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting

Steam Engine enthusiasts:

http://www.essexsteam.co.uk