Use a trigger. Use Trunc(SYSDATE) to get the date.

duilio_fos wrote:

>>Maybe if you compare against the max_date entered...
>>
>>
>
>unfortunately this solution won't work, as a normal user must be able
>to insert tomorrow's data, then modify today's data.
>
>Thank you
>
>Duilio Foschi
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus