Sean wrote:

>
> Jeff,
>
> How about fill a temp table or list with the primary keys of the
> records you want to delete during the loop, close the query, and then
> perform the delete from the list. Shouldn't have to do it, but it may
> get you around the bug.
>
> Sean
>

Exactly my thought as I lay in my bed last night!

I'll give it a try this morning

Thanks Sean

Cheers

Jeff

--
Jeff Cook
Aspect Systems Ltd
www.aspect.co.nz
+
Joan and Jeff Cook
The Cooks Oasis
www.cookislandsoasis.com

Tim Young [Elevate Software] wrote:

> Jeff,
>
> << I'm getting an AV on closing a query.  Stepping through the code I
> get to the marked line below and get the AV >>
>
> If you can send me a project that reproduces this, I'll have a look
> and see if I can get you a source code fix.

Hi Tim

I'm working on a tight deadline for a release TODAY!!!!   So I'll try
Sean's suggestion and if it doesn't work I'll have to cancel the
release.

Either way I'll put together a demo project if possible and get it off
to you, but it will probably after the weekend now.

Cheers

Jeff

--
Jeff Cook
Aspect Systems Ltd
www.aspect.co.nz
+
Joan and Jeff Cook
The Cooks Oasis
www.cookislandsoasis.com

> Sean wrote:
>
> >
> > Jeff,
> >
> > How about fill a temp table or list with the primary keys of the
> > records you want to delete during the loop, close the query, and
> > then perform the delete from the list. Shouldn't have to do it, but
> > it may get you around the bug.

Kia Orana Sean

Great! That worked and thanks for helping me along the right path.  I
can get my release out now, do the monthly tax return, pay the bills
.... then see if I can get a sample project to Tim ...

Thanks again

Kia Manuia

Jeff

--
Jeff Cook
Aspect Systems Ltd
www.aspect.co.nz
+
Joan and Jeff Cook
The Cooks Oasis
www.cookislandsoasis.com

Glad to hear it.

Jeff Cook wrote:
>> Sean wrote:
>>
>>> Jeff,
>>>
>>> How about fill a temp table or list with the primary keys of the
>>> records you want to delete during the loop, close the query, and
>>> then perform the delete from the list. Shouldn't have to do it, but
>>> it may get you around the bug.
>
> Kia Orana Sean
>
> Great! That worked and thanks for helping me along the right path.  I
> can get my release out now, do the monthly tax return, pay the bills
> ... then see if I can get a sample project to Tim ...
>
> Thanks again
>
> Kia Manuia
>
> Jeff
>

Tim Young [Elevate Software] wrote:

> Jeff,
>
> << I'm getting an AV on closing a query.  Stepping through the code I
> get to the marked line below and get the AV >>
>
> If you can send me a project that reproduces this, I'll have a look
> and see if I can get you a source code fix.

Thanks Tim

I'll post the demo to binaries newsgroup

Kia Manuia

Jeff

--
Jeff Cook
Aspect Systems Ltd
www.aspect.co.nz
+
Joan and Jeff Cook
The Cooks Oasis
www.cookislandsoasis.com

"Jeff Cook" wrote:

>
> << I'm getting an AV on closing a query.  


Has this problem ever been solved?


Yours,
Kees Lagendijk

<Kees Lagendijk> wrote in message
news:6EAD5144-065C-4E7C-9A21-C013248776A6@news.elevatesoft.com...
> "Jeff Cook" wrote:
>
>>
>> << I'm getting an AV on closing a query.
>
>
> Has this problem ever been solved?
>
>
> Yours,
> Kees Lagendijk
>

Hi Kees

Looks like I asked the question - but can't recall it or find the thread in
the newsgroups ...

Probably the answer is yes as my app is running fine, but sorry I can't tell
you what fixed it.

Cheers

Jeff

--
Jeff Cook
Aspect Systems Ltd
www.aspect.co.nz

However, despite the fact it was eight years ago ...

I realised I was searching in the wrong forum.   The answer in this case was
to do as Tim said ...
----------------------------------------------------------
"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote on Wed, 21
Jun 2006 13:11:19 -0400
>
>What you might want to try, although it is a royal pain in the ass, is to
>use an INTO clause with the query to dump the query into a specific
>temporary table, close the query, use a table to open the temporary table,
>and then do the processing as needed.
>
Tim

Thanks!   I did as you suggested and !bingo!  - it all works OK.
----------------------------------------------------------

Cheers

Jeff

--
Jeff Cook
Aspect Systems Ltd
www.aspect.co.nz

"Jeff Cook" <jeffc@aspect.co.nz> wrote in message
news:E85C7D0D-5C47-4B92-A8E6-33924C0FF262@news.elevatesoft.com...
> <Kees Lagendijk> wrote in message
> news:6EAD5144-065C-4E7C-9A21-C013248776A6@news.elevatesoft.com...
>> "Jeff Cook" wrote:
>>
>>>
>>> << I'm getting an AV on closing a query.
>>
>>
>> Has this problem ever been solved?
>>
>>
>> Yours,
>> Kees Lagendijk
>>
>
> Hi Kees
>
> Looks like I asked the question - but can't recall it or find the thread
> in the newsgroups ...
>
> Probably the answer is yes as my app is running fine, but sorry I can't
> tell you what fixed it.
>
> Cheers
>
> Jeff
>
> --
> Jeff Cook
> Aspect Systems Ltd
> www.aspect.co.nz
>
>