>-----Original Message-----
>From: Viktor Szakáts [mailto:[email protected]] 
>Sent: Monday, February 01, 2010 6:32 PM
>To: Harbour Project Main Developer List.
>Subject: Re: [Harbour] New trouble with type from MS Sql
>
>> 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)

I do not know how to properly do so should this amendment.
Meanwhile, I have an error when closing the query.

Regards,
Marek Horodyski
_______________________________________________
Harbour mailing list (attachment size limit: 40KB)
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour

Reply via email to