View Issue Details

IDProjectCategoryView StatusLast Update
0001329Database Comparer VCLGeneralpublic2019-04-18 19:46
Reportershirokov Assigned Tobarry  
PriorityhighSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Fixed in Version7.0.0.1670 
Summary0001329: Firebird 3.0, cannot parse DATEADD, DATEDIFF, OVERLAY functions
DescriptionDATEADD(-12 MONTH TO :ADATA_STOP);
DATEDIFF(DAY FROM :VDATALOT TO :ALADATA);

The error message is:
Missing: <)> (TO)
or
Missing: <)> (FROM)


 UPDATE DOCTRF D
 SET D.CODBUGETS = OVERLAY(D.CODBUGETS PLACING :ANEW_VALUE FROM :VPOZSTART FOR :VLEN)
 WHERE D.DATADOC BETWEEN :VDATASTART AND :VDATASTOP
 AND D.CODBUGETS <> '.'
 AND D.CODBUGETS <> ''
 AND SUBSTRING(D.CODBUGETS FROM :VPOZSTART FOR :VLEN) = :AOLD_VALUE;
The error message is
Missing: <)> (<:>)
Steps To ReproduceIt's necessary to update the IBExParser code: add st_FireBird_30 to conditions.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2018-04-10 15:29 shirokov New Issue
2018-04-10 15:29 shirokov Status new => assigned
2018-04-10 15:29 shirokov Assigned To => barry
2018-04-25 19:04 barry Status assigned => resolved
2018-04-25 19:04 barry Resolution open => fixed
2018-04-25 19:07 barry Fixed in Version => 7.0.0.1670
2019-04-18 19:46 barry Status resolved => closed