How to fetch or store a BIGINT using dbExpress and Delphi 2005

[Jon]

Since there is no native support for 64bit integers in dbExpress, it
is not trivial to fetch a BIGINT from SQL 2k.

If it is possible, how can a BIGINT be fetched using TParam or TField?

Any help appriciated

[Martijn Tonies]

Hello Jon,

Since there is no native support for 64bit integers in dbExpress, it
is not trivial to fetch a BIGINT from SQL 2k.

If it is possible, how can a BIGINT be fetched using TParam or TField?

If you create persistent fields, doesn't it get created as a
TFmtBCDField?
--
With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com

[Simon Hayes]

"Jon" <jo*********@hotmail.com> wrote in message
news:9f**************************@posting.google.c om...

Since there is no native support for 64bit integers in dbExpress, it
is not trivial to fetch a BIGINT from SQL 2k.

If it is possible, how can a BIGINT be fetched using TParam or TField?

Any help appriciated

I know nothing about Delphi, but perhaps you can CAST the bigint values to
varchars when you return them from MSSQL?

Simon