With a procedure meant to be run only when a file is disconnected for a New Generation, is there a positive way to determine that the file is in that mode? “Offline” seems that it could be due to other reasons.
Yes, this is how you do it.
if dbinfo("PENDINGNEWGENERATION","")<>""
... run this code
... only if this
... database is disconnected
... for a New Generation
endif
Sounds like you have something fancy planned!
Just what I needed.
Nothing ‘fancy’ planned but we need to take a couple of files out of shared mode each month to archive then delete a few thousand records. It’s obviously helpful to determine that the db is in the right condition before making all the preparations before trying to delete a bunch of records.
That’s what I said - fancy