At 11:08 PM 08-11-02 +0100, you wrote:

>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,
This is now becoming VERY CONFUSED. From your previous message, I assumed
you were using a joined dataset.

Now it seems you are not.

What exactly do you mean by "whenever the grid is reordered". What are you
doing in order to "reorder the grid"? (In IBO, you don't reorder the grid,
you reorder the dataset...)

Which components are we talking about here? which grid control?

Do you have any OrderingLinks set up? Any OrderingItems defined? Any
indexes in your table to support reordering?

It makes it a lot easier to troubleshoot your problem if you provide a
proper description of it. Include details of what reordering you are
trying to do and what you have done so far to implement it.

Helen