Creating a progress meter when using make table

  • Thread starter Thread starter birdnacage
  • Start date Start date
B

birdnacage

I am trying to figure out how to use the SysCmd function
to run when I am creating a new table with a make table
query.

I have looked on the knowledge base and found the SysCmd
example where the meter progresses as records are being
read from an already existing table. It moves to the last
record to set the endpoint for the loop but since I am
creating the table, how can I handle it in code?

Thank you
 
I dont think you can. The make table query runs in "one hit" so there is no
loop for you to keep incrementing the progress meter.
If you really really wanted to do this you could
1. make the table (empty)
2. write a query which will return all the records you will ultimately be
adding to the new table. Set a recordset to the query. Find the number of
records (do a MoveLast followed by RecordCount) which you will use to set
the width of your progress meter.
Also open a recordset onto your new table
3. Go the the first record in the first recordset (MoveFirst), and looping
over all the records in the recordset manually add them one at a time to the
new table's recordset (look up .AddNew and .Update)
Each time you add a new record update the progress bar by one.

Hope thsi helps
 
Back
Top