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

Reply via email to