Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 2 of 2 total |
error 11949 upgrading from 4.40 to 4.48 |
Thu, May 30 2019 6:23 AM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |