>-----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)
Harbour@harbour-project.org
http://lists.harbour-project.org/mailman/listinfo/harbour

Reply via email to