Issue with UniConnection.ExecProc and Macros

hughespa · Post by **hughespa** » Thu 29 Apr 2010 04:59

Hi,

D2010, UniDAC 3.00.0.8, SQL Server 2008 (Express and Std)

When I call the following stored procedure via the UniConnection:

UniConnection1.ExecProc('sys.sp_rename', ['OLD_NAME', 'NEW_NAME', NULL]);

it returns an error:
exception class Exception with message 'Empty macro or function name'

This only happens when I have defined some macros for the connection such as:
UniConnection1.Macros.Add(SQL_TRUE, ' 1 ', 'SQLServer');
UniConnection1.Macros.Add(SQL_FALSE, ' 0 ', 'SQLServer');

To work around it I have to set:
Uni.EnableUniSQL := False
before calling the stored proc and then enable it again afterwards.

If I remove any connection macros it works correctly even when Uni.EnableUniSQL is True.

Is this a bug?

Regards, Paul.

Dimon · Post by **Dimon** » Thu 29 Apr 2010 11:35

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next UniDAC build.

hughespa · Post by **hughespa** » Fri 30 Apr 2010 15:19

Great, Thank you.

Do you have an expected release date for the next build please?

Regards, Paul.

Dimon · Post by **Dimon** » Wed 05 May 2010 06:56

We are planning to release the new build of UniDAC in two weeks.

hughespa · Post by **hughespa** » Wed 05 May 2010 07:33

That's great, thank you.

Regards, Paul.