TIBDynamicGrid - Query with where dows not display.

[rvk]

yes, I have seen this, that I must put the Param BEFORE opening.
And sure I did.
Probably it would not even compile the other way round.

No no. You misunderstand. You need to put this in the OnBeforeOpen EVENT.
That's something different from "before opening".
The BeforeOpen event is executed automatically before Open.
And the TIBDynamicGrid does Close and Open itself.

So create the OnBeforeOpen event by doub;e clicking the event and put the ParamByName there.

As the DBGrid just as replacement works, - so the trouble shall be somewhere in the DBDynamicGrid.

The point is that TDBDynamicGrid changes the SQL statement and need to do a Close and Open for that Query.
And doing that will loose the ParamByName.
So you need to do the ParamByName in the OnBeforeOpen event so it gets executed every time TDBDynamicGrid calls Open.

[Nicole]

ah!!!!!!!!!!
Thank you for the explanation.
This explains all.
Yes, I thought before opening the query, this event I never used.

As I have a working version with DBGrid in the meanwhile, I will leave it like this, but save this hint for next time.

[egsuh]

Try transaction and prepare explicitly.

Code: Pascal  [Select][+][-]

1.       IBQuery_Kupons.SQL.Text:='Select ID_KUPON, DATUM,BETRAG, FK_EINKOMMEN ' +
2.                                ' From TBKUPONS where FK_EINKOMMEN = :FK_EINKOMMEN';
3.  
4.       Transaction.Active := True;
5.       Prepare;      
6.  
7.       IBQuery_Kupons.ParamByName('FK_EINKOMMEN').AsInteger:=FK_EINKOMMEN;
8.       IBQuery_Kupons.Active:=true;

[rvk]

Try transaction and prepare explicitly.

That won't work because the TIBDynamicGrid changes the SQL internally (because of the sorting etc). At that moment the (implicit or explicit) prepare is undone and parameter is lost. So this has to be done in BeforeOpen (in case you work with a TIBDynamicGrid).