Hi Hilmar,

Back to my old thread..

Could you tell me how to use a MAX() in an SQL to select the Max number of a unique ID in a primary field, (which is programatically used to generate an incremental unique ID for a new record) by including records marked for deletion but not packed?

My problem is that the cursor ignores deleted records when doing a select, and when the ID is generated, the incremental value of the ID could already exist in the non packed table, which then generates a unique conflict error.

If I could have packed my table, I would have no such problems!

Thanks very much,

With best regards,

Steve.