Re: Querying a record
From: Ricardo Patrocínio <conceicao.sousa_at_atm.mailcom.pt>
Date: Tue, 05 Jan 1999 11:47:46 +0000
Message-ID: <3691FBE1.42C7AFA3_at_atm.mailcom.pt>
Date: Tue, 05 Jan 1999 11:47:46 +0000
Message-ID: <3691FBE1.42C7AFA3_at_atm.mailcom.pt>
You create date field in the record that you must always update with sysdate. That way you can know the last record changed.
mdesouza_at_YAHOO.COM wrote:
> Hi all
>
> A small problem to solve
>
> when a user needs to amend an existing record , he perform a query
> entering certain fields
>
> When the user executes the query what I need to be returned is the most recent
> revision of the record
>
> Is there a way I can do this ???
>
> How to I return the most recent revision of the record
>
> any help appreciated
>
> regards
>
> mike d
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Jan 05 1999 - 12:47:46 CET