Search results for query: *

Ok. I think I'm nearly done with this problem. However years ago I named some of my fields with the symbol "#", like Code# and Account#. I have been having a problem when I translate the queries I have to SQL with the SQL editor. It says there is an error in line "XX" with a keyword and shows...

Well that solved the problem of the column separator but now all my queries using the Mfrs table point to the long file name path. Is there some way to make them use the Mfrs file I moved to the shorter path without having to rewrite them all?

I've opened the queries in the SQL editor The first two work without problems When I change it to sort by "Company" I have the problem SELECT DISTINCT D1."Stock Number", D1.Description, D1."Sort" FROM "Order Criteria.DB" D, "Order Archive.DB" D1 WHERE (D1."Account Code" = D."Account Code")...

I'm pretty sure the path is: C:\Program Files\Corel\Shared\Private unless there's another PRIV that is different than Private When I go to open the answer table in the PRIV alias this is the path I get. The sort name is either "sort, or "company". Either way they don't come close to 64 characters

I'm running Paradox 9 on Windows xp I'm a multi-line sales rep and I've developed a program to order all my lines and items through Paradox. I have a very detailed program at this point with many forms, reports , etc. In looking at the problem further I've discovered it only happens with...

I have no knowledge of SQL but I've been working with Paradox for 12 years. I always just use queries. I can never get a query to "sort" the data or change the structure of the data so it "sorts itself". Whenever I try, it works once and then I save the query and try to open it again and I get...