Talk:Jasper Test Sql

From iDempiere en

Thanks Hiep, sql workbench looks like interesting tool, reading the sources found in workbench/sql/ initPromptPattern method - the workbench.sql.parameter.prefix is based on regular expressions, so maybe (not tested) you can write an expression to recognize $P or $V at the same time as parameters.
--CarlosRuiz (talk) 18:29, 7 June 2015 (CEST)

BTW, I use Aqua Data Studio they provide a free license for open source developers. The default sql editor doesn't provide variable substitution, but they have a tool called Fluid Shell which can define and replace variables (and run as a shell script)
--CarlosRuiz (talk) 18:38, 7 June 2015 (CEST)

Cookies help us deliver our services. By using our services, you agree to our use of cookies.