View button in an update qry

[Razor]

Hi,

Is the "View" button (top left corner of query design-grid
view) of any use in an Update query?

Is it supposed to function as a test before hitting
the "!" button?

It doesn't seem to do much checking.

Thanks!

Regards,
Razor

 

[Dale Fye]

It is there to allow you to change your view of the query from the
query designer to the SQL view, to actually see or edit the SQL for
your query. It is not designed as a test before the execute.

--
HTH

Dale Fye



Hi,

Is the "View" button (top left corner of query design-grid
view) of any use in an Update query?

Is it supposed to function as a test before hitting
the "!" button?

It doesn't seem to do much checking.

Thanks!

Regards,
Razor

 

[Razor]

Dale,
I think it does help to see how MANY records you are about
to update. Am I right?
Razor

 

[Dale Fye]

You must be talking about the datasheet view.

I'd never used this option until you mentioned it, but it does appear
to return the results of the query for a select query, before taking
any action, so you can see what records will be appended, deleted, or
updated.

--
HTH

Dale Fye



Dale,
I think it does help to see how MANY records you are about
to update. Am I right?
Razor