SELECT f1, f2, f3 FROM table1 -> if I want to hide f3 how to write sql statement

[Phogang]

SELECT f1, f2, f3 FROM table1

if I want to hide f3 but f1, f2 still display and f3 include in the recordset.

how to write sql statement.

remove the colomn of grid is not fit in my project.

Thank guru.

[mgn0528]

The columns you include in the sql statement will be included in the recordset. If you don't want to display it then hide the column of the grid (set width = 0). If you're not actually using the value in that column but only as a constraining value then you don't need to include it in the column list of the sql statement.