Problem: Format SQL changes variable type

Hi, i have a problem with "Format SQL" in the SQL Commander. Example: Select * from lab where pnr=$$Pnr||0||Integer $$; changes to: SELECT * FROM lab WHERE pnr = $$Pnr||0||INTEGER $$; (INTEGER instead of Integer). When executing this i get the (german) error message: [Error Code: 0, SQL State: 42883] FEHLER: Operator existiert nicht: integer = character varying Kind regards Jan Heidrich My Setting: --------------------------------------------------------- Product: DbVisualizer Personal 8.0.11 Build: #1772 (2012/09/26 11:05) Java VM: Java HotSpot(TM) Client VM Java Version: 1.7.0_09 Java Vendor: Oracle Corporation OS Name: Windows XP OS Arch: x86 OS Version: 5.1 PostgreSQL 8.4.5 PostgreSQL Native Driver PostgreSQL 9.1 JDBC4 (build 902) -----------------------------------------------------

Hi, Thanks for reporting this. I've opened a ticket for this issue. Best Regards, Hans

Hi, Just wanted to let you know that this is now fixed in the just released DbVisualizer 8.0.12. Best Regards, Hans