Page 1 of 1

TMSStoredProc issue

Posted: Wed 14 Nov 2012 14:36
by wkamouh
SDAC version 6.5.10
delphi xe3 and delphi 2010

Once you initially set the stored procedure name and activate it (at design time) it works well. then try double click on the stored procedure and click ok without doing anything else; if you try to activate the stored procedure now, you get the error message: no SQL Statement is provided !!!!
how soon can this be fixed?
Thanks

Re: TMSStoredProc issue

Posted: Wed 14 Nov 2012 15:12
by AndreyZ
We know about this problem. We will fix it in the next SDAC build.

Re: TMSStoredProc issue

Posted: Tue 27 Nov 2012 20:33
by GNiessen
Is there a work around?

Re: TMSStoredProc issue

Posted: Wed 28 Nov 2012 11:15
by AndreyZ
The workaround is to call the TMSStoredProc.PrepareSQL method before opening or executing TMSStoredProc, as follows:

Code: Select all

MSStoredProc1.PrepareSQL;
MSStoredProc1.Open;

Re: TMSStoredProc issue

Posted: Wed 28 Nov 2012 13:53
by GNiessen
Thanks, I was able to revert to the earlier version and get it to work again. I will try this later this week.

Re: TMSStoredProc issue

Posted: Fri 30 Nov 2012 11:03
by AndreyZ
We have fixed this problem. This fix will be included in the next SDAC build.

Re: TMSStoredProc issue

Posted: Tue 11 Dec 2012 01:51
by Rodrigo
Hi,

Alguma previsão para a proxima atualização ?

Re: TMSStoredProc issue

Posted: Tue 11 Dec 2012 06:44
by AndreyZ
We plan to release all DAC products approximately in a week or two.