bug in detection of stored procedure parameters

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Ludek

bug in detection of stored procedure parameters

Post by Ludek » Thu 21 Jul 2005 06:51

Hi folks,
I'm using SDAC 3.55.0.16 with Delphi 7 and I'm having trouble with some specifically named parameters of stored procedures.
When I'm trying to execute following stored procedure using TMSStoredProc

create procedure testsp @from datetime
as
print 'test'

the TMSStoredProc only detects one parameter RETURN_VALUE. If I change the procedure to

alter procedure testsp @fromdat datetime
as
print 'test'

the parameter gets correct identified. Please could you do something with it? I can't execute some old stored procedures :( Thanks.

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Thu 21 Jul 2005 09:35

Thank you for information.
We reproduced your problem and fixed it. This fix will be included in the next SDAC build. It will be available in about two weeks.
Please look forward for announcments at the forum

Post Reply