Output parameter of type Bigint in Stored Procedure

Boro · Post by **Boro** » Sat 06 Oct 2007 00:28

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.

Plash · Post by **Plash** » Mon 08 Oct 2007 08:30

You can use the Value property to get the parameter value as Int64.

Boro · Post by **Boro** » Mon 08 Oct 2007 09:14

The Value property is of type Variant. How to cast it to int64 type, pleae ?

Plash · Post by **Plash** » Mon 08 Oct 2007 10:18

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;

Boro · Post by **Boro** » Mon 08 Oct 2007 10:35

Thanks Plash. It helped.