Page 1 of 1

Output parameter of type Bigint in Stored Procedure

Posted: Sat 06 Oct 2007 00:28
by Boro
Hi all,

please, how to retrieve an output parameter from a StoredProc when it is of type Bigint?
Is there something like a IBCStoredProc.ParamByName('BIGPAR').AsInt64 ?
Something that will not typecast it to 32bit integer.

Posted: Mon 08 Oct 2007 08:30
by Plash
You can use the Value property to get the parameter value as Int64.

Posted: Mon 08 Oct 2007 09:14
by Boro
The Value property is of type Variant. How to cast it to int64 type, pleae ?

Posted: Mon 08 Oct 2007 10:18
by Plash
Variants are converted automatically to any type. You can use code like the following:

Code: Select all

var
  v: variant;
  i: int64;
begin
  i := v;
end;

Posted: Mon 08 Oct 2007 10:35
by Boro
Thanks Plash. It helped.