Creating a progress meter when using make table

[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

 

[Andrew Coyle]

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