Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread error 11949 upgrading from 4.40 to 4.48
Thu, May 30 2019 6:23 AMPermanent Link

Mirco Malagoli

Hi,
this query in 4.40 work ok
"DELETE FROM gara
WHERE batteria = :Pbatteria AND prova = :Pprova AND
finale = :Pfinale AND :Pskip = :Pskip
;
DELETE FROM giri
WHERE batteria = :Pbatteria AND prova = :Pprova AND finale = :Pfinale AND :Pskip = :Pskip
;
DELETE FROM decoder
WHERE batteria = :Pbatteria AND prova = :Pprova AND finale = :Pfinale AND :Pskip = false
;"

After upgrade to 4.48 i receive this error
"Error # 11949 SQL parsing error - Cannot infer parameter type in DELETE SQL statement at line 3, column 16'. Process XRacerTime.exe (5684)"

What's wrong?
Thanks!
Mon, Jun 3 2019 11:17 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Mirco,

<< After upgrade to 4.48 i receive this error
"Error # 11949 SQL parsing error - Cannot infer parameter type in DELETE SQL statement at line 3, column 16'. Process XRacerTime.exe (5684)" >>

Yes, automatic population of parameters was added recently in DBISAM to allow for better ODBC functionality (among other things), so DBISAM must be able to infer the parameter type from the surrounding expression(s) or you will see this error.

To workaround this issue, use this instead:

DELETE FROM gara
WHERE batteria = :Pbatteria AND prova = :Pprova AND
finale = :Pfinale AND CAST(:Pskip AS BOOLEAN) = :Pskip

(or whatever type the :Pskip parameter should be).

Tim Young
Elevate Software
www.elevatesoft.com
Image