Description: Delphi+SQL query record number of the main table key values in the other table in the test program, with a database file, the Database folder is. The code is very small, the 1.53M is basically a SQL database file. In this case the query to the record will display in the Datagrid, please attach the database and configure the connection before the test.
To Search:
File list (Check if you may need any files):
Delphi +SQL查询主表键值在其它表中出现的记录数\Database\mrxt_Data.MDF
.............................................\........\mrxt_Log.LDF
.............................................\Project2.cfg
.............................................\Project2.dof
.............................................\Project2.dpr
.............................................\Project2.drc
.............................................\Project2.dsk
.............................................\Project2.map
.............................................\Project2.res
.............................................\Unit1.dcu
.............................................\Unit1.ddp
.............................................\Unit1.dfm
.............................................\Unit1.pas
.............................................\Database
Delphi +SQL查询主表键值在其它表中出现的记录数
Download