Subject | Re: [IBO] Parameter looses value on reorder |
---|---|
Author | Florian Hector |
Post date | 2002-11-08T22:08:40Z |
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.
But the problem is still the same, whenever the grid is reordered, the value
of Datum is lost.
Any hints?
Florian
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.Yes, there is a generated value (BestID) used for that.
> 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.
But the problem is still the same, whenever the grid is reordered, the value
of Datum is lost.
Any hints?
Florian