Query sage table with no result

SUGGESTED

Hello,

We have an internal app to read the Sage tables to display invoice and order related data. There are times that the query returns empty result. but after a while, it works fine. I wonder if it is normal Sage behavior? Is it because a Sage user is writing to the table so it locked?  If this is the case, how do we know the empty result is because of the table is locked?