Dear Marco,

Have you uploaded the patches already ?

We'll need to roll this into the final 4.1.1 patch release, which includes some additional fixes. It will be available in one or two weeks.

Dear Marco,

Are you releasing the patch soon ? It has been almost 4 months in the making and no news.

Regards

The patch release is ready. You can download the Delphi 7 version here . This patch release is not yet published.

Dear Marco,

Nope.It's not working.

The patch of TOracleScript still cannot parse MERGE statements.


Regards

That is strange. I will check it out today.

I double-checked, and it works okay. Can you send me your complete script text?

Dear Marco,

I used the same SQL Syntax to test the parsing of merge statement in TOracleScript.

merge
into contract a
using customer b
on (a.cust_id = b.cust_id)
when matched then
update set a.desc = b.profile,
a.customer_name = b.cust_name,
when not matched then
insert values ( b.profile,
b.cust_name);

When TOraclescript reach the merge statements, it is able to detect that it is a nonSQL type but only returns "merge" as a command.substitutedtext property and skip the rest of the lines below.

I uninstall and reinstall DOA but it still doesnt work.Hope you can further investigate. Thanks

Regards

[quote]When TOraclescript reach the merge statements, it is able to detect that it is a nonSQL type but only returns "merge" as a command.substitutedtext property and skip the rest of the lines below.[/quote]When I try this statement in a script in 4.1.1, it recognizes MERGE as a SQL statement, and sends it to the server. In 4.1.0 and earlier, it would not have been recognized as a SQL statement.