View Issue Details

IDProjectCategoryView StatusLast Update
0001166Database Workbench v5Generalpublic2015-05-11 12:25
ReporterWolfgang Rohdewald Assigned ToMartijn Tonies  
PrioritynormalSeveritytweakReproducibilityalways
Status closedResolutionfixed 
PlatformFirebird 2.5, I86 32, VirtualboxOSWindowsOS VersionWindows 7 Pro
Product Version5.0.8 
Fixed in Version5.1.0 
Summary0001166: Trigger Editor should do automatic syntax check before saving (like Procedure/Function/Package Editors do)
DescriptionThe stored procedure editor does so I would have thought it should be easy to do the same in trigger editors.

Steps To ReproduceExecute the script below. When saving the trigger, no warning appears about unused localvar
Additional InformationCREATE TABLE TEST
(
  ID INTEGER
);
SET TERM ^^ ;
CREATE TRIGGER TEST_ FOR TEST ACTIVE BEFORE INSERT POSITION 0 AS
declare variable localvar integer;
begin
  /* code */
end ^^
SET TERM ; ^^
TagsNo tags attached.

Activities

Martijn Tonies

2015-03-11 10:28

administrator   ~0000370

If you do "Syntax Check", it does, seems the automatic check is missing.

Issue History

Date Modified Username Field Change
2015-02-03 10:40 Wolfgang Rohdewald New Issue
2015-02-04 09:33 Martijn Tonies Assigned To => Martijn Tonies
2015-02-04 09:33 Martijn Tonies Status new => acknowledged
2015-03-11 10:28 Martijn Tonies Note Added: 0000370
2015-03-11 10:28 Martijn Tonies Severity minor => tweak
2015-03-11 10:28 Martijn Tonies Status acknowledged => assigned
2015-03-11 10:28 Martijn Tonies Category Firebird Module => General
2015-03-11 10:28 Martijn Tonies Summary Trigger editor does not warn about unused variables => Trigger Editor should do automatic syntax check before saving (like Procedure/Function/Package Editors do)
2015-03-11 11:00 Martijn Tonies Status assigned => resolved
2015-03-11 11:00 Martijn Tonies Fixed in Version => 5.1.0
2015-03-11 11:00 Martijn Tonies Resolution open => fixed
2015-05-11 12:25 Martijn Tonies Status resolved => closed