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

#1 (**permalink**) 02-29-2008, 07:07 AM

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

#2 (**permalink**) 02-29-2008, 07:07 AM

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

#3 (**permalink**) 02-29-2008, 07:08 AM

"Jon" <jonsjostedt@hotmail.com> wrote in message
news:9f379edc.0504190104.433d96f4@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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode