The Magical Disappearing "Table"

[Paul Wagner]

Wow. I'm converting an old database which, through a query, references (what looks like) a table called "gross_charges", yet that "table" does not appear in the tables module, even with Hidden and system tables option turned on. I don't see any flat files by that name anywhere on my machine, nor do I see anything in Source for that table's alias.

Where IS this odd fellow?

 

[Paul Wagner]

Hi Pat:

I checked that too, and no it's not (at least it doesn't show up in the query module). Is there any way of searching the system for it by name?

Paul

 

[pbaldy]

An aliased table will look like another table in the QBE. What's the SQL of the query in question?

 

[Paul Wagner]

Yes Paul. That was it. I found the AS clause right after the FROM tblX. I tracked it backwards to another one also. Odd form for the original programmer to make right in the middle of the project.

Thank you for helping a stranger. Blessings.

Paul