Q: How to query that the SmID is an odd record in the dataset?
A: SQL query statements are slightly different for different types of datasources: 1. Sdb datasource: select Point.* from Point where Point.SmID Mod 2 <> 0; 2. Udb and ql server datasource: Select Point.* From Point where Point.SmID%2!=0; 3. Oracle datasource: Select Point.* From Point where Mod(Point.SmID,2)!=0.
