Subject | Re: [IBO] Missing Event after SQL has changed |
---|---|
Author | Andreas Hesse |
Post date | 2005-06-12T09:34:18Z |
Helen Borrie wrote:
Thanks,
Andreas
> At 12:27 AM 12/06/2005 +0200, you wrote:I select another solution for this.
>
>>I miss an Event after the SQL has changed.
>>
>>Problem:
>>IB_Query is prepared -> SQL changed -> IB_Query is unprepared.
>>I want to re-prepare the Query after the SQL has changed
>>(for FastReport Designer Native support).
>>
>>I can hook in TIB_Query.SQL.Changed Event, but this is problematic.
>>
>>Any suggestion?
>
>
> I don't see a problem. Changing the SQL property of a dataset invalidates
> the SQL property and, as you observe, causes the dataset to become unprepared.
>
> When you call an Open or Refresh method of TIB_Query, or the First method
> of a TIB_Cursor, IBO always tests whether it is prepared and prepares it
> automatically if it is not. If you are worried about it at all, it will do
> no harm to put this code into your BeforeOpen handler. It's not usually
> needed for datasets, though.
>
> Helen
>
>
Thanks,
Andreas