By creating a data set with the Client/Server Workspace's Data Set Designer the code can be significantly reduced. The data set definition contains pre-defined definitions of the table columns; the Select. Insert, Delete, and Update SQL Statements; and the Data Source. The BASIC+ program calls the data set oriented functions, passing arguments to accomplish many tasks. These functions are:
DSInstance(), to create an instance of the data set.
DSSetProperty() and DSGetProperty() to set and retrieve data set properties.
DSMethod() to execute "methods" (aka functions) associated with the data set.
In this example, we will create a data set using the Data Set Designer, and then use the data set in rewriting the code to populate a combo box from Microsoft Access.