Table not found

[needInfo25]

When trying to run a query in Paradox, I get the message Table not found. The query is based on a table that is still valid and in the same location.

 

[TonyMcGuire]

" The query is based on a table that is still valid and in the same location."

One part of that statement is no longer true; or perhaps there is a subdirectory named the same as the table in question? or ...

Same location...

Is the table defined in the query by an alias? And does the alias point to the location where the table is?


If this isn't it, please open the query's .qbe file with a text editor and copy then paste the query here.

Tony McGuire

http://www.wjcitycouncil.com

"It's not about having enough time; we have the rest of our lives. It's about priorities.

 

[needInfo25]

Thanks for the info. After checking again it is true that the table is no longer valid. How do I make the change now without creating a new query?

 

[TonyMcGuire]

Well, you ask us for voodoo answers. How are we to know how to address the structure of your computer without knowing the structure of your computer?

Tony McGuire

http://www.wjcitycouncil.com

"It's not about having enough time; we have the rest of our lives. It's about priorities.

 

[TonyMcGuire]

On a guess...

You can edit the .qbe file with any text editor; notepad for instance.

Then you can change the table name(s), path or alias of the table(s) in the query.

Tony McGuire

http://www.wjcitycouncil.com

"It's not about having enough time; we have the rest of our lives. It's about priorities.

 

[needInfo25]

Here is the query: Table1 and Table2 exist in the same folder as this query. I'm assuming result.db has to exist as well, or does pdox use this to rename the answer.db?

Query
ANSWER: RIV:result.DB

Table1.DB | Disb Type | Status | Recnum | Date Updated |
| FA | Check P | _join1 | >1/1/2005 |

Table1.DB | Comment |
| Check "Billed on 11/".."/2006".. or "Billed on 12/".."/2006.." |

Table2.DB | Recnum1 | Recnum2 |
| _join1 | Check _join2 |

EndQuery

 

[TonyMcGuire]

result.db gets created *instead of* Answer.db; and creates it in your riv: directory.

Since there are no aliases defined as part of the table definition, you would have to make the directory where the query/tables reside your *working* directory before attempting to open/run this query.

I see no _join2 in the query you pasted; you can eliminate it, likely.

You also have the .. OUTSIDE the first part of the criteria quotes, but within the second. You may want to take a look and see whether you wish to adjust this.

Tony McGuire

http://www.wjcitycouncil.com

"It's not about having enough time; we have the rest of our lives. It's about priorities.

 

[needInfo25]

Thank you very much for your time and assistance. In the end the issue was that I did not have the proper working directory set.

Dare to solve my other issue?

I would like to know if its possible to link from SQL Server 2005 to Paradox 8, so that when I update records in SQL that this also reflects in Pdx.

 

[TonyMcGuire]

'proper working directory set'.

No, in truth you aren't using an alias in the query to describe the location of the tables within the query, such that it doesn't matter where the query is executed from. Set up and use an alias, and you won't have this problem in the future.



No idea on anything SQL related.

But if the info is in the SQL table, then Paradox can 'see' the new/changed data in the SQL table.

If you mean separate Paradox tables, you'd need to set up a copy of that data from within Paradox I'd think.

Tony McGuire

http://www.wjcitycouncil.com

"It's not about having enough time; we have the rest of our lives. It's about priorities.