Subject Re: [IBO] Parameter looses value on reorder
Author Florian Hector
Hello Hellen,

thank you for your help.

I have changed the SQL statement to what you recommended, this is how it
looks like now:

Select BestID
, [ ... ]
, BestDatum
, [ ... ]
From TabBestell
Where BestDatum = :Datum

Datum has to be parameterised.

> Use the explicit join syntax and avoid JoinLinks.
> Don't try to parameterise your JOIN criteria, since (if it were possible)
> it would invalidate the query specification.
> Also ensure that your KeyLinks are capable of uniquely identifying each
> individual row in the joined set.

Yes, there is a generated value (BestID) used for that.

But the problem is still the same, whenever the grid is reordered, the value
of Datum is lost.

Any hints?

Florian