[Harbour] New trouble with type from MS Sql
Horodyski Marek (PZUZ)
M.Horodyski at pzuzycie.com.pl
Tue Feb 2 04:17:33 EST 2010
>-----Original Message-----
>From: Viktor Szakáts [mailto:harbour.01 at syenar.hu]
>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
More information about the Harbour
mailing list