>>>>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?