I'm writing to apps that require XProcessing.

App1 receives the data, writes it to the DB, then sends a message to App2 that data is available.

App2 receives the message, reads the DB, and processes the data.

PROBLEM:

I want to set up some type of buffer, so that if App2 is busy processing, and a message is received, then the message will remain in the que until flagged, then the message will be deleted.

--------------------

One idea was when App1 writes to the DB, it sets a field (say NewRcd) associated with each record. Then when App2 receives any message, App2, upon reading the DB, will loop all DB rcds with the field set, then clear it after processing.

This looks like it will work.

Anyone, got any other, better ideas???

Thanks
David