from tab “ Data Access” component of type TDataSource to connect between the dataset and component of TDBGrid type (Fig.from tab dbGo component of type TADOQuery to organize the SQL-query (Fig.from tab dbGo the component of type TADOConnection for connecting to database (Fig.Place on the form components of following types: The project name is “ Project1.dproj” by default. The name of module of main form is “ Unit1.pas” by default. The interconnection scheme between tables The interconnection scheme between tables is shown in Figure 1.įig. Start of sorting should be called when you click on the header of the corresponding field of table “ Marks“. You need realize the sorting in ascending or descending order. Into the table “ Marks”, you need realize the sorting of data using all fields. You need to develop the application, which shows table “ Marks”. This problem is solved in this task.ĭatabase “ 01_02_00_010_mydb.mdb ”, which was formed by Microsoft Access, is given. Often in applications that work with databases, you need to realize the sorting of data for some field, which is selected by mouse clicking on it’s title. An example of sorting in database using component TADOQuery
0 Comments
Leave a Reply. |