Jump to content
Mark Williams

FireDAC paramamania

Recommended Posts

I am having difficulties with a parameterized query designed to be used repeatedly. It works first time but never a second.

 

The query is fairly complicated so I prepare it on app initialization for repeated use, but it works just once and returns an empty dataset on every other occasion (even with the same parameter).

 

If I reset the query text (FDQuery.SQL.Text := FDQuery.SQL.Text) it works as expected.

 

That rather defeats the purpose of preparing the query in advance. Is it the case that parameters cannot be used in repeated queries?

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×