UniScript1 AND bcb6 and Params

[xj_hwc]

UniScript1->SQL->Add("INSERT INTO T_RKD_D(F_ID,F_MC) VALUES(:F_ID,:F_MC)");
UniScript1->Params->ParamByName("F_ID")->Value=100;
UniScript1->Params->ParamByName("F_MC")->Value="AAA";UniScript1->Execute();

The error is：parameter 'F_ID' not found,why?
i use BCB6 AND UniScript1

[AndreyZ]

The point is that the TUniScript component doesn't create parameters automatically. Therefore to solve the problem, you should create needed parameters on your own. Here is an example:

Code: Select all

UniScript1->SQL->Add("INSERT INTO T_RKD_D(F_ID,F_MC) VALUES(:F_ID,:F_MC)");
UniScript1->Params->CreateParam(ftInteger, "F_ID", ptInput);
UniScript1->Params->CreateParam(ftString, "F_MC", ptInput);
UniScript1->Params->ParamByName("F_ID")->AsInteger = 100; 
UniScript1->Params->ParamByName("F_MC")->AsString = "AAA";
UniScript1->Execute();