SQL Customization Script – TClientDataset – E Stream MSC

SQL Customization Script – TClientDataset

✨ The TClientDataset holds a local, in-memory copy of the data and operates independently of the database connection after fetching the data. It can be used whenever you want to refer to other data stored in another table.

✨ In this tutorial, we will guide you on how to utilise TClientDataSet in the OnGridColumnValueChanged event to retrieve the custom field value from the stock item.

✨ The result of this script is that whenever the user calls out or changes the item code in the sales invoice detail, the custom field value from the stock item would be copied into a column of the sales invoice’s detail.

𝐓𝐢𝐦𝐞 𝐒𝐭𝐚𝐦𝐩𝐬
00:0000:18 Introduction
00:1900:41 Usage of TClientDataset
00:4201:14 Create DIY Field
01:1501:30 Create Quick Form
01:3103:11 Function & Procedure
03:1203:23 Main Function
03:2403:38 Ending Demo

STEP 1: Scan QR Code to pay

SQL

STEP 2: Click here to email payment info

Overview