Forms 9i Calendar issue

[MrDeveloper]

Hi,
I have a row of text-boxes in a form linked to columns in the database (with the property of the data block set to display multiple rows). One of the text-boxes uses a calendar pop-up (displayed by clicking on a button associated with that text-box) to add in a chosen date.

I can enter a row of data to all the text-boxes without a problem, but after saving the record and going back into the form to update the value in the date text-box, the calendar button seems to instigate an 'insert' rather than an 'update' behaviour? Manually typing in a new date into the text-box behaves like an update, which is fine, but the calendar seems to 'insert' a new date into the table.

In normal circumstances this is not a problem, but there is alot of code which detects when an insert takes place and processes the data as a result, so I need to somehow get the calendar to put a date value in as if it were being typed in manually to avoid this code trigger setting off.

Can this be done? Or is there a work-around? Any help/advice much appreciated.

Many thanks,
MrD

 

[lewisp]

What kind of appliction is the calendar pop-up? Another form or java? What does the code look like before and after the call to the pop-up, and how does the calendar date get returned to the form?

 

[MrDeveloper]

Phew!
I did some further investigation and realised that I could not avoid how the calendar operates, but I *could* change how the trigger deals with it. Modified the code to detect a change by the calendar and prevented the insert operation from functioning - thereby solving the original problem.

Thank you for the posted replies though, much appreciated.

Regards,
MrD