>-----Original Message-----
>From: Horodyski Marek (PZUZ)
>Sent: Monday, February 01, 2010 1:48 PM
>To: Harbour Project Main Developer List.
>Subject: [Harbour] New trouble with type from MS Sql
>
>Mindaugas, I have new error from SQL Serwer :
>
>oErr:severity_____ 2
>oErr:osCode_______ 65531
>oErr:subsystem()__SDDODBC
>oErr:subCode______ 1902
>oErr:description__Invalid field type
>oErr:filename_____
>oErr:operation____
Here are datatypes from this table :
ID_PODMIOT, bigint
ID_UBEZPIECZAJACY, bigint
NIP, nvarchar(10)
REGON, nvarchar(14)
NAZWA, nvarchar(255)
ID_SYSTEM_ZRODLOWY, nvarchar(8)
NJS, nvarchar(7)
I think the problem is bigint.
which add to \harbour\contrib\rddsql\sddodbc\odbcdd.c :
...
case SQL_TINYINT:
case SQL_SMALLINT:
case SQL_INTEGER:
pFieldInfo.uiType = HB_FT_INTEGER;
break;
case SQL_DECIMAL:
pFieldInfo.uiType = HB_FT_LONG;
break;
case SQL_REAL:
case SQL_FLOAT:
case SQL_DOUBLE:
pFieldInfo.uiType = HB_FT_DOUBLE;
break;
...
????
Regards,
Marek Horodyski
_______________________________________________
Harbour mailing list (attachment size limit: 40KB)
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour