Server Connection Status

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

Sounds like you have something fancy planned! :slight_smile:

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 :rofl: