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____
Where/how can I try improve it (in odbcdd.c) ? :
switch( iDataType )
{
case SQL_CHAR:
case SQL_VARCHAR:
case SQL_LONGVARCHAR:
case SQL_WCHAR:
// case -8:
// case -9:
case SQL_WVARCHAR:
case SQL_WLONGVARCHAR:
pFieldInfo.uiType = HB_FT_STRING;
break;
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;
case SQL_BIT:
pFieldInfo.uiType = HB_FT_LOGICAL;
break;
case SQL_DATE:
case SQL_TYPE_DATE:
pFieldInfo.uiType = HB_FT_DATE;
break;
case SQL_TIME:
case SQL_TYPE_TIME:
pFieldInfo.uiType = HB_FT_DATE;
break;
/* SQL_DATETIME = SQL_DATE = 9 */
case SQL_TIMESTAMP:
case SQL_TYPE_TIMESTAMP:
pFieldInfo.uiType = HB_FT_TIMESTAMP;
break;
default:
/* HB_TRACE( HB_TR_ALWAYS, ("new sql type=%d", iDataType) );
*/
bError = TRUE;
errCode = ( HB_ERRCODE ) iDataType;
pFieldInfo.uiType = 0;
pFieldInfo.uiType = HB_FT_STRING;
break;
}
Regards,
Marek Horodyski
_______________________________________________
Harbour mailing list (attachment size limit: 40KB)
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour