SQL Customization Script – TxQuery

In this step by step tutorial for beginner, learn how to use the TxQuery to query on local, using SQL statements.

TxQuery provides you the capability to use SQL query statement to query on a local, in-memory copy of the data. It can be used whenever you want to filter to the data stored in the TDataSet descendant component.

For this video, we’ll show you on how to utilize TxQuery in the OnBeforeSave event to capture the total Qty in the invoice.

𝐓𝐢𝐦𝐞 𝐒𝐭𝐚𝐦𝐩𝐬
00:00–00:17 Introduction
00:18–00:32 Usage of TxQuery
00:33– 00:54 Create DIY Field
00:55–01:13 Declaration
01:14–02:09 Main Function
02:10–02:24 Ending Demo