Groups > dBase > dBase Internet > Re: Error Code 243




Error Code 243

Error Code 243
Mon, 28 Jan 2008 13:21:17 -050 
dbase +  I am building an application in which insurance agents enter 
details of policy changes they desire.  My program takes the data they enter 
in fields and creates phrases that will be used in a report.  The 
application in question, endtcreatedetaillines.exe takes fields from one 
.dbf and puts the phrase lines in a second .dbf table.  Then it calls either 
an .html file or a .php file.  Either way I get the output I am expecting 
along with the follow that displays beneath my response page.  The routine 
is 275 lines long; so, I didn't want to post it unless you absolutely have 
to see it.  What am I likely doing wrong and what is the cure?

Content-type: text/html
Program Alert


--------------------------------------------------------------------------------

01/28/2008 13:15:02.16
An error occurred in: 
D:\htdocs\ubquotesonline\public\cgi-bin\Endtcreatedetaillines.exe

Error Code: 243

Error: Invalid file Handle.

Source File: 
D:\htdocs\ubquotesonline\public\cgi-bin\endtcreatedetaillines.prg

Routine: endtcreatedetaillines

Line: 274


-- 
Dan Anderson
UBI Processing Dept.
andersond@ubinc.com
800-444-4824 ext 101
Post Reply
Re: Error Code 243
Mon, 28 Jan 2008 23:41:58 -050 
In article <y9xy7zdYIHA.1752@news-server>, andersond@ubinc.com says...
> dbase +  I am building an application in which insurance agents enter 
> details of policy changes they desire.  My program takes the data they
enter 
> in fields and creates phrases that will be used in a report.  The 
> application in question, endtcreatedetaillines.exe takes fields from one 
> .dbf and puts the phrase lines in a second .dbf table.  Then it calls
either 
> an .html file or a .php file.  Either way I get the output I am expecting 
> along with the follow that displays beneath my response page.  The routine

> is 275 lines long; so, I didn't want to post it unless you absolutely have

> to see it.  What am I likely doing wrong and what is the cure?
> 
> Content-type: text/html
> Program Alert
> 
> 
>
--------------------------------------------------------------------------------

> 01/28/2008 13:15:02.16
> An error occurred in: 
> D:\htdocs\ubquotesonline\public\cgi-bin\Endtcreatedetaillines.exe
> 
> Error Code: 243
> 
> Error: Invalid file Handle.
> 
> Source File: 
> D:\htdocs\ubquotesonline\public\cgi-bin\endtcreatedetaillines.prg
> 
> Routine: endtcreatedetaillines
> 
> Line: 274
> 
> 
> 

Dan,

It is not necessary to show the whole program, but it would defintely 
help to see the lines around 274 where the program is crashing.

-- 
Geoff Wass [dBVIPS]
Montréal, Québec, Canada

.|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.
Post Reply
Re: Error Code 243
Tue, 29 Jan 2008 09:36:20 -050 
line 274 is the QUIT command

      SELECT 1
      USE :UBIquotes:endtreport.dbf  exclusive ALIAS L
      INDEX ON itemnumber TAG itemnumber
      SET ORDER TO itemnumber

      SELECT 2
      USE :UBIquotes:edetail_short exclusive    ALIAS S
      delete all
      pack

      SELECT 1
      GO TOP
      DO WHILE NOT EOF()
           IF NOT ISBLANK(L->line1)
               SELECT 2
               APPEND BLANK
               REPLACE S->ItemDetail WITH  L->line1
               REPLACE S->ItemNumber WITH  L->ItemNumber
           ENDIF
           IF NOT ISBLANK(L->line2)
               SELECT 2
               APPEND BLANK
               REPLACE S->ItemDetail with L->line2
               REPLACE S->ItemNumber WITH  L->ItemNumber
           ENDIF
           IF NOT ISBLANK(L->line3)
               SELECT 2
               APPEND BLANK
               REPLACE S->ItemDetail with L->line3
               REPLACE S->ItemNumber WITH  L->ItemNumber
           ENDIF
           IF NOT ISBLANK(L->line4)
               APPEND BLANK
               REPLACE S->ItemDetail with L->line4
               REPLACE S->ItemNumber WITH  L->ItemNumber
           ENDIF
          IF NOT ISBLANK(L->line5)
               APPEND BLANK
               REPLACE S->ItemDetail with L->line5
               REPLACE S->ItemNumber WITH  L->ItemNumber
          ENDIF
          APPEND BLANK
          SELECT 1
          SKIP
          IF EOF()
              EXIT
          ENDIF
      ENDDO
      SELECT 1
      USE
      SELECT 2
      USE
      oCGI["Agent"] = cAgent
      oCGI["Producer"] =  cProducer
      IF oCGI["Idba"]=null
         oCGI["Idba"] = ""
      ENDIF
      IF ISBLANK(oCGI["Idba"])
          oCGI["IFullName"] = TRIM(oCGI["IName"])
      ELSE
          oCGI["IFullName"] = TRIM(oCGI["IName"])+"
