Page 1 of 1

Issue with UniConnection.ExecProc and Macros

Posted: Thu 29 Apr 2010 04:59
by hughespa
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.

Posted: Thu 29 Apr 2010 11:35
by Dimon
Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next UniDAC build.

Posted: Fri 30 Apr 2010 15:19
by hughespa
Great, Thank you.

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

Regards, Paul.

Posted: Wed 05 May 2010 06:56
by Dimon
We are planning to release the new build of UniDAC in two weeks.

Posted: Wed 05 May 2010 07:33
by hughespa
That's great, thank you.

Regards, Paul.