Re: incrementally increase value

>> I am creating a survey in VS .NET 2003 C# using an SQL database. As the
>> user
>> chooses a response I would like the database to add 1 to the value of the
>> field... 1,2,3.. etc. I'm pretty new to this I hope I explained this
>> well.
>> Any help would be appreciated.

You can do it through an SQL UPDATE statement

UPDATE yourtable SET field1=field1+1 [WHERE clause]

Stephen Howe


.

Relevant Pages

  • Re: ORA-06413 when connecting Ora 9.2 from Win XP x64
    ... Thanks for the response, however I think you may have missed my last ... I am able to connect to the same database using Windows XP ... Prev by Date: ...
    (comp.databases.oracle.misc)
  • Re: How to tune LIBRARY CACHE latch contention
    ... Thanks for your response, Jonathan. ... it looks like the database ... Prev by Date: ...
    (comp.databases.oracle.server)
  • Re: ratio approximation algorithm
    ... I also got the same response from another mailing list I posted to. ... minor correction though. ... in advance and saved inside of a database. ... Prev by Date: ...
    (comp.programming)
  • Re: Troubles with variables and objects
    ... It is great to get response on such a short ... must see about setting up a database of these answers ... Tim F ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Cluster will not fail over.
    ... Below is the response from Microsoft as promised. ... They think a cluster does all the ... Database operations isn't magic, we need to quit treating it ...
    (microsoft.public.sqlserver.clustering)