Page 1 of 1

TLargeInt Field and LargeInt Parameters

Posted: 30.09.2005, 10:47
by cipto_kh
Hi I want to ask, this command in Delphi 7 with ZeosDBO 6.1.5 from Firebird 1.5.2

ZQuery1.ParamByName('id').AsInteger:=ZQuery2idFoo.AsLargeInt;

Is is true??
Because ZQuery2 has a "idFoo" field that has a LargeInt type (BigInt type from Firebird). The ZQuery1 also has a LargeInt type for "id" field, but if I pass it thorough parameter, I didn't find AsLargeInt from paramByNamer.
If the value from "idFoo" higher than the maximum integer value, Is It still valid to pass it like the above code??

TIA

Posted: 30.09.2005, 11:19
by fduenas
well if your id value doesn't pass the Integer type boundary i dont' se eany problems. at the end, paramaters has this poroperty as Variant, so they store any value. if you eant to make sure, you can use this:

[syntax="delphi"]ZQuery1.ParamByName('id').Value := ZQuery2idFoo.AsLargeInt;[/syntax]


Version 6.1.5 it's now a little offdated, 6.5.1 (soon 6.5.2) has been improved a lot, so i think you can give a chance to 6.5.1, it has a lot of corrections and improvements.

You can get it from the ZeosLib CVS releases in the downloads section