-----Original Message----- From: Shum [mailto:wcshu...@hotmail.com] Sent: Tuesday, April 06, 2010 10:49 PM To: harbour@harbour-project.org Subject: [Harbour] Error with dBUseArea(...) with rddsql (sddodbc) withmysql ???
Hi All, I continue to test sddodbc with mysql for adding a BIGINT field ...but error comes out : http://www.mingyik.com/dnload/tstodbc40.jpg http://www.mingyik.com/dnload/txtodbc50.jpg the error comes out at the line with dBUsearea(...) and the source at follow: *--------------------- Hi Shum, I too have trouble with new type in MS SQl. Advice from Mindaugas, try change in fil\harbour\contrib\rddsql\sddodbc\odbcdd.c Fe.: ║319│ switch( iDataType ) ║320│ { ║321│ case SQL_CHAR: ║322│ case SQL_VARCHAR: ║323│ case SQL_LONGVARCHAR: ║324│ case -8: ║325│ case -9: ║326│ pFieldInfo.uiType = HB_FT_STRING; ║327│ break; Or make trick wthh convert type in query, like this : select p.ID_PODMIOT as ID_PODMIOTU, convert( varchar, u.ID_klienta) as ID_klienta,... With this I can work with MsSql :) Regards, Marek Horodyski _______________________________________________ Harbour mailing list (attachment size limit: 40KB) Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour