aosylvain wrote:

> Strange but, when I'm doing :
>
> Close ;
> Prepare ;
> ParamByName('ID').AsInt64 := id ;
> First ;
> a := FieldByName('ID').IsNull ;
>
> Then :
> if the Cursor is in AutoFetchAll=true then a = false
> if AutoFetchAll is set to false, a = true... with the same data...
>
> So it does not work with AutofetchAll = true.
> I dont understand...
> Should I set AutoFetchAll to true or false ?

Using a field name for a parameter name can cause problems, and I
suspect THAT is what is happening here. What happens if you rename
ParamByName('ID') as say ParamByName('SID') ?
(I'm still running older versions of IBO here and can't check this
myself ;) )

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
Treasurer - Firebird Foundation Inc.