I need an explanation to a line in a code for a Data Dictionary

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Im creating a data dictionary and have a line of code from the
CmdCreateDD_Click procedure:

DoCmd.RunSQL "delete tblDD.* from tblDD;"

it works but I dont understand what the procedure is doing and why it is
needed; why delete?

Im using Access 2003
 
RedCentreLPlater said:
Im creating a data dictionary and have a line of code from the
CmdCreateDD_Click procedure:

DoCmd.RunSQL "delete tblDD.* from tblDD;"

it works but I dont understand what the procedure is doing and why it is
needed; why delete?

Im using Access 2003
Click to expand...

The code deletes all the records from the table tblDD. As to why it should
do this, I'm afraid that is a question for whoever designed the thing.
 
It's a Delete action query, deleting everything in table tblDD, most likely
in order to exclude duplication because next thing in the code the table is
re-populated from scratch.

HTH,
Nikos
 
Back
Top