Desperate help Data type for parameter 1 has changed

[Jack Lok <j.lok@GEMBA.NL>]

Hello,

I have a problem with SQL statements in my report, I was able to solve
this problem for sql statements with a where clause by using a dynamic
where value.

I am not able to solve it for the next problem:

begin-procedure eqtrans
let $sdate= strtodate(datetostr(datenow(), 'DD-MON-YYYY HH:MI'), 'DD-MON-YYYY
HH:MI')
        begin-sql
                insert into eqtrans
                (EQNUM,transdate,datemoved,FROMLOC,TOLOC,ENTERBY,MEMO,WONUM)
                values 
($matnr,$sdate,$sdate,$OLDloc,$werk,$username,'VERHUUR',$VERHUUR)
        END-SQL
end-procedure

It works until the eqnum value changes in length or an all numeric value
is followed by an alfanumeric value, I always get this error message:

(SQR 5528) ODBC SQL dbexec: SQLExecute error 0 in cursor 4:
   [INTERSOLV][ODBC SQLBase driver]Data type for parameter 1 has changed
since first SQLExecute call.

Error on line 240:
   (SQR 3735) Could not execute SQL.

I know this is due to an SQR bug #3089, however this doesn't help me.
Does anyone know a workaround or a patch to download in order to solve
my problem


Thanks for your reply

Jack Lok