I have two different databases (named source and target)

How do I detirmine if the seq_no table is open in source already?

I usually use:

if select("seq_no") > 0 then
    select seq_no
else
    select 0
    use seq_no
endif

Now I need a solution that will look at which database the table is open in.

TIA!

ps, I am sure that Erik will be talking about this in a hour or two, but just in case someone wants to beat him to it }:-)