REPORT FORM command known bug?

[torturedmind]

am using vfp6 on a win xp platform. my problem is whenever i issue the command...

report form phealth1 to file (tempfile) noconsole

...vfp6 ide hangs and windows says it's not responding anymore. is this a known bug? how can i get around this?

thanks in advanced. peace!

kilroy
philippines

"Once a king, always a king. But being a knight is more than enough."

 

[DSummZZZ]

Is it by chance trying to write to a folder it doesn't have permissions for? Or maybe a funky file name/path?


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[alvechurchdata]

Does the report work when you just print or preview it? If it fails there as well then there's probably an error in one of the field, group, or Report Variable expressions. Remove them one at a time until the problem goes away.


Geoff Franklin

http://www.alvechurchdata.co.uk

 

[torturedmind]

apologies for my late reply.

sir dave:
the variable tempfile is equivalent to sys(2023) + "\" + sys(3) + ".tmp". i don't know if this is the issue.

sir geoff:
the problem shows only when i use the to file... phrase. when i use preview or to printer phrases there is no problem at all.

thanks again for those who took time replying in this thread. i sure hope more will share something in the future. peace!

kilroy
philippines

"Once a king, always a king. But being a knight is more than enough."

 

[Mike Lewis]

Hi Kilroy,

I've just run your code in VFP 7 and VFP 9, and it works fine in both cases.

I don't have VFP 6, but I can't imagine it's a bug. After all, it's such a common thing do, and VFP 6 was the main version for over two years. I can't believe no-one noticed it.

My guess is there's something in your configuration or environment that's causing it. Can you try it on a different computer?

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[alvechurchdata]

I don't have VFP 6

I do<g>. and [TT]report form country to file (tempfile) noconsole[/tt] works perfectly so long as the variable tempfile holds a valid file name. If I try this:

tempfile="Really Bad File Name !£$%^&*"
report form country to file (tempfile) noconsole

then the IDE hangs with a blank screen and an hourglass.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[Stella740pl]

Well, I have VFP6, too, and Win XP, and I tried your code:

MyReport="C:\MyPath\Report\report1"  && Existing test report
tempfile="Really Bad File Name !£$%^&*"
report form (MyReport) to file (tempfile) noconsole

and also

tempfile="Really Bad File Name !£$%^&*"
report form C:\MyPath\Report\report1 to file (tempfile) noconsole

Both times, nothing hangs, no hourglass, error message is "Error loading printer driver" (and Cancel/Suspend/Ignore/Help buttons).

 

[alvechurchdata]

I'm running VFP 6 under Windows XP too and I'm now getting the same results as you. No crash - just the printer driver message.

But I must confess - I didn't actually use a file named "Really Bad File Name !£$%^&*" this morning. I remember I started testing with "fred", then I tried "fr ed". I've still got "fred.txt" and "fr ed.txt" on disk. And the next thing I tried failed. And I can't remember what that was.

After some head scratching and experimenting I've found that tempfile="..." will crash it.

The moral of this story. Always document your tests. Sorry to have mislead you all.



Geoff Franklin

http://www.alvechurchdata.co.uk