Location:
Search - datafilt
Search list
Description: 当我们在操作数据集时，往往需要对数据进行筛选。例如：一个名为Customer的数据表，它具有CustNo、CustName、Country、Address、Phone、State、TaxRate等字段，如果只想查看国别为China或顾客号大于1000的顾客记录，就需要对数据集进行过滤。经总结，有下面这些过滤方法：
一、利用Ttable和Tquery的Filter属性
二、用ApplyRange筛选数据集的记录
三、用OnFilterRecord事件筛选
四、用Tquery控件的SQL语句-When we operate in data collection, data often need to be screened. For example : one called the Customer Data Sheet, which has CustNo, CustName. Country, Address, Phone, State, TaxRate other fields, If you only want to check China, or the country for more than 1,000 customers, customer records, on the need to filter data sets. After summing up, these filtering methods below : 1. Ttable Tquery use of the Filter and two attributes, ApplyRange screening using data set three records, Screening with OnFilterRecord four events, with Tquery Control SQL
Platform: |
Size: 1024 |
Author: chen |
Hits: