View Issue Details

IDProjectCategoryView StatusLast Update
0001808HopperGeneralpublic2020-09-03 15:04
ReporterMartijn Tonies Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Fixed in Version2.1.1 
Summary0001808: SQL error during specific expression evaluation
DescriptionSee test case by Michael

Steps To ReproducesFeeSet = LEFT(sFeeList, iColonPos -1);

The "-1" isn't recognized as a formula expression, but instead taking as a literal.

As this result goes into a VarChar, the value is surrounded by (..), the SQL eval fails.

TagsNo tags attached.
DBMS Version

Activities

Martijn Tonies

2020-09-02 09:45

administrator  

!cid_image001_png@01D67D0A.png (12,873 bytes)   
!cid_image001_png@01D67D0A.png (12,873 bytes)   

Issue History

Date Modified Username Field Change
2020-09-02 09:45 Martijn Tonies New Issue
2020-09-02 09:45 Martijn Tonies File Added: !cid_image001_png@01D67D0A.png
2020-09-02 15:09 Martijn Tonies Category Firebird => General
2020-09-02 15:10 Martijn Tonies Assigned To => Martijn Tonies
2020-09-02 15:10 Martijn Tonies Status new => resolved
2020-09-02 15:10 Martijn Tonies Resolution open => fixed
2020-09-02 15:10 Martijn Tonies Fixed in Version => 2.1.1
2020-09-03 15:04 Martijn Tonies Status resolved => closed