Increment & back page

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Moving from VB6 and now a newbie with VB in Visual studio and SQL 2005
please can you help with 2 questions?

First
--------------------
I have a database and a webpage with a table view linked to a formview to
select and display a selected record. This works fine.

I would like to be able to display the number of times a particular record
is viewed ie a database record hit counter.

Is there an easy way of incrementing a value with SQL code or do I need to
make routines to select - store value - increment - then update?

There must be a way to do this in one go.

Second
----------------------

I would like to add a button to a webpage to return the user to the page
they came from ( ie like back button in IE ) even if its not from one of my
pages. I gather there is a history collection but I have failed in trying to
access it.



Thanks

jaez



.

Relevant Pages

  • Re: Querying a DataSet/DataTable in .NET
    ... to writing an in-memory database engine. ... >>>I think it would be nice if we could have a SQL engine available on the ... >>> display only (I could put it in business objects so I can reuse the ...
    (microsoft.public.dotnet.general)
  • Re: Native exception 0xc0000005 when using SQLCE and .NET CF 2.0?!
    ... Try to check out this article by Joao Paulo Figueira entitled "SQL Compact ... doesn't matter whether the database is empty or not when the test is ... SqlCeEngine sqlEngine = new SqlCeEngine( ... // Display all error messages ...
    (microsoft.public.sqlserver.ce)
  • Re: Treating NULL database values in classes and Form fields.
    ... A Null in SQL means in fact unused. ... When I read numeric data from a database into a class object and then ... my application the associated Form fields should then display nothing ...
    (microsoft.public.vb.general.discussion)
  • Re: strsql output
    ... exp-s wrote: ... i am using sql to view records in the database which i can view without any problem in the display, the thing is that i need to have the records in a output file i am trying hard but there is no sql option to direct the output to a physical file or to a printer file, does anyone know how to redirect the output from the display to a file? ...
    (comp.sys.ibm.as400.misc)
  • Re: Search & replace, but increment with every replace
    ... and having the database generate these incremental numbers. ... but several of these do support having a unique incrementing number be ... SQL> Create Sequence ID_NUM start with 1 increment by 1 maxvalue ... before you run the SQL command script. ...
    (comp.unix.shell)