Data session issues - VFP9

Has anyone come across any quirks with VFP9 forms and reports with respect
to using private data sessions? Several of us are running into intermittent
issues. I've not yet been able to duplicate it 100%, but I'm working on
that.

Issue: You run a report from a program, and the find file dialog appears. No
apparent reason. Suspend program immediately before report form is run. Open
debugger, add set('datasession'). Edit report. Preview. Previews fine,
datasession stays at 1. Immediately preview again. Datasession changes, find
file dialog appears. Cancel. Preview again, previews fine. Preview again,
find file dialog appearrs and datasessions is changed. Every other time we
previewed the report, it would change datasession and error out, and every
other time it would preview fine.

Issue: Modify report. Ensure private data session is not selected. Save
report. Edit report. Private datasession is selected. Unselect it. Save
report. Edit report. Private datasession is selected.

Issue: Create form. Set to private datasession. Add tables to DE. Save.
Edit, set to default datasession. Save and run. Form opens in private
datasession, even though you set it to default.

We are seeing enough of these to establish a pattern, but not enough to
duplicate it 100%.

(and, no, I'm not the only one here that is seeing this :-P )

Dan
Fri Jun 24 10:57:33 CDT 2005

I'm not seeing anything like that. (Surprised? <g>) But when you're talking
about reporting in VFP9, remember to include your SET REPORTBEHAVIOR
setting. It makes a huge difference.

Dan

Ook wrote:
> Has anyone come across any quirks with VFP9 forms and reports with
> respect to using private data sessions? Several of us are running
> into intermittent issues. I've not yet been able to duplicate it
> 100%, but I'm working on that.
>
> Issue: You run a report from a program, and the find file dialog
> appears. No apparent reason. Suspend program immediately before
> report form is run. Open debugger, add set('datasession'). Edit
> report. Preview. Previews fine, datasession stays at 1. Immediately
> preview again. Datasession changes, find file dialog appears. Cancel.
> Preview again, previews fine. Preview again, find file dialog
> appearrs and datasessions is changed. Every other time we previewed
> the report, it would change datasession and error out, and every
> other time it would preview fine.
>
> Issue: Modify report. Ensure private data session is not selected.
> Save report. Edit report. Private datasession is selected. Unselect
> it. Save report. Edit report. Private datasession is selected.
>
> Issue: Create form. Set to private datasession. Add tables to DE.
> Save. Edit, set to default datasession. Save and run. Form opens in
> private datasession, even though you set it to default.
>
> We are seeing enough of these to establish a pattern, but not enough
> to duplicate it 100%.
>
> (and, no, I'm not the only one here that is seeing this :-P )

Ook
Fri Jun 24 11:27:29 CDT 2005

The form was a fluke I think. I removed the tables from the DE and it
stopped opening up in a private DE. The report issues is the main one, and
several of us are seeing this. I tried to duplicate it this morning and was
not sucessfull. The report causing problems is a very large complex report
with 13 detail bands and hundreds of fields. We have had other weird
problems with the report also, I suspect that the new reporting
functionality is still immature, and we are definitely pushing the envelope
with this report :)


"Dan Freeman" <spam@microsoft.com> wrote in message
news:%23vhRwVNeFHA.1660@TK2MSFTNGP10.phx.gbl...
> I'm not seeing anything like that. (Surprised? <g>) But when you're
> talking
> about reporting in VFP9, remember to include your SET REPORTBEHAVIOR
> setting. It makes a huge difference.
>
> Dan
>
> Ook wrote:
>> Has anyone come across any quirks with VFP9 forms and reports with
>> respect to using private data sessions? Several of us are running
>> into intermittent issues. I've not yet been able to duplicate it
>> 100%, but I'm working on that.
>>
>> Issue: You run a report from a program, and the find file dialog
>> appears. No apparent reason. Suspend program immediately before
>> report form is run. Open debugger, add set('datasession'). Edit
>> report. Preview. Previews fine, datasession stays at 1. Immediately
>> preview again. Datasession changes, find file dialog appears. Cancel.
>> Preview again, previews fine. Preview again, find file dialog
>> appearrs and datasessions is changed. Every other time we previewed
>> the report, it would change datasession and error out, and every
>> other time it would preview fine.
>>
>> Issue: Modify report. Ensure private data session is not selected.
>> Save report. Edit report. Private datasession is selected. Unselect
>> it. Save report. Edit report. Private datasession is selected.
>>
>> Issue: Create form. Set to private datasession. Add tables to DE.
>> Save. Edit, set to default datasession. Save and run. Form opens in
>> private datasession, even though you set it to default.
>>
>> We are seeing enough of these to establish a pattern, but not enough
>> to duplicate it 100%.
>>
>> (and, no, I'm not the only one here that is seeing this :-P )
>
>