Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » Elevate Web Builder Technical Support » Support Forums » Elevate Web Builder 2 Preview » View Thread |
Messages 1 to 2 of 2 total |
How to load database based on Integer field value? |
Fri, Jun 12 2015 6:36 PM | Permanent Link |
Trinione | 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; |
Fri, Jun 12 2015 11:25 PM | Permanent Link |
Trinione | 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. |
This web page was last updated on Wednesday, August 14, 2024 at 02:26 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |