Problem changing the delimiter with TZSQLProcessor

[mparak]

Dear Friends,

I have a User defined function that runs beautifully if created from mySQL command prompt. It changes the delimiter to | first and when complete changes it back to the semi-colon.

When I load the script into the TZSQLProcessor I get a sql error.

If some kind could guide me on how to issue the "delimiter |" command from within TZSQLProcessor component I would be very grateful.
Simply setting the delimiter property of the component does not work.

Regards

M Parak

[seawolf]

Until now it cannot be possible do what you asked. Anyway there are 2 possibilites:

1. change Delimitertype to dtEmptyLine and substituing every | to an empty line

2. open ..\parser\ZScriptParser.pas and change every ';' to '|' (do it if you are in a very desperate condition)

[mparak]

Dear SeaWolf,

I am very pleased to tell you that the dtEmptyLine trick worked beautifully.
Many thanks bro.

Regards

M