Re: update query

Tech-Archive recommends: Speed Up your PC by fixing your registry


what i actually intend to do is

i have a hit counter on a page, i want this to be database based instead
of using a text file.

i have a single record in a single table.

i intend to use a single query to first update the record, that is
increment the record by 1 and then display the result

so when the query is run, it must first check the value contained in the
column, then increment it by 1, then update the record, and then finally
display the result, all in one single query

suggest


*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • SQL Question and Form Field Displays
    ... the Question table by referencing the primary key field. ... I can display all five Questions without a problem, ... create a single query that I can use to display in the form? ... This is my first time working with VB and forms. ...
    (microsoft.public.access.formscoding)
  • Re: SELECT * help needed.
    ... But I also want to display the 5 articles before and after that article. ... Is it possible to do the above in one single query? ... Should I even bother doing that? ... does it make the whole operation faster to do it that way? ...
    (comp.lang.php)