TUniQuery 2.5 Problems with curly Braces inside PL/TCL

[adroege]

I need to run a script similar to the following to define
a trigger function for PostgreSQL written in PL/TCL language.

Code: Select all

CREATE OR REPLACE FUNCTION testtcl()
  RETURNS trigger AS
$BODY$
spi_exec "SELECT relname AS tgname FROM pg_class WHERE relfilenode = $TG_relid"
if {[string equal -nocase $tgname audit]} { return OK }

return [array get NEW]
$BODY$
LANGUAGE 'pltcl' VOLATILE SECURITY DEFINER
;

Now with the 2.5 version of TUniQuery, I get the following
error: "Empty macro or function name"


Is there a property to set or some other workaround so that TUniQuery won't interpret the '{' as a macro in this instance?

Thanks.

[Plash]

Set the EnableUniSQL global variable from the Uni unit to False.

[adroege]

I'm doing the following:

Uni.EnableUniSQL := False;

But I get the message that this variable
can't be changed.


Is there something I'm missing?

Thanks.

[Plash]

We have fixed this problem. The fix will be included in the next build of UniDAC.

If you need the fix urgently, please contact us by e-mail unidac*devart*com, specify your licence number and Delphi version.

[MarcoFerlini]

Hi,
I have the same problem with SQL Server and TUniStoreProc.
Setting Uni.EnableUniSQL := False; not work.....

Thank you,
Marco

[Plash]

If you cannot assign False to the EnableUniSQL variable, and have UniDAC with Sources, you can fix the problem in the following way:
- open the Uni.pas file;
- find the code:

Code: Select all

const
  EnableUniSQL: boolean = True;

- replace 'const' with 'var'.

This fix will be included in the next build of UniDAC.