At 11:55 PM 12/09/2007, you wrote:

>I noticed that in procedure GetSeekCursor (unit IB_Components,
>function TIB_BDataset.SysLookupKeyForBufferFields) there is this
>piece of code:
>
>for ii := 0 to Params.PSQLDA.SQLn - 1 - tmpPrms - incAdj - SPrmCnt do
> PSeekDA.SQLVAR[ii + tmpPrms + KeyFields.PSQLDA.SQLn] :=
> Params.PSQLDA.SQLVAR[ii + tmpPrms];
>
>If I set OldParameterOrdering = 1, Params[0].FieldName = 'DATUM',
>Params[1].FieldName = 'TYP' and everything is ok.
>If I set OldParameterOrdering = 0, the order of these parameters is
>inverse (Params[0].FieldName = 'TYP', Params[1].FieldName = 'DATUM')
>and Refresh causes the error.

OK...
Important: tell us exactly what version of Firebird (server and
client) and what is the ODS level of the database where the problem
is happening.

About all that's left to ask is that you prepare a minimal project
that reproduces the behaviour you describe. Zip up only the source
code and a minimal database (or the script for same) where you can
reproduce the problem, and upload it to the Files area. I think
Jason is away from contact at present but I will watch out for it,
take a look, and pass your observations + any of mine on to him.

Thks
Helen