error when running _reportoutput In foxpro 9.0

[kimsue]

Hello there,

I am attempting to convert my Visual Forpro 7.0 applications to Visual Foxpro 9.0 so I can take advantage of the new reporting features. Apparently, I don't have a good understanding of how these new functions work yet.

I am getting the following error:

At least one required index is missing from the configuration table.

OBJTYPE = OBJTYPE
FRXNODES = OBJTYPE+OBJCODE+IIF(OBJTYPE=1109.00,500.00,0)

Choose OK and I can then generate the HTML file and view the report. The error does not reoccur until I exit the application, re-enter and then try to run the report again.

The error is occuring on the 2nd line of code...

loListener = .NULL.
do (_reportoutput) with 5, loListener

loListener.TargetFileName = forcepath('Paymastv.html', '&cfi')

lOListener.QuietMode = .T.
wait window 'Outputting to HTML...' nowait
erase (loListener.TargetFileName)
object loListener
report form paymastv object loListener

* Display the results.

loShell = newobject('_shellexecute','_environ.vcx')
loShell.ShellExecute(loListener.TargetFileName)
wait clear
Thisform.Refresh()


I have tried many things to get rid of the error, but am not sure I am not on a wild goose chase, looking at the wrong things. The last thing I did was copy REPORTBUIILDER.APP, REPORTPREVIEW.APP and REPORTOOUTPUT.APP to my program folder. I have unzipped the source code for these apps and have also tried adding the source to my exe file. I have looked at and recreated the indexes of

_reportoutputconfig.dbf and tried copying this file to
another file adding this to my startup program....

EXTERNAL PROCEDURE frxbuilder.prg
* Set the system variable to use the local source version:
_REPORTBUILDER = "frxbuilder.prg"

do frxBuilder with 3, "&cfsysdrv.&cfi.swrptcnf.dbf"

Anybody have any ideas? I'm getting a little frustrated . Thanks.

 

[kimsue]

I had an extra line (above) that isn't in the code. This is the code and the error is on the 2nd line ...do (_report...

CODE....

loListener = .NULL.
do (_reportoutput) with 5, loListener

loListener.TargetFileName = forcepath('Paymastv.html', '&cfi')


lOListener.QuietMode = .T.
wait window 'Outputting to HTML...' nowait
erase (loListener.TargetFileName)
report form paymastv object loListener

* Display the results.

loShell = newobject('_shellexecute','_environ.vcx')
loShell.ShellExecute(loListener.TargetFileName)
wait clear
Thisform.Refresh()

The error is:

At least one required index is missing from the configuration table.

OBJTYPE = OBJTYPE
FRXNODES = OBJTYPE+OBJCODE+IIF(OBJTYPE=1109.00,500.00,0)


I am assuming the file causing the problem is _reportoutputconfig, but I can't seem to get rid of the error - still working on it. I have reindexed the file.

Thanks if you have any ideas.

 

[kimsue]

fyi... In case anyone else has this problem... This is caused by a Foxpro bug .....

Remove SET FIXED ON from code and the error disappears.


**~=================<CASE SUMMARY>==================~**
PROBLEM: Error "At least one required index tag is missing from the configuration table." running these lines in VFP9:
loLsnr = NULL
DO ( _REPORTOUTPUT ) WITH 5, loLsnr

RESOLUTION: Turns out this happens if SET( "FIXED" ) == ON. Customer determined cause (thanks Kim <g>), and Microsoft has bugged this for fixing in the next VFP9 update.
**~================<\CASE SUMMARY>==================~**