TMSStoredProc issue

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
wkamouh
Posts: 1
Joined: Wed 14 Nov 2012 14:27

TMSStoredProc issue

Post by wkamouh » Wed 14 Nov 2012 14:36

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

AndreyZ

Re: TMSStoredProc issue

Post by AndreyZ » Wed 14 Nov 2012 15:12

We know about this problem. We will fix it in the next SDAC build.

GNiessen
Posts: 28
Joined: Wed 18 Jan 2012 20:15

Re: TMSStoredProc issue

Post by GNiessen » Tue 27 Nov 2012 20:33

Is there a work around?

AndreyZ

Re: TMSStoredProc issue

Post by AndreyZ » Wed 28 Nov 2012 11:15

The workaround is to call the TMSStoredProc.PrepareSQL method before opening or executing TMSStoredProc, as follows:

Code: Select all

MSStoredProc1.PrepareSQL;
MSStoredProc1.Open;

GNiessen
Posts: 28
Joined: Wed 18 Jan 2012 20:15

Re: TMSStoredProc issue

Post by GNiessen » Wed 28 Nov 2012 13:53

Thanks, I was able to revert to the earlier version and get it to work again. I will try this later this week.

AndreyZ

Re: TMSStoredProc issue

Post by AndreyZ » Fri 30 Nov 2012 11:03

We have fixed this problem. This fix will be included in the next SDAC build.

Rodrigo
Posts: 1
Joined: Tue 11 Dec 2012 00:12

Re: TMSStoredProc issue

Post by Rodrigo » Tue 11 Dec 2012 01:51

Hi,

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

AndreyZ

Re: TMSStoredProc issue

Post by AndreyZ » Tue 11 Dec 2012 06:44

We plan to release all DAC products approximately in a week or two.

Post Reply