Displaying Date & Time when the form is run

[deeptic]

Hi,

I have an added a text item to the form with datatype as 'Date' and initial value as $$datetime$$. Also I have given this code on 'When-New-Form-Instance' trigger

:books.displaydatetime :=sysdate;

The forms runs without errors and displays the current date and time. However when I click the 'Execute Query', instead of displaying records, a message is shown - 'Do you want to save the changes you made' and then the form would go into an 'FRM -40505' error.

To correct this , I went through this thread and changed the 'Database Item' Property to 'No'. Now, I am able to execute the query. But, another problem occurs. When I click on execute, the date and time disappears. The text field looks empty when ever I go to execute query mode.

Need help on this.

Thanks
Deepti

 

[sem]

Are you sure it disappears in execute query, not ENTER query mode? In enter query mode the whole block is cleared. I may suggest you to place that field into separate block. If I understand your task it's for displaying only, not for storing into database, right?

Regards, Dima

http://seminihin.narod.ru