d.b.a. 
"+TRIM(oCGI["Idba"])
      ENDIF

      cHTMLFile = '../endorsements/endtresponse.html'
      oCGI.DisplayHTML(NULL,cHTMLFile)

CLOSE ALL
QUIT

-- 
Dan Anderson
UBI Processing Dept.
andersond@ubinc.com
800-444-4824 ext 101
"Geoff Wass [dBVIPS]" <gswassREMOVE_ME@attglobal.net> wrote in
message 
news:MPG.220878a387676d8c989e8b@news.dbase.com...
> In article <y9xy7zdYIHA.1752@news-server>, andersond@ubinc.com
says...
>> dbase +  I am building an application in which insurance agents enter
>> details of policy changes they desire.  My program takes the data they

>> enter
>> in fields and creates phrases that will be used in a report.  The
>> application in question, endtcreatedetaillines.exe takes fields from
one
>> .dbf and puts the phrase lines in a second .dbf table.  Then it calls 
>> either
>> an .html file or a .php file.  Either way I get the output I am
expecting
>> along with the follow that displays beneath my response page.  The 
>> routine
>> is 275 lines long; so, I didn't want to post it unless you absolutely 
>> have
>> to see it.  What am I likely doing wrong and what is the cure?
>>
>> Content-type: text/html
>> Program Alert
>>
>>
>>
--------------------------------------------------------------------------------

>> 01/28/2008 13:15:02.16
>> An error occurred in:
>> D:\htdocs\ubquotesonline\public\cgi-bin\Endtcreatedetaillines.exe
>>
>> Error Code: 243
>>
>> Error: Invalid file Handle.
>>
>> Source File:
>> D:\htdocs\ubquotesonline\public\cgi-bin\endtcreatedetaillines.prg
>>
>> Routine: endtcreatedetaillines
>>
>> Line: 274
>>
>>
>>
>
> Dan,
>
> It is not necessary to show the whole program, but it would defintely
> help to see the lines around 274 where the program is crashing.
>
> -- 
> Geoff Wass [dBVIPS]
> Montréal, Québec, Canada
>
> .|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|.
> .|.|.| ---------------------------------------------------------- |.|.|.
> .|.|.|             IT Consultant http://Geoff_Wass.com            |.|.|.
Post Reply
Re: Error Code 243
Wed, 30 Jan 2008 00:17:36 -050 
Dan,

What happens if you take out the CLOSE ALL and/or QUIT?

A file handle is normally invoked by the low-level file routines like 
FOPEN(), FREAD(), etc. or the FILE object. It could be a file "thing"
is 
happening elsewhere in your code and is not properly closed or finished 
but the situation is only showing up because of the CLOSE ALL or QUIT.

-- 
Geoff Wass [dBVIPS]
Montréal, Québec, Canada

.|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.
Post Reply
about | contact