Correct, you will run into problems and even worse there may not be an
exception raised. It may just quietly use a truncated value.

Use the AsLargeInt property for this.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Tom Deprez" <tom.deprez@...>
To: <IBObjects@yahoogroups.com>
Sent: Sunday, February 09, 2003 8:34 AM
Subject: [IBO] working with Numeric(18,0) values in Delphi


> 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.