A test of 7.0 (32 Bit) on SqlServer shows folowing problem:
Fetching a binary datafield from an SQLServer database (other databases not testet) uses as index for SqlSetLongBindDatatype now first the bind variables within the WHERE clause and after that the INTO binds.
In Prior versions this code works fine:
If SqlPrepare(hSql,'SELECT blob FROM mytable INTO :lVar WHERE keyfield = :nID')
Call SqlSetLongBindDatatype( 1, DT_Binary )
If SqlExecute( hSql ) And SqlFetchNext(hSql,nRetVal)
But in TD 7.0 an SQL error occurs because SqlSetLongBindDatatype( 1, DT_Binary ) switches the :nID bind variable and not the :lVar to a binary content.
I think this is a bug and should be changed.
Who is online
Users browsing this forum: [Ccbot] and 0 guests