Problem with AEX files

[Howard G. Cornett]

I am having a strange problem with an AEX file. Here is what happens. I right click on the white space of the code tab and compile all my scripts to an AEX. I accept the defaults in creating it. This creates an AEX file that is the same name as my database that will load automatically at startup. Then I delete all the scripts from the code tab.

Here is my problem. When I distribute my as an update (no .dbf, .cdx, or .fpt files) in an install file, when the database is run it causes an error on one of the scripts. If I go back and just restore the scripts to the code tab, all works fine. So it would seem that the AEX is fouled in some way. Any ideas what could be causing this and, more importantly, how to fix it?

Howard

[Steve Workings]

What's the error?

[Finian Lennon]

Howard, I seem to remember something like that happening when I first started uising AEX files. I'm not sure what it was, exactly. I sidestepped the issue of using the (then) database-named aex file and moved all the program code into a completely separate aex file. I left only menus and toolbars and some functions in the database library.

Funny, I just tried putting all the remaining stuff back into the database aex and the app won't open. It looks like one of the encryption functions won't work. I don't have time to dig into it now, unfortunately.

Finian

[Howard G. Cornett]

Error Message

The error message is:

Script:Est_onEnter line:218
invalid field handle

Line 218 looks like this:

choiceC = lookupn("C",PART_DETAIL->B203_PREP_SOURCE,"Camera_film_per_sq_area","prep record","Prep_Source")

There is no problem with this line if the script is on the code tab, but when there is only the AEX I get the error.

Howard

[Finian Lennon]

Interesting, mine fails on a lookupc () which checks the password entered in the user table.

Finian

[CALocklin]

How are you initializing the .aex file? Is it being put in (a) the Addins_installed folder or (b) the application folder and then loaded with Load_library() or (c) the "database properties/compiled libraries"?

I seem to recall similar problems in the past but I don't recall the details any more. I probably never truly understood the problem but only found a solution that worked through trial and error. If my memory is correct, I think the problem was when using Load_library() and it was mostly a problem the first time around. Reloading the app sometimes seemed to fix it?? I'm also thinking that an xbasic_wait_for_idle() might have been used.

If I find where I used this, I'll let you know what I did. ---> Never mind, it was in my Trak-It SP program where I no longer use the aex file. I had too much trouble loading an aex file where items in the aex file were called in the autoexec script. However, unlike what it sounds like Howard is describing, I haven't experienced any issues that I can recall when loading an aex file and using it somewhere other than the autoexec. There have also been no problems when the aex file is in the Addins_installed folder.

[Howard G. Cornett]

It's in the ADB path

The AEX file is in the ADB path and has the same name as the ADB. My understanding is that it should load automatically in this case. Am I wrong?

Howard

[CALocklin]

You are correct. As I said, it has been a long time since I experienced the issue and, now that you mention it, it's very possible that I had the issue with the aex named like the adb. I know that this was one of the things I tried - probably the first thing. I tried a number of methods to solve the problem - I just don't remember what all the problems or results were.