Using a filter in a TMSStoredProc

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ehelmers
Posts: 2
Joined: Wed 17 Feb 2010 19:58
Location: Cincinnati, Ohio

Using a filter in a TMSStoredProc

Post by ehelmers » Wed 17 Feb 2010 22:11

I am feeding a text string to a TMSStoredProc as follows:

spGetDataX.Active := False;
spGetDataX.Prepare;
spGetDataX.Filter := 'DateSequence = ' + QuotedStr(DateToStr(dxMemDisplay.FieldByName('DateLow').AsDateTime));
spGetDataX.Filtered := True;
spGetDataX.Active := True;

and it returns no data, where as, if I use a TwwStoredProc with the identical code, I get the result set I am expecting. I am in the process of upgrading to SDAC 4.80.0.55 for RAD Studio 2010, and I use similar code like this throughout multiple apps.

I have scoured the forums and it looks like there were similar issues with the TMSQuery component, but I couldn't find anything on the TMSStoredProc. I think it has something to do with how the component parses the quotes in the string.

Any help would be appreciated.

Thanks,

Eric

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Thu 18 Feb 2010 08:07

I could not reproduce the problem.
Please send me a complete small sample to dmitryg*devart*com to demonstrate it, including a script to create and fill table.
Also specify the exact version of SDAC.

ehelmers
Posts: 2
Joined: Wed 17 Feb 2010 19:58
Location: Cincinnati, Ohio

Post by ehelmers » Thu 18 Feb 2010 12:18

Dimon wrote:I could not reproduce the problem.
Please send me a complete small sample to dmitryg*devart*com to demonstrate it, including a script to create and fill table.
Also specify the exact version of SDAC.
When I created you a test app, I too couldn't reproduce the problem. Everything works as advertised. It obviously doesn't appear to be a problem with the control. Looks like something I'm doing wrong. I will keep plugging.

Thank you for your time. I apologize for wasting it.

Eric

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 19 Feb 2010 08:15

If any other questions come up, please contact me.

Post Reply