as the subject,
i think it could be used as a recordset for a data control??
can anyone teach me the syntax, i seem to be confused by all
the ' and " and &.......

also i tried to use SQL to select fields from data control
and display it in DBGrid
but it seems that after setting the recordset as the SQL
i cannot refresh the data control.

thx in advance for any help

as the subject,
i think it could be used as a recordset for a data control??
can anyone teach me the syntax, i seem to be confused by all
the ' and " and &.......

also i tried to use SQL to select fields from data control
and display it in DBGrid
but it seems that after setting the recordset as the SQL
i cannot refresh the data control.

thx in advance for any help

dont forget to add these.. for sample..
adodc1.recordset.refresh

u must refresh when u have change the sql statement
sample?.. visit http://tapir.yeop.net/IS.html