>-----Original Message-----
>From: Mindaugas Kavaliauskas [mailto:[email protected]]
>Sent: Monday, February 01, 2010 3:28 PM
>To: Harbour Project Main Developer List.
>Subject: Re: [Harbour] New trouble with type from MS Sql
>
>Hi,
>
>
>Horodyski Marek (PZUZ) wrote:
>> Mindaugas, I have new error from SQL Serwer :
>> oErr:osCode_______ 65531
>
>65531 ~ -5
>It is SQL_BIGINT.
>
>
>> Where/how can I try improve it (in odbcdd.c) ? :
>> ...
>> case SQL_TINYINT:
>> case SQL_SMALLINT:
>> case SQL_INTEGER:
>> pFieldInfo.uiType = HB_FT_INTEGER;
>> break;
>
>Try to add the fourth case sentence:
> case SQL_BIGINT:
After this dbStruct is returned :
{
...
{"NJS", "C", 7, 0}, {"POK", "C", 4, 0},
{"ODDZIAL", "C", 4, 0},
{"DATA_ZAWARCIA", "@", 23, 3},
{"DATA_ZAKONCZENIA", "@", 23, 3},
{"ID_UBEZPIECZAJACY", "I", 19, 0}, // <== this field was 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.
Afther this I don't see any new file.
I can read selects from MS SQL RDBMS :)
Big thanks !
Regards,
Marek Horodyski
_______________________________________________
Harbour mailing list (attachment size limit: 40KB)
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour
