Re: how to get last modified date time of all records in a table

--- In vbhelp%40yahoogroups.com">vbhelpyahoogroups.com, "Shawn K. Hall" <vb...> wrote:
&gt;
> > i m making multiuser project, in that i want to know last
modified
> > date/time of all records in a particular table.
>
> The first step would be to add a timestamp field to the table.
Until you
> have that a field setup for that type of tracking, no lookup is
> possible.
>
> -Shawn
&gt;

first of all thanks for showing interest in my problem,

adding timestamp field to the table generates more trouble bcoz at
every transaction i need to check each records timestamp and it will
take same time as refresh. i need the just 1 only lastmodified
date/time which is the date/time when changes occured in any records
in that particular table. i dont want lastmodified date of each
records. i have one solution to this problem by adding 1 more table
that have only 1 field and 1 record that hold the lastmodified
date/time of customer table's records by saving date/time into that 1
field/1 record table whenever sm1 changes (Add/delete/modify) to that
customer's table, but this manual solution can cause problem smtimes
and if any inbuilt function is thr for my problem it will help alot.

thanx again

Messages in this topic (0) Reply (via web post) | Start a new topic

•  11
  New Members

Visit Your Group

Can't you just get the system date/time information from the file the db is stored in? That has in it the last modified date/time stamp...




To: vbhelp%40yahoogroups.comFrom">vbhelpyahoogroups.comFrom: iworldsatellite%40yahoo.comDate">iworldsatelliteyahoo.comDate: Thu, 27 Sep 2007 08:37:53 +0000Subject: [vbhelp] Re: how to get last modified date time of all records in a table

--- In vbhelp%40yahoogroups.com">vbhelpyahoogroups.com, "Shawn K. Hall" <vb...> wrote:>> > i m making multiuser project, in that i want to know last modified > > date/time of all records in a particular table. > > The first step would be to add a timestamp field to the table. Until you> have that a field setup for that type of tracking, no lookup is> possible.&gt; > -Shawn>first of all thanks for showing interest in my problem,adding timestamp field to the table generates more trouble bcoz at every transaction i need to check each records timestamp and it will take same time as refresh. i need the just 1 only lastmodified date/time which is the date/time when changes occured in any records in that particular table. i dont want lastmodified date of each records. i have one solution to this problem by adding 1 more table that have only 1 field and 1 record that hold the lastmodified date/time of custome r table's records by saving date/time into that 1 field/1 record table whenever sm1 changes (Add/delete/modify) to that customer's table, but this manual solution can cause problem smtimes and if any inbuilt function is thr for my problem it will help alot.thanx again

__________________________________________________________
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&;form=QBRE

[Non-text portions of this message have been removed]

Messages in this topic (0) Reply (via web post) | Start a new topic

.

iworldsatellite wrote:
&gt;
> --- In vbhelp%40yahoogroups.com">vbhelpyahoogroups.com <mailto:vbhelp%40yahoogroups.com>,
> "Shawn K. Hall" <vb...> wrote:
&gt; >
>; > > i m making multiuser project, in that i want to know last
>; modified
> > > date/time of all records in a particular table.
&gt; >
>; > The first step would be to add a timestamp field to the table.
&gt; Until you
> > have that a field setup for that type of tracking, no lookup is
> > possible.
> >
>; > -Shawn
&gt; >
>;
> first of all thanks for showing interest in my problem,
>
>; adding timestamp field to the table generates more trouble bcoz at
> every transaction i need to check each records timestamp and it will
>; take same time as refresh. i need the just 1 only lastmodified
> date/time which is the date/time when changes occured in any records
> in that particular table. i dont want lastmodified date of each
>; records. i have one solution to this problem by adding 1 more table
&gt; that have only 1 field and 1 record that hold the lastmodified
> date/time of customer table's records by saving date/time into that 1
> field/1 record table whenever sm1 changes (Add/delete/modify) to that
>; customer's table, but this manual solution can cause problem smtimes
> and if any inbuilt function is thr for my problem it will help alot.
&gt;
> thanx again
&gt;

I don't want to be rude, but am probably going to be. Why not dump
the array altogether and use disconnected recordsets?

Your updates will happen in a flash and you will have no reason to need
the update datatime..... the db engine will look after that for you.

Matt
>
>
&gt;

Messages in this topic (0) Reply (via web post) | Start a new topic

.