How to use parameters in TpFIBDataSet SQL query?

Question

I am using FIBPlus library and Delphi 10.3 Rio.

Inside my project I have TpFIBDataSet component.

Under SQL Generator I defined SQL Select with 'where clause' and inside 'where clause' I have one parameter.

How can I use that parameter in my code, and how can I pass value into that parameter?

Add the code and the query you are using, the current form of your question will not lead to an exact solution. — Nasreddine Galfout, Feb 15 '19 at 17:53
Your question is a bit misleading. Until I had read the question, I thought you meant parameters to an Object Pascal function. But you mean parameters to some SQL query or some such. And it is terribly vague. People will need more information, especially: what have you tried already? Give us the code. — Rudy Velthuis, Feb 15 '19 at 18:09
@RudyVelthuis: Yes, he meant a SQL parameter, or i'm a Dutchman. — MartynA, Feb 15 '19 at 18:21
Everyone wishes they were. And if not, that's just because they don't know how great it is. — Rudy Velthuis, Feb 15 '19 at 19:24

MartynA · Accepted Answer · 2019-02-15T22:22:10.183

2

I don't have a copy of the TpFIBDataSet handy. but usually you set a dataset parameter by code like this:

MyDataSet.Parameters.ParamByName('BROJ').AsString := 'some value';

Note : With some TDataSet descendants, the parameters collection is named Params rather than Parameters.

I gather from your suggested edit that with the dataset type you are using, you can write this instead:

MyDataSet.ParamByName('BROJ').AsString := 'some value';

edited Feb 15 '19 at 22:22

answered Feb 15 '19 at 18:24

MartynA

I did some changes and now its working perfectly. U gave me huge clue! Thank you so much! – Tripta Feb 15 '19 at 18:30

1 Answers1