Query-Run

  • Thread starter Thread starter Douglas
  • Start date Start date
D

Douglas

When I build a query, i normally use the Run icon. You can also use the
view icon. Is there a difference between using the Run and the view
icon..even though I get the same results? When should i use each of these?

Douglas
 
There is no difference if the query is a SELECT query.

With all other query types, the View Icon generally shows
what effect the query would have if it were run e.g. if it
were a DELETE query, you would use the View Icon to see
which rows would be deleted and the Run Icon to actually
delete the rows.

Hope This Helps
Gerald Stanley MCSD
 
Back
Top