Multi-functional Query?

  • Thread starter Thread starter Starwood
  • Start date Start date
S

Starwood

Is it possible to construct a query that is multi-functional? I'd like to
be able to add, delete and modify database records in a single table without
having to construct multiple queries. If it's possible, does any sample
code exist?

I realize this can be done by simply opening the database table and
modifying it without any operator directions, but I'd like to make it safer
and more user-friendly than that.

Thanks,

George
 
Starwood said:
Is it possible to construct a query that is multi-functional? I'd like to
be able to add, delete and modify database records in a single table without
having to construct multiple queries. If it's possible, does any sample
code exist?

I realize this can be done by simply opening the database table and
modifying it without any operator directions, but I'd like to make it safer
and more user-friendly than that.
Click to expand...

Do you mean to modify records in groups? Normally such editing is done via a
form.

An UPDATE query can be created that will also Add new records, but there is no
way to have one action query perform all three.
 
Back
Top