Increment a field value

--0-993484-1146577250=:33715
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi Everyone,

I want to increment the value of a field in a table by 1. How do I go about this?
I tried 'update.......................hits+=1' but it didnt work.

Your response would be appreciated.

Rgds,


---------------------------------
How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates.
--0-993484-1146577250=:33715--

Re: Increment a field value

Not really a good list for that. Try an SQL list but here is one answer

update table.x set field.x=field.x+1

No doubt there are hundreds of other ways to do this.


----- Original Message -----
From: "Akpome Akpoguma"
To:
Sent: Tuesday, May 02, 2006 9:40 AM
Subject: Increment a field value


> Hi Everyone,
>
> I want to increment the value of a field in a table by 1. How do I go
about this?
> I tried 'update.......................hits+=1' but it didnt work.
>
> Your response would be appreciated.
>
> Rgds,
>
>
> ---------------------------------
> How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call
rates.