🚀 go-pugleaf

I am using the following code (OODML I hope<g>) to open a new database, get
some info from the table, do some other stuff, then delete all the records
in the table, pack it, and then press on:
---snip snip
      local oExcel, oRange,cText, q,r,i,nRow,d
      d = new database()
      d.databasename = "CERTLOCAL"
      d.active = true
      store 0 to oExcel,oRange,q,r,i,nRow
      q := new query()
      q.sql = "select * from temp"
      q.active = true
>> do some stuff with Excel here <<
>> finished so let's dump all the records from temp.dbf and clean it up<<

>> this line works      delete from temp.dbf //mark all records for removal
      d.active = false
      d.close()
>> this doesn't      d.packtable("TEMP")
      return

I've tried _app.databases[1].packtable("TEMP") and get a in use by another
error.  With the current line d.packtable("TEMP") the app doesn't stop, but
the table doesn't get packed either.  The BDE alias is set up correctly.
Any ideas??

BTW, this (temp.dbf) is a local table.  I'm trying some OODML stuff instead
of Set Directory etc.

John

--
Staub & Associates, Inc.
(850) 913-8488
http://www.staubassociates.com
Buy your books, etc. online at
http://www.staubassociates.com/bkstore.htm