Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 11 to 18 of 18 total |
AV on closing a query - NOTE! v3.30!!! |
Thu, Mar 19 2009 2:35 PM | Permanent Link |
"Jeff Cook" | 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 |
Thu, Mar 19 2009 2:39 PM | Permanent Link |
"Jeff Cook" | 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 |
Thu, Mar 19 2009 3:24 PM | Permanent Link |
"Jeff Cook" | > 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 |
Thu, Mar 19 2009 3:31 PM | Permanent Link |
Sean | 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 > |
Tue, Mar 24 2009 6:01 PM | Permanent Link |
"Jeff Cook" | 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 |
Fri, Mar 21 2014 4:37 PM | Permanent Link |
Kees Lagendijk | "Jeff Cook" wrote:
> > << I'm getting an AV on closing a query. Has this problem ever been solved? Yours, Kees Lagendijk |
Sun, Mar 23 2014 5:00 PM | Permanent Link |
Jeff Cook Aspect Systems Ltd | <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 |
Sun, Mar 23 2014 5:11 PM | Permanent Link |
Jeff Cook Aspect Systems Ltd | 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 > > |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |