How to debug/track a record pointer change event?

Hi,

I am using VFP9 and have a table called NOTES. I have 3 records in the
table. I position the record to record #2 (I verify this by doing a WAIT
ALLTRIM(:STR(RECNO()) WINDOW and then launch another form (properties set to
show within top-level form). I also launch a ADOBE PDF document using the
SHELLEXCUTE command. When I bring the focus back to the top-level VFP form,
the record pointer for NOTES has changed to EOF(). There is nowhere in my
code on that form that moves the record pointer (including any subroutine
calls). I have tried to track this in vain but just cannot figure out why
VFP moves the record pointer? The Data Environment properties of this top
level form are set to .F. for auto open and auto close tables.

Is there anway to debug a record pointer move so I can trap the event and
figure out where and why VFP is randomly moving the record pointer?

Thanks

Zoom

Dan
Fri May 09 18:55:19 CDT 2008

Set a breakpoint on Recno("alias"), and set it to to break when condition
changes.

The usual culprit in this sort of thing is record movement with the wrong
alias SELECTed. Grids can also be fiddly, causing their datasource to become
selected.

Dan

Zoom wrote:
> Hi,
>
> I am using VFP9 and have a table called NOTES. I have 3 records in
> the table. I position the record to record #2 (I verify this by
> doing a WAIT ALLTRIM(:STR(RECNO()) WINDOW and then launch another
> form (properties set to show within top-level form). I also launch a
> ADOBE PDF document using the SHELLEXCUTE command. When I bring the
> focus back to the top-level VFP form, the record pointer for NOTES
> has changed to EOF(). There is nowhere in my code on that form that
> moves the record pointer (including any subroutine calls). I have
> tried to track this in vain but just cannot figure out why VFP moves
> the record pointer? The Data Environment properties of this top
> level form are set to .F. for auto open and auto close tables.
> Is there anway to debug a record pointer move so I can trap the event
> and figure out where and why VFP is randomly moving the record
> pointer?
> Thanks
>
> Zoom

Zoom
Fri May 09 22:06:51 CDT 2008

Hi Dan,

Thanks for the reply. However, I am new at this .. how and where do I set
this breakpoint?

Zoom


"Dan Freeman" <spam@microsoft.com> wrote in message
news:e$vanAjsIHA.1220@TK2MSFTNGP04.phx.gbl...
> Set a breakpoint on Recno("alias"), and set it to to break when condition
> changes.
>
> The usual culprit in this sort of thing is record movement with the wrong
> alias SELECTed. Grids can also be fiddly, causing their datasource to
> become selected.
>
> Dan
>
> Zoom wrote:
>> Hi,
>>
>> I am using VFP9 and have a table called NOTES. I have 3 records in
>> the table. I position the record to record #2 (I verify this by
>> doing a WAIT ALLTRIM(:STR(RECNO()) WINDOW and then launch another
>> form (properties set to show within top-level form). I also launch a
>> ADOBE PDF document using the SHELLEXCUTE command. When I bring the
>> focus back to the top-level VFP form, the record pointer for NOTES
>> has changed to EOF(). There is nowhere in my code on that form that
>> moves the record pointer (including any subroutine calls). I have
>> tried to track this in vain but just cannot figure out why VFP moves
>> the record pointer? The Data Environment properties of this top
>> level form are set to .F. for auto open and auto close tables.
>> Is there anway to debug a record pointer move so I can trap the event
>> and figure out where and why VFP is randomly moving the record
>> pointer?
>> Thanks
>>
>> Zoom
>
>

Guillermo
Sat May 10 11:57:06 CDT 2008

On May 9, 10:06=A0pm, "Zoom" <keash...@hotmail.com> wrote:
> Hi Dan,
>
> Thanks for the reply. =A0However, I am new at this .. how and where do I s=
et
> this breakpoint?
>
> Zoom
>
> "Dan Freeman" <s...@microsoft.com> wrote in message
>
> news:e$vanAjsIHA.1220@TK2MSFTNGP04.phx.gbl...
>
>
>
> > Set a breakpoint on Recno("alias"), and set it to to break when conditio=
n
> > changes.
>
> > The usual culprit in this sort of thing is record movement with the wron=
g
> > alias SELECTed. Grids can also be fiddly, causing their datasource to
> > become selected.
>
> > Dan
>
> > Zoom wrote:
> >> Hi,
>
> >> I am using VFP9 and have a table called NOTES. =A0 I have 3 records in
> >> the table. =A0I position the record to record #2 (I verify this by
> >> doing a WAIT ALLTRIM(:STR(RECNO()) WINDOW and then launch another
> >> form (properties set to show within top-level form). =A0I also launch a=

> >> ADOBE PDF document using the SHELLEXCUTE command. =A0When I bring the
> >> focus back to the top-level VFP form, the record pointer for NOTES
> >> has changed to EOF(). =A0 There is nowhere in my code on that form that=

> >> moves the record pointer (including any subroutine calls). =A0I have
> >> tried to track this in vain but just cannot figure out why VFP moves
> >> the record pointer? =A0 The Data Environment properties of this top
> >> level form are set to .F. for auto open and auto close tables.
> >> Is there anway to debug a record pointer move so I can trap the event
> >> and figure out where and why VFP is randomly moving the record
> >> pointer?
> >> Thanks
>
> >> Zoom- Hide quoted text -
>
> - Show quoted text -

Just right click the code where you want to start debugging and select
toggle breapoint. Run, and debug window should show. Commands like
"SET FILTER TO" also move the record pointer in a "silent" way.

Long live FoxPro

Dan
Sat May 10 16:18:34 CDT 2008

In the IDE, press CTRL-B to open the breakpoints dialog.

Or go to the debugger (choose Tools->debug from the menu or type DEBUG in
the command window) and choose it from the menu or the toolbar.

(always at least three ways to do something in VFP <g>)

The debugger is INCREDIBLY useful. It's worth taking a day off to explore
and find out what it can do. The help topic is actually helpful, too. ;-)

Dan

Zoom wrote:
> Hi Dan,
>
> Thanks for the reply. However, I am new at this .. how and where do
> I set this breakpoint?
>
> Zoom
>
>
> "Dan Freeman" <spam@microsoft.com> wrote in message
> news:e$vanAjsIHA.1220@TK2MSFTNGP04.phx.gbl...
>> Set a breakpoint on Recno("alias"), and set it to to break when
>> condition changes.
>>
>> The usual culprit in this sort of thing is record movement with the
>> wrong alias SELECTed. Grids can also be fiddly, causing their
>> datasource to become selected.
>>
>> Dan
>>
>> Zoom wrote:
>>> Hi,
>>>
>>> I am using VFP9 and have a table called NOTES. I have 3 records in
>>> the table. I position the record to record #2 (I verify this by
>>> doing a WAIT ALLTRIM(:STR(RECNO()) WINDOW and then launch another
>>> form (properties set to show within top-level form). I also launch
>>> a ADOBE PDF document using the SHELLEXCUTE command. When I bring
>>> the focus back to the top-level VFP form, the record pointer for
>>> NOTES has changed to EOF(). There is nowhere in my code on that
>>> form that moves the record pointer (including any subroutine
>>> calls). I have tried to track this in vain but just cannot figure
>>> out why VFP moves the record pointer? The Data Environment
>>> properties of this top level form are set to .F. for auto open and
>>> auto close tables. Is there anway to debug a record pointer move so I
>>> can trap the
>>> event and figure out where and why VFP is randomly moving the record
>>> pointer?
>>> Thanks
>>>
>>> Zoom

Fred
Sat May 10 23:46:28 CDT 2008


"Guillermo" <gwohler@gmail.com> wrote in message
news:7483e6b7-051a-461f-a4b4-c5390a13d265@q1g2000prf.googlegroups.com...

>Commands like
"SET FILTER TO" also move the record pointer in a "silent" way.

Not entirely true. SET FILTER does not move the record pointer at all. As
a matter of fact the filter doesn't even kick in until you move the record
pointer in the first place (or GO TOP, SKIP or some other command, that
would normally move the pointer).

>Long live FoxPro

A bit late for that I'm afraid.


--
Fred
Microsoft Visual FoxPro MVP

Zoom
Sun May 11 22:26:09 CDT 2008

Hi Dan,

Thanks for the reply. Howvver, even with the debugger, I just cannot figure
out where the record change occurs. I cannot find a single line of code
which moves the record pointer and yet VFP keeps moving it to EOF. Is
there any way to trap a record pointer move event anywhere it happens so I
can see where it happens rather than set a breakpoint at a specific line in
my code?

Thanks

Zoom

"Dan Freeman" <spam@microsoft.com> wrote in message
news:%23hl9nNusIHA.3604@TK2MSFTNGP03.phx.gbl...
> In the IDE, press CTRL-B to open the breakpoints dialog.
>
> Or go to the debugger (choose Tools->debug from the menu or type DEBUG in
> the command window) and choose it from the menu or the toolbar.
>
> (always at least three ways to do something in VFP <g>)
>
> The debugger is INCREDIBLY useful. It's worth taking a day off to explore
> and find out what it can do. The help topic is actually helpful, too. ;-)
>
> Dan
>
> Zoom wrote:
>> Hi Dan,
>>
>> Thanks for the reply. However, I am new at this .. how and where do
>> I set this breakpoint?
>>
>> Zoom
>>
>>
>> "Dan Freeman" <spam@microsoft.com> wrote in message
>> news:e$vanAjsIHA.1220@TK2MSFTNGP04.phx.gbl...
>>> Set a breakpoint on Recno("alias"), and set it to to break when
>>> condition changes.
>>>
>>> The usual culprit in this sort of thing is record movement with the
>>> wrong alias SELECTed. Grids can also be fiddly, causing their
>>> datasource to become selected.
>>>
>>> Dan
>>>
>>> Zoom wrote:
>>>> Hi,
>>>>
>>>> I am using VFP9 and have a table called NOTES. I have 3 records in
>>>> the table. I position the record to record #2 (I verify this by
>>>> doing a WAIT ALLTRIM(:STR(RECNO()) WINDOW and then launch another
>>>> form (properties set to show within top-level form). I also launch
>>>> a ADOBE PDF document using the SHELLEXCUTE command. When I bring
>>>> the focus back to the top-level VFP form, the record pointer for
>>>> NOTES has changed to EOF(). There is nowhere in my code on that
>>>> form that moves the record pointer (including any subroutine
>>>> calls). I have tried to track this in vain but just cannot figure
>>>> out why VFP moves the record pointer? The Data Environment
>>>> properties of this top level form are set to .F. for auto open and
>>>> auto close tables. Is there anway to debug a record pointer move so I
>>>> can trap the
>>>> event and figure out where and why VFP is randomly moving the record
>>>> pointer?
>>>> Thanks
>>>>
>>>> Zoom
>
>

Fred
Mon May 12 07:26:26 CDT 2008

In the Watch Window in the debugger, put:

RECNO("yourtable")

and set the breakpoint in the watch window by double clicking in the left
hand margin.

--
Fred
Microsoft Visual FoxPro MVP


"Zoom" <zoom@zoom.com> wrote in message
news:4ImdnWm199NMJbrVnZ2dnUVZ_oDinZ2d@comcast.com...
> Hi Dan,
>
> Thanks for the reply. Howvver, even with the debugger, I just cannot
> figure out where the record change occurs. I cannot find a single line
> of code which moves the record pointer and yet VFP keeps moving it to EOF.
> Is there any way to trap a record pointer move event anywhere it happens
> so I can see where it happens rather than set a breakpoint at a specific
> line in my code?
>
> Thanks
>
> Zoom
>
> "Dan Freeman" <spam@microsoft.com> wrote in message
> news:%23hl9nNusIHA.3604@TK2MSFTNGP03.phx.gbl...
>> In the IDE, press CTRL-B to open the breakpoints dialog.
>>
>> Or go to the debugger (choose Tools->debug from the menu or type DEBUG in
>> the command window) and choose it from the menu or the toolbar.
>>
>> (always at least three ways to do something in VFP <g>)
>>
>> The debugger is INCREDIBLY useful. It's worth taking a day off to explore
>> and find out what it can do. The help topic is actually helpful, too. ;-)
>>
>> Dan
>>
>> Zoom wrote:
>>> Hi Dan,
>>>
>>> Thanks for the reply. However, I am new at this .. how and where do
>>> I set this breakpoint?
>>>
>>> Zoom
>>>
>>>
>>> "Dan Freeman" <spam@microsoft.com> wrote in message
>>> news:e$vanAjsIHA.1220@TK2MSFTNGP04.phx.gbl...
>>>> Set a breakpoint on Recno("alias"), and set it to to break when
>>>> condition changes.
>>>>
>>>> The usual culprit in this sort of thing is record movement with the
>>>> wrong alias SELECTed. Grids can also be fiddly, causing their
>>>> datasource to become selected.
>>>>
>>>> Dan
>>>>
>>>> Zoom wrote:
>>>>> Hi,
>>>>>
>>>>> I am using VFP9 and have a table called NOTES. I have 3 records in
>>>>> the table. I position the record to record #2 (I verify this by
>>>>> doing a WAIT ALLTRIM(:STR(RECNO()) WINDOW and then launch another
>>>>> form (properties set to show within top-level form). I also launch
>>>>> a ADOBE PDF document using the SHELLEXCUTE command. When I bring
>>>>> the focus back to the top-level VFP form, the record pointer for
>>>>> NOTES has changed to EOF(). There is nowhere in my code on that
>>>>> form that moves the record pointer (including any subroutine
>>>>> calls). I have tried to track this in vain but just cannot figure
>>>>> out why VFP moves the record pointer? The Data Environment
>>>>> properties of this top level form are set to .F. for auto open and
>>>>> auto close tables. Is there anway to debug a record pointer move so I
>>>>> can trap the
>>>>> event and figure out where and why VFP is randomly moving the record
>>>>> pointer?
>>>>> Thanks
>>>>>
>>>>> Zoom
>>
>>
>
>

Anders
Mon May 12 07:49:49 CDT 2008

STEP through the relevant and watch the RECN() bin the Watch window tgill
you can pin it down.
Put DEBUGOUT PROGRAM(), RECNO(), ALIAS() at various points in your code.
It's automatically ignore in an EXE.
Are you using a SET RELATION into this table? Then any movement in the
master table will cause a move in this table.

-Anders


"Zoom" <zoom@zoom.com> wrote in message
news:4ImdnWm199NMJbrVnZ2dnUVZ_oDinZ2d@comcast.com...
> Hi Dan,
> > Thanks for the reply. Howvver, even with the debugger, I just cannot
> > figure
> out where the record change occurs. I cannot find a single line of code
> which moves the record pointer and yet VFP keeps moving it to EOF. Is
> there any way to trap a record pointer move event anywhere it happens so I
> can see where it happens rather than set a breakpoint at a specific line
> in my code?
>
> Thanks
>
> Zoom
>
> "Dan Freeman" <spam@microsoft.com> wrote in message
> news:%23hl9nNusIHA.3604@TK2MSFTNGP03.phx.gbl...
>> In the IDE, press CTRL-B to open the breakpoints dialog.
>>
>> Or go to the debugger (choose Tools->debug from the menu or type DEBUG in
>> the command window) and choose it from the menu or the toolbar.
>>
>> (always at least three ways to do something in VFP <g>)
>>
>> The debugger is INCREDIBLY useful. It's worth taking a day off to explore
>> and find out what it can do. The help topic is actually helpful, too. ;-)
>>
>> Dan
>>
>> Zoom wrote:
>>> Hi Dan,
>>>
>>> Thanks for the reply. However, I am new at this .. how and where do
>>> I set this breakpoint?
>>>
>>> Zoom
>>>
>>>
>>> "Dan Freeman" <spam@microsoft.com> wrote in message
>>> news:e$vanAjsIHA.1220@TK2MSFTNGP04.phx.gbl...
>>>> Set a breakpoint on Recno("alias"), and set it to to break when
>>>> condition changes.
>>>>
>>>> The usual culprit in this sort of thing is record movement with the
>>>> wrong alias SELECTed. Grids can also be fiddly, causing their
>>>> datasource to become selected.
>>>>
>>>> Dan
>>>>
>>>> Zoom wrote:
>>>>> Hi,
>>>>>
>>>>> I am using VFP9 and have a table called NOTES. I have 3 records in
>>>>> the table. I position the record to record #2 (I verify this by
>>>>> doing a WAIT ALLTRIM(:STR(RECNO()) WINDOW and then launch another
>>>>> form (properties set to show within top-level form). I also launch
>>>>> a ADOBE PDF document using the SHELLEXCUTE command. When I bring
>>>>> the focus back to the top-level VFP form, the record pointer for
>>>>> NOTES has changed to EOF(). There is nowhere in my code on that
>>>>> form that moves the record pointer (including any subroutine
>>>>> calls). I have tried to track this in vain but just cannot figure
>>>>> out why VFP moves the record pointer? The Data Environment
>>>>> properties of this top level form are set to .F. for auto open and
>>>>> auto close tables. Is there anway to debug a record pointer move so I
>>>>> can trap the
>>>>> event and figure out where and why VFP is randomly moving the record
>>>>> pointer?
>>>>> Thanks
>>>>>
>>>>> Zoom
>>
>>
>
>

Dan
Mon May 12 10:41:21 CDT 2008

I said set a breakpoint on recno(), not on a line of code.

Dan

Zoom wrote:
> Hi Dan,
>
> Thanks for the reply. Howvver, even with the debugger, I just cannot
> figure out where the record change occurs. I cannot find a single
> line of code which moves the record pointer and yet VFP keeps moving
> it to EOF. Is there any way to trap a record pointer move event
> anywhere it happens so I can see where it happens rather than set a
> breakpoint at a specific line in my code?
>
> Thanks
>
> Zoom
>
> "Dan Freeman" <spam@microsoft.com> wrote in message
> news:%23hl9nNusIHA.3604@TK2MSFTNGP03.phx.gbl...
>> In the IDE, press CTRL-B to open the breakpoints dialog.
>>
>> Or go to the debugger (choose Tools->debug from the menu or type
>> DEBUG in the command window) and choose it from the menu or the
>> toolbar. (always at least three ways to do something in VFP <g>)
>>
>> The debugger is INCREDIBLY useful. It's worth taking a day off to
>> explore and find out what it can do. The help topic is actually
>> helpful, too. ;-) Dan
>>
>> Zoom wrote:
>>> Hi Dan,
>>>
>>> Thanks for the reply. However, I am new at this .. how and where do
>>> I set this breakpoint?
>>>
>>> Zoom
>>>
>>>
>>> "Dan Freeman" <spam@microsoft.com> wrote in message
>>> news:e$vanAjsIHA.1220@TK2MSFTNGP04.phx.gbl...
>>>> Set a breakpoint on Recno("alias"), and set it to to break when
>>>> condition changes.
>>>>
>>>> The usual culprit in this sort of thing is record movement with the
>>>> wrong alias SELECTed. Grids can also be fiddly, causing their
>>>> datasource to become selected.
>>>>
>>>> Dan
>>>>
>>>> Zoom wrote:
>>>>> Hi,
>>>>>
>>>>> I am using VFP9 and have a table called NOTES. I have 3 records
>>>>> in the table. I position the record to record #2 (I verify this
>>>>> by doing a WAIT ALLTRIM(:STR(RECNO()) WINDOW and then launch
>>>>> another form (properties set to show within top-level form). I
>>>>> also launch a ADOBE PDF document using the SHELLEXCUTE command. When I
>>>>> bring the focus back to the top-level VFP form, the record
>>>>> pointer for NOTES has changed to EOF(). There is nowhere in my
>>>>> code on that form that moves the record pointer (including any
>>>>> subroutine calls). I have tried to track this in vain but just cannot
>>>>> figure
>>>>> out why VFP moves the record pointer? The Data Environment
>>>>> properties of this top level form are set to .F. for auto open and
>>>>> auto close tables. Is there anway to debug a record pointer move
>>>>> so I can trap the
>>>>> event and figure out where and why VFP is randomly moving the
>>>>> record pointer?
>>>>> Thanks
>>>>>
>>>>> Zoom

Paul
Mon May 12 13:20:05 CDT 2008


"Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message

>>Long live FoxPro
>
> A bit late for that I'm afraid.

Sigh.

MikeA
Mon May 12 23:49:39 CDT 2008

Zoom - any chance you have tied your table to the grid's controlsource?
That could change the record pointer. Also, if you are not using private
data sessions, that could also change the record pointer. Feel free to post
some code here and we'll attack it.

Mike

"Dan Freeman" <spam@microsoft.com> wrote in message
news:u8JFjaEtIHA.2292@TK2MSFTNGP03.phx.gbl...
>I said set a breakpoint on recno(), not on a line of code.
>
> Dan
>
> Zoom wrote:
>> Hi Dan,
>>
>> Thanks for the reply. Howvver, even with the debugger, I just cannot
>> figure out where the record change occurs. I cannot find a single
>> line of code which moves the record pointer and yet VFP keeps moving
>> it to EOF. Is there any way to trap a record pointer move event
>> anywhere it happens so I can see where it happens rather than set a
>> breakpoint at a specific line in my code?
>>
>> Thanks
>>
>> Zoom
>>
>> "Dan Freeman" <spam@microsoft.com> wrote in message
>> news:%23hl9nNusIHA.3604@TK2MSFTNGP03.phx.gbl...
>>> In the IDE, press CTRL-B to open the breakpoints dialog.
>>>
>>> Or go to the debugger (choose Tools->debug from the menu or type
>>> DEBUG in the command window) and choose it from the menu or the
>>> toolbar. (always at least three ways to do something in VFP <g>)
>>>
>>> The debugger is INCREDIBLY useful. It's worth taking a day off to
>>> explore and find out what it can do. The help topic is actually
>>> helpful, too. ;-) Dan
>>>
>>> Zoom wrote:
>>>> Hi Dan,
>>>>
>>>> Thanks for the reply. However, I am new at this .. how and where do
>>>> I set this breakpoint?
>>>>
>>>> Zoom
>>>>
>>>>
>>>> "Dan Freeman" <spam@microsoft.com> wrote in message
>>>> news:e$vanAjsIHA.1220@TK2MSFTNGP04.phx.gbl...
>>>>> Set a breakpoint on Recno("alias"), and set it to to break when
>>>>> condition changes.
>>>>>
>>>>> The usual culprit in this sort of thing is record movement with the
>>>>> wrong alias SELECTed. Grids can also be fiddly, causing their
>>>>> datasource to become selected.
>>>>>
>>>>> Dan
>>>>>
>>>>> Zoom wrote:
>>>>>> Hi,
>>>>>>
>>>>>> I am using VFP9 and have a table called NOTES. I have 3 records
>>>>>> in the table. I position the record to record #2 (I verify this
>>>>>> by doing a WAIT ALLTRIM(:STR(RECNO()) WINDOW and then launch
>>>>>> another form (properties set to show within top-level form). I
>>>>>> also launch a ADOBE PDF document using the SHELLEXCUTE command. When
>>>>>> I bring the focus back to the top-level VFP form, the record
>>>>>> pointer for NOTES has changed to EOF(). There is nowhere in my
>>>>>> code on that form that moves the record pointer (including any
>>>>>> subroutine calls). I have tried to track this in vain but just
>>>>>> cannot figure
>>>>>> out why VFP moves the record pointer? The Data Environment
>>>>>> properties of this top level form are set to .F. for auto open and
>>>>>> auto close tables. Is there anway to debug a record pointer move
>>>>>> so I can trap the
>>>>>> event and figure out where and why VFP is randomly moving the
>>>>>> record pointer?
>>>>>> Thanks
>>>>>>
>>>>>> Zoom
>
>

_SaM_
Wed May 14 07:47:45 CDT 2008

there is a way in which if all the previous response's didnot work with you
can use it,is boring but will do the job

in each method for each (form(s) and object(s) you write
WAIT WINDOW "Object.MethodName" + STR(RECNO())

HTH

Samir Ibrahim

"Zoom" <keashdoc@hotmail.com> wrote in message
news:ifWdnQ1gnaJdQbnVnZ2dnUVZ_qLinZ2d@comcast.com...
> Hi,
>
> I am using VFP9 and have a table called NOTES. I have 3 records in the
> table. I position the record to record #2 (I verify this by doing a WAIT
> ALLTRIM(:STR(RECNO()) WINDOW and then launch another form (properties set
> to show within top-level form). I also launch a ADOBE PDF document using
> the SHELLEXCUTE command. When I bring the focus back to the top-level VFP
> form, the record pointer for NOTES has changed to EOF(). There is
> nowhere in my code on that form that moves the record pointer (including
> any subroutine calls). I have tried to track this in vain but just cannot
> figure out why VFP moves the record pointer? The Data Environment
> properties of this top level form are set to .F. for auto open and auto
> close tables.
>
> Is there anway to debug a record pointer move so I can trap the event and
> figure out where and why VFP is randomly moving the record pointer?
>
> Thanks
>
> Zoom
>

swdev2
Wed May 14 13:18:29 CDT 2008

I'll take a stab at it and claim the record pointer is being moved during
that forms refresh, after the adobe thing is finished.
Now , as to WHY, mmmmm are you using any framework or classes for 'that'
form? maybe it's buried and you can't see it directly.

--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net

"Zoom" <keashdoc@hotmail.com> wrote in message
news:ifWdnQ1gnaJdQbnVnZ2dnUVZ_qLinZ2d@comcast.com...
> Hi,
>
> I am using VFP9 and have a table called NOTES. I have 3 records in the
> table. I position the record to record #2 (I verify this by doing a WAIT
> ALLTRIM(:STR(RECNO()) WINDOW and then launch another form (properties set
to
> show within top-level form). I also launch a ADOBE PDF document using the
> SHELLEXCUTE command. When I bring the focus back to the top-level VFP
form,
> the record pointer for NOTES has changed to EOF(). There is nowhere in
my
> code on that form that moves the record pointer (including any subroutine
> calls). I have tried to track this in vain but just cannot figure out why
> VFP moves the record pointer? The Data Environment properties of this
top
> level form are set to .F. for auto open and auto close tables.
>
> Is there anway to debug a record pointer move so I can trap the event and
> figure out where and why VFP is randomly moving the record pointer?
>
> Thanks
>
> Zoom
>
>

Zoom
Fri May 16 06:42:25 CDT 2008

There is nothing in the refresh event for the form and I am not using any
framework or classes for this form.

zoom


"swdev2" <wsanders@dotnetconversions.bob.com> wrote in message
news:uoLEhXetIHA.3968@TK2MSFTNGP04.phx.gbl...
> I'll take a stab at it and claim the record pointer is being moved during
> that forms refresh, after the adobe thing is finished.
> Now , as to WHY, mmmmm are you using any framework or classes for
> 'that'
> form? maybe it's buried and you can't see it directly.
>
> --
> ===================
> William Sanders / EFG VFP / mySql / MS-SQL
> www.efgroup.net/vfpwebhosting
> www.terrafox.net www.viasqlserver.net
>
> "Zoom" <keashdoc@hotmail.com> wrote in message
> news:ifWdnQ1gnaJdQbnVnZ2dnUVZ_qLinZ2d@comcast.com...
>> Hi,
>>
>> I am using VFP9 and have a table called NOTES. I have 3 records in the
>> table. I position the record to record #2 (I verify this by doing a WAIT
>> ALLTRIM(:STR(RECNO()) WINDOW and then launch another form (properties set
> to
>> show within top-level form). I also launch a ADOBE PDF document using
>> the
>> SHELLEXCUTE command. When I bring the focus back to the top-level VFP
> form,
>> the record pointer for NOTES has changed to EOF(). There is nowhere in
> my
>> code on that form that moves the record pointer (including any subroutine
>> calls). I have tried to track this in vain but just cannot figure out
>> why
>> VFP moves the record pointer? The Data Environment properties of this
> top
>> level form are set to .F. for auto open and auto close tables.
>>
>> Is there anway to debug a record pointer move so I can trap the event and
>> figure out where and why VFP is randomly moving the record pointer?
>>
>> Thanks
>>
>> Zoom
>>
>>
>
>