>>>>>Help!
>>>>>
>>>>>I have a report generated from a genxtab result. When I ran from foxpro 2.6 integrated environment, it was working fine. However When I distributed it using the distribution kit (make exe), the executable couldn't run the report properly. If I ran the executable file in the integrated environment, it worked fine.
>>>>>
>>>>>I cannot figure out what is wrong. It seems to be some setup that needs to be done. Anyone can help?
>>>>>
>>>>>I patched my genxtab using the file downloaded from MS.
>>>>>I
>>>>
>>>>You don't necessary need to include the program in your project. In this case, you should have a copy of the compiled program (FXP file) that's pointed to by the _GENXTAB system variable. You can initialize this in your CONFIG.FPW file with:
>>>>
>>>>_GENXTAB = C:\FOXPROW\GENXTAB.FXP
>>>>
>>>>Naturally, the directory should reflect the actual current location of the file.
>>>>
>>>>When you wish to execute the program, use:
>>>>
>>>>DO (_GENXTAB) WITH 'QUERY'
>>>>
>>>>HTH,
>>>>
>>>>George
>>>
>>>The code in my program.
>>>
>>>SELECT FISH_CODE, SIZE_NO, SIZE_DESC ;
>>> FROM FISHSIZE ;
>>> ORDER BY FISH_CODE, SIZE_NO ;
>>> GROUP BY FISH_CODE, SIZE_NO ;
>>> INTO CURSOR SYS(2015)
>>>DO (_GENXTAB) WITH "QUERY1"
>>>
>>>My config.fpw.
>>>
>>>KEYCOMP = WINDOWS
>>>MVCOUNT = 512
>>>CATMAN=OFF
>>>_GENXTAB=C:\FPW26\GENXTAB.FXP
>>
>
>>Are you sure that your query (in production) is returning records? I'd add IF _TALLY > 0...ENDIF around the call to the crosstab generator. You might also take a look at the actual program code in GENXTAB.PRG. You'll find a description of the allowable parameter list. The program will create the same type of output as input. In other word, if a cursor is the input, a cursor will be the output.
>>
>>George
>>>
>>>As I said, it worked fine when I ran my problem within Foxpro environment but once I ran executable from windows, it wouldn't work (for example, use Start-run or create a program item in win3.11). Normally, I would see the thermometer followed by the report. But no thermometer or report comes out and when I get out of the form, it comes out with 'LOCATE QUERY1.DBF'.
>>>
>>>Anyone knows what is the problem? I am stuck...... help!!!
>
>Thanks for all the help. I solve the problem although I still don't understand the reason. I change the DO (_GENXTAB) ... to Do genxtab.prg ... and it works. Obviously, when I run at command line, the executable file doesn't know what is _GENXTAB.
>
>Do you know how I can get the executable file to know that?

If you've compiled GENXTAB into your project that would explain why it works now.

The problem might be that in production the CONFIG.FPW file being used is not the same as the one you're using or the file is in a different location. In FPW 2.6, determining what the CONFIG.FPW is can be accomplished by adding the "About FoxPro..." bar to a menu. I've found this helpful to answer this question and others. You could also add something like:

IF EMPTY(_GENXTAB)
_GENXTAB = GETFILE('FXP', "Where is genxtab?")
ENDIF

If you get the GETFILE() dialog, you'll know that something's amiss in the configuration.

George
ENDIF