The example shows a String parameter, what if one needs to query a table based on an Integer field?

-----------------------------------------------------------------------
DataSet Name: CustomerOrders

Row Source:

SELECT * FROM custord
WHERE CustomerID={CustomerID=123}

Base Table: custord

-----------------------------------------------------------------------

procedure TMasterDetailForm.LoadOrders;
begin
  CustomerOrders.Params.Clear;
??? >>   CustomerOrders.Params.Add('CustomerID='+QuotedStr(Customer.Columns['CustomerID'].AsString));
  Database.Load(CustomerOrders);
end;

Trinione wrote:

The example shows a String parameter, what if one needs to query a table based on an Integer field?

-----------------------------------------------------------------------
DataSet Name: CustomerOrders

Row Source:

SELECT * FROM custord
WHERE CustomerID={CustomerID=123}

Base Table: custord

-----------------------------------------------------------------------

procedure TMasterDetailForm.LoadOrders;
begin
  CustomerOrders.Params.Clear;
??? >>   CustomerOrders.Params.Add('CustomerID='+QuotedStr(Customer.Columns['CustomerID'].AsString));
  Database.Load(CustomerOrders);
end;

Wow! Clearly its been a long week. No need for the QuotedStr().

!!! >>   CustomerOrders.Params.Add('CustomerID='+ Customer.Columns['CustomerID']);  // where CustomerID column is an integer.