Re: Desperate help Data type for parameter 1 has changed

[Peter Alan Burton <peterb@SQRIBE.COM>]

Jack,

My example adjusted the wrong field (being a programmer I am so used to
dealing with as the first element). The same logic applies though -- use
the form [$var] rather than $var references.

Peter

On 8 Jun 99, at 6:57, Jack Lok wrote:

Date sent:              Tue, 8 Jun 1999 06:57:16 +1800
Send reply to:          SQR-USERS@list.iex.net
From:                   Jack Lok <j.lok@GEMBA.NL>
Organization:           Gemba Service
Subject:                Desperate help Data type for parameter 1 has changed
To:                     Multiple recipients of list SQR-USERS 
<SQR-USERS@list.iex.net>

> --=PMail:=_0004@@VhvWW4PQ12c2aEnhciwR
> Content-Type: text/plain
> Content-Transfer-Encoding: quoted-printable
>
> 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=3D strtodate(datetostr(datenow(), 'DD-MON-YYYY HH:MI'), 'DD-MON-YY=
> YY
> 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
>
> --=PMail:=_0004@@VhvWW4PQ12c2aEnhciwR--
>