Paradox QBE Problem - Files and ObjectPal

[LWB]

I just received a new computer at work (Dell 2 GHz Pentium 4) replacing a 800 MHz Dell Pentium II (?). The computer folks installed all the same software except for it is now running the latest version of MS Office (XP?) instead of Office 2000. They installed my unique software same as the previous computer (Paradox 9, PageMaker, Corel Draw). The operating system is still Windows 2000 and the server is also Windows 2000. All my personal files were copied to the new computer. Paradox is a standalone version on my computer only (same as before).

My Paradox applications come up, but no queries work - either those in ObjectPal or those saved as queries. For forms with queries inbedded in ObjectPal I get the error:
An error was triggered in the 'executeQBE' method on an object of Query Type.
Invalid Filename
Table: ProjectBudget.DB

The file ProjectBudget.DB is there and looks okay. All the files are in the same directory (designated as the Working Directory) and exist in the same location as on the previous computer. The tables, forms, and reports all look fine. The code for the query looks fine (it was a paste from a file). However trying to open any previously saved query generates a "Invalid Filename". Every query file produces this error.

I have tried reinstalling Paradox and recopying all my database files. The computer guys will get the latest service pack for Paradox 9, but I read the list of fixes in the service packs and I find no mention of this problem. So I don't know if this will solve my problem.

Can anyone help?

Lynn

 

[Langley]

The first thing to check is your alias manager to make sure your public aliases are intact. Unless you saved a copy of your idapi.cfg file and installed it after Paradox, then your aliases are gone and will need to be recreated. Project aliases declared in code should be okay. Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[footpad]

Lynn,

Mac's got the most likely culprit, the aliases that were defined in your IDAPI/BDE(32).CFG file.

Alternatively, you might be missing a PDOXWORK.CFG file (which contains saved project aliases).

Now, if it turns out that you're alises are properly defined, then it's possible that you have a couple of different problems. When the error message appears, is the >> button enabled? If so, click it, for that indicates there's more information about the error and this is usually tells you the real problem.

Also, keep in mind that the only way to obtain Paradox 9 SP4 is to order a replacement set of CD's from Corel (though I'm not sure they still provide them at this point in time). SP4 was never released as a separate service pack.

Details for obtaining SP4 are at

http://www.corel.com/support/ftpsite/pub/wordperfect/wpwin/office2000/index.htm

Hope this helps...

-- Lance

 

[LWB]

I retrieved the old idapi.cfg file and put it in the BDE directory (using BDE 5.0.1). This did not change anything.

I did not find any PDOXWORK.CFG file on either the old or the new computer.

I don't remember defining any aliases in the application I'm running.

The computer guys have installed a service pack and Paradox 9 now says it is version 9.00.738

In the application I have a main form that when I click on a button it produces an updated LatestBudget table using several queries in ObjectPal before opening a form. These queries were developed and saved in the interactive mode and then pasted into ObjectPal.

When I click on the button, I get the error message:
An error was triggered in the 'executeQBE' method on an object of Query Type.

The >> is enabled and when I click on it I get:
Invalid Filename
Table: ProjectBudget.DB

The table appears to be fine and it does open correctly for viewing and editing in other windows.

This happens for both queries. Both of these queries use two tables and the ProjectBudget.DB file is the first one in both queries and the name given as the "invalid filename".

If I try to open the original saved interactive query I get the error message "Invalid Filename". This happens for every saved query I have (I tried all 21 of them). I get the same Message for Open, Run or Design. And it seems that every piece of ObjectPal that runs a query generates this same error (I need to test this further to verify). I have not tried interactively recreating these queries yet (they are fairly complex).

The working directory is set to the location where all the files are located. All the application files are in the same directory.

Lynn

 

[LWB]

I just tried creating a simple interactive query. I just used one table and I tried it with several different tables. It allows me to create the query, but when I try to run the query I get the same "invalid filename" error.

Any ideas?

Lynn

 

[Langley]

Tough one, but if experience proves right then XP is probably the problem. Make sure you have Full Access rights to the workstation.

Secondly (but not likely), it might be that you created your application in the WORK directory (which is a standard Alias) and that WORK directory is now changed. Try going to "File->Working Directory" in Paradox and set the working directory to where your tables are located.
Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[LWB]

Mac,

Thanks for your attempts to help. I'm running Windows 2000 not XP (same as the previous computer) but I will have our computer guys check on the rights issue. Is there anything in particular to check?

When I tried a reinstall of Paradox 9, I did it myself from my account. The service pack was installed from the administrator account.

The application directory is located in the identical spot as the previous computer:
C:\My Documents\Paradox\Kevin's Database\

This is what I set the working directory to. It all appears to work except for queries.

Not being able to run an interactive query does make it seem likely that there is something strange in the settings or permissions.

Lynn

 

[LWB]

Update: (still no success)

I have local administrator priviledges on my computer. Also had the computer guys try to run Paradox 9 from the system administrator account - same errors.

One difference (besides the version of MS Office) with the previous computer is that the previous computer had Paradox 7 installed on it before Paradox 9 was installed.

Lacking anything else to try, I'm going to delete Paradox 9, install Paradox 7 and then install Paradox 9 over it. I can't imagine it would make a difference, but I'm running out of ideas!

Lynn

 

[LWB]

UPDATE: Success!!!!! (but why?)

I have solved the problem, but the problem should have existed on the old computer, so I have no idea why this made a difference.

As I said before, the working directory was:
C:\My Documents\Paradox\Kevin's Database\

I know Paradox can have problems with long path lengths and I also wondered about the strange directory name of "Kevin's Database" - but it hadn't caused any problems on the previous computer. Anyway I renamed it to KevinData and after resetting the working directory queries now work (saved, interactive and in ObjectPal).

Now can anyone explain why only queries had trouble with this directory name?

By the way - Paradox 7 gave exactly the same error message (after running the Windows Compatibility Software to fix the missing button problem with Windows 2000 & Paradox 7).

Thanks for everyone's help.

Lynn

 

[Langley]

Lynn, believe it or not local admin rights may not be sufficient. Make sure that you have Full Access rights to your directory, the Corel (and up) directories, and anything else (including where your netfile is located) you can think of. One quick test is to have your Administrator log in and try to run the interactive query for you. If it works, then you know for certain it's a permissions issue. Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[Langley]

Glad you got it resolved! I do know that ObjectPAL interprets ' as an object seperator (just like a period). It may have been seeing the path as:

C:\My Documents\Paradox\Kevin.s Database

No clue as to why it worked before.

Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us