[Harbour] New trouble with type from MS Sql
Viktor Szakáts
harbour.01 at syenar.hu
Mon Feb 1 12:31:56 EST 2010
> Try to add the fourth case sentence:
> case SQL_BIGINT:
>
> But I do not know how big is this "bigint" value. Please, try uncomment debug line:
> HB_TRACE( HB_TR_ALWAYS, ("field: name=%s type=%d len=%d dec=%d null=%d", pFieldInfo.atomName, iDataType, uiSize, iDec, iNull ) );
> and report result for bigint filed type.
>
> Testing of "big" values (larger that +/- 2^32) is also required to make support for bigint complete. Perhaps we will need to adjust code:
>
> case HB_FT_INTEGER:
> {
> long int val = 0;
> if( SQL_SUCCEEDED( res = SQLGetData( hStmt, ui, SQL_C_LONG, &val, sizeof( val ), &iLen ) ) )
> {
> pItem = hb_itemPutNLLen( NULL, val, pField->uiLen );
> }
> break;
> }
>
> to support all range of bigint values.
It's 64-bit signed integer. (confirmed from multiple sources)
Brgds,
Viktor
More information about the Harbour
mailing list