Subject Re: Error Code 239 IDAPI error
From Michael Italiano <michael@abstractservices.com.au>
Date Thu, 19 Oct 2023 07:46:04 -0400
Newsgroups dbase.getting-started

Thanks Ken,

I've tried the settings, the first time I ran it it went 3 hours before it seemed to lose the tables, they just dropped out not tables open in area 0. The second time it lasted only 30 minutes.

The other effect I have noticed is that the index files are completely screwed, gone, destroyed.and that out of the file i am only reading data from. It makes no sense.

Mind you this code has worked flawlessly since dbase 7.5. I just noticed another module that was fine and untouched for many years all of a sudden has a random drop out, no errors nothing. I am lost at this point.

The only thing I have noticed is that the 3 modules it happens in has some legacy dbase commands for the tables and not local sql commands.

So i take it some commands wont work in 2019?

Its definately something to do with the low level BDE calls hence error 239 IDAPI Error, whatever that menas.

Anything else you can think of?

Thanks for your help, Michael.

Ken Mayer Wrote:

> On 10/18/2023 2:11 PM, Michael wrote:
> > Ken,
> >
> > Yes, all files have been recompiled under 2019.
> >
> > Local Share is always set to True
> > How large can we make SHAREDMEMORYSIZE ? I currently have it at 4096.
>
> Take it higher -- I have it at 16384 on my machine. Look at other
> settings as well.
>
> MaxBufSize: 16384
> MaxFileHandles 4096
> MemSize 205
> MinBufSize 4096
>
> See if that helps.
>
> Ken
>
>
> --
> *Ken Mayer*
> Ken's dBASE Page: http://www.goldenstag.net/dbase
> The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp
> dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm
> dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm
> dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm
> dBASE DOS to Windows Tutorial:
> http://www.goldenstag.net/dbase/DtoWTutorial/00_Menu.htm
>