Subject Re: working with Numeric(18,0) values in Delphi
Author Marco Menardi <mmenaz@lycosmail.com>
Ops, sorry, I use NATIVE (IB_xxx) components, so for me this works:
var
myid: Int64;
begin
myid := FieldByName('CUST_ID').AsInt64;
end;

anyway, why do you use ParamByName instead of FieldByName to retrieve
a column value?
regards
Marco Menardi

--- In IBObjects@yahoogroups.com, "zifnabbe <tom.deprez@v...>"
<tom.deprez@v...> wrote:
> Thanks, but I tried this already... but,
>
> I get the message that AsInt64 is an undeclared identifier
> I'm using D7!
>
> It looks like this isn't supported some how... :-(
>
> Anybody other ideas?
>
> Thanks,
> Tom.
>
> --- In IBObjects@yahoogroups.com, "Marco Menardi <mmenaz@l...>"
> <mmenaz@l...> wrote:
> > In delphi >= 6, you can use AsInt64
> > regards
> > Marco Menardi
> >
> > --- In IBObjects@yahoogroups.com, "Tom Deprez" <tom.deprez@v...>
> wrote:
> > > Hi,
> > >
> > > I've a stored procedure which returns a numeric(18,0) value. Which
> > > datatype can hold this?
> > > I assume the below code isn't correct when the created id becomes
> very
> > > large.
> > >
> > > SessionID := ParamByName('SESSIONID').AsWord;
> > >
> > > (I use a TIBOStoredProc)
> > >
> > > Thanks in advance,
> > > Tom.