Parameter "DAPARAM_1" not found

Data Abstract
1

Hi,
I got the following error when I build the “Master-Detail” relationship.

image

I’m using the following sample code to handle master table and detail table. Both are Stored Procedure dataset.

tbl_master.Active := false;
tbl_master.ParamByName(‘Fty’).Value := srh_company.EditText;
tbl_master.ParamByName(‘IssueFNbr’).Value := srh_IssueFNbr.EditText;
tbl_master.Active := true;
tbl_detail.Active := false;
tbl_detail.ParamByName(‘Fty’).Value := srh_company.EditText;
tbl_detail.ParamByName(‘IssueFNbr’).Value := srh_IssueFNbr.EditText;
tbl_detail.Active := true;

2

Hi,

DAPARAM_%d name is used for passing values of constants in the Dynamic Where expression.

In your code I don’t see usage of DynamicWhere …

3

Hi,
I use “Master/Detail Wizard” to build the relationship. I still need to set “Dynamic Where” expression?

4

Hi,

We have several modes of m/d relation. I don’t know what one you have used.

https://docs.dataabstract.com/API/Delphi/Enums/TDAMasterMappingMode/

5

Hi,
I’m using “mmWhere”.

6

Hi,

I don’t think, that stored procedure tables and where conditions are compatible because you can’t apply where expressions correctly

imagine this syntax:

EXEC sp WHERE id = :master_id

I can recommend to use mmParams mode for stored procedure tables

7

Hi,
Noted with thanks. I tried it hasn’t error now if using mmParams.