Re: how to previous verions of records?

From: Uri Dimant (urid_at_iscar.co.il)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 16:21:28 +0200

mekim
Perhaps you need to add a column with DEFAULT GETDATE()

"mekim" <mekim@discussions.microsoft.com> wrote in message
news:DEC8C81B-3EB0-49EA-931B-A6C0DABAB2A5@microsoft.com...
> Hi...does SQL do something like this automatcially?
>
> If I have a record...and I want to track the version of the record each
time
> there is a change to it can sql do that instead of having to do what I do
> below?...which is creating a new record on each save
>
> i.e.
> primaryid = 1001
> DetailRecordId = 300
> VerionNumber = 1
> Firstname = mekim1
>
> then when a change happens I create a new record
>
> primaryid = 1002
> DetailRecordId = 300
> VerionNumber = 2
> Firstname = mekim2
>
> and then when u try to get the record u have to
> do something like "Select * From Table Where Max(Version)"
>
> Regards,
> mekim
>

Relevant Pages

  • RE: how to previous verions of records?
    ... however...it seems like "replication" w/ a twist and one day hopefully it'll ... "mekim" wrote: ... > there is a change to it can sql do that instead of having to do what I do ...
    (microsoft.public.sqlserver.programming)
  • how to previous verions of records?
    ... Hi...does SQL do something like this automatcially? ... DetailRecordId = 300 ... VerionNumber = 1 ...
    (microsoft.public.sqlserver.programming)
  • Re: how to previous verions of records?
    ... but you could alway create a view that contains only the ... max version records and query off the view. ... > there is a change to it can sql do that instead of having to do what I do ...
    (microsoft.public.sqlserver.programming)
  • Re: how do u refresh query?
    ... mekim wrote: ... SQL EM? ... David Gugick ...
    (microsoft.public.sqlserver.programming)
  • Re: Access vs SQL Date Weirdness = Incompatibility?
    ... In fact, if PaidUntil is a date field, you probably don't require the CVDate ... To be honest, though, I don't understand what that SQL statement has to do ... So it seems that getdate() is the default SQL way of populating that field ... access query into a stored procedure? ...
    (microsoft.public.access.formscoding)