>-----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