Hello Jason,

TIBOQuery .. Version 4.5B

qryGeneral2->Close();

qryGeneral2->SQL->Text = "update period_value_daily r set sale = sale -
:sale, on_hand = on_hand + :quantity, qty_sold_out = qty_sold_out -
:quantity ";

qryGeneral2->SQL->Text += ",cost_of_sale = cost_of_sale - ( :avgcost *
:quantity ) ";
qryGeneral2->SQL->Text +="where trackingdate = :saledate and item_code =
:itemcode";
qryGeneral2->Prepare();

for (int i = 0;i < dtm_Sales->qryGeneral2->ParamCount; i++)
ShowMessage(String(i) + " - " +
dtm_Sales->qryGeneral2->Params->Items[i]->Name);

Results only in
0 - sale
1 - quantity

and no more

salesdate, avgcost and itemcode are not part of the Params

Any ideas ?
Best Regards
Hans