[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