` Printed Icetips Article
Icetips Article

ABC: Error 37 on a browse procedure
1998-08-18 -- Jim Katz
Newsgroups: comp.lang.clarion

> The first time I use the setup window, everything is fine.  The
> browse, report, or whatever works just fine.  But if I again select
> any function that calls the setup window, I get an error 37, (File Not
> Open), on the sport file.  There's nothing fancy about this setup
> window.  It's a window with OK and Cancel.  It has one drop down for
> the sport file and a validate for the team file.  I eliminated the
> validate for the team file.  Same problem.  I eliminated the drop down
> for the sport file.  Problem was gone.  I added back a validate
> instead of a drop down for the sport file.  Problem's back.

I was having a similar problem with a custom tree browse. Sometimes when
I re-entered the procedure there was just nothing showing up in the
browse. What I found was that the filemanager's method for keeping track
of how many times the file had been opened on the particular thread was
getting lost and confused. I straightened it out with this bit of code
in the Window Manager's Kill method:

  Loop
    Open(ConType,ReadWrite)
    IF Errorcode() = 52  ! File Already Open
      Relate:ConType.Close
    Else
      Close(Contype)
      Break
    End
  End

This just insures that the _actual_ closed state is in sync with what
the filemanager _thinks_ the closed state is.

HTH

> I'm having a new challenge with an ABC based app.  I have a browse, a
> fairly simple browse.  The browse calls a setup window to allow a
> sport and team to be selected.  (This setup window is used in many
> places as well.  The problem I'll describe happens everywhere this
> browse is used.)
>
> The first time I use the setup window, everything is fine.  The
> browse, report, or whatever works just fine.  But if I again select
> any function that calls the setup window, I get an error 37, (File Not
> Open), on the sport file.  There's nothing fancy about this setup
> window.  It's a window with OK and Cancel.  It has one drop down for
> the sport file and a validate for the team file.  I eliminated the
> validate for the team file.  Same problem.  I eliminated the drop down
> for the sport file.  Problem was gone.  I added back a validate
> instead of a drop down for the sport file.  Problem's back.
>
> This is a C4b app using the ABC templates.  This procedure is all
> generated code except for a couple of embeds to clear some globals and
> set a key value.  This app was converted from 2003 to C4.  (I won't
> make  *that*  mistake again!).  I have had to redo a number of
> functions in the C4 version of the app.
>
> This worked fine in 2003.
Printed November 23, 2024, 5:34 am
This article has been viewed/printed 35355 times.
Google search has resulted in 114 hits on this article since January 25, 2004.