Executing PostgreSQL script

[SymbolicFrank]

I'm trying to run a script like this:

Code: SQL  [Select][+][-]

1. DO
2. $do$
3. BEGIN
4.    IF EXISTS (SELECT FROM orders) THEN
5.       DELETE FROM orders;
6.    ELSE
7.       INSERT INTO orders VALUES (1,2,3);
8.    END IF;
9. END
10. $do$

It doesn't matter if I try to execute this with a TSQLQuery or TSQLScript, I always get this error:

Code: Text  [Select][+][-]

1. Primary Error: unterminated dollar-quoted string at or near "$do$

In pgAdmin it works as expected.

[gsa]

It doesn't matter if I try to execute this with a TSQLQuery or TSQLScript, I always get this error:

Code: Text  [Select][+][-]

1. Primary Error: unterminated dollar-quoted string at or near "$do$

In pgAdmin it works as expected.

Using TSQLScript you should set the folowing properties:

      UseDollarString := True;
      DollarStrings.Add('$$'); 

Gerd

[SymbolicFrank]

Ah, thanks. I had replaced the "$do$" with a single quote and doubled up all the other ones, but that makes a mess of it.

[gucao]

uses tsqlquery is ok.
test with lazarus 2.2.0.