Re: reset SQL to reprocess a subfile in an inquiry program(SQLRPGLE)

This does not make sense to me. Two close cursors to close a cursor should
not be needed. Have you walked through this in debug? Are you sure both
are being executed? Have you examined SQLCOD after the first close cursor?
It should be zero if the cursor was closed.

Sam

<shopping@xxxxxxxxxxxxxx> wrote in message
news:1151582255.401024.45720@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Thanks for the replies. I posted this on www.iseriesnetwork.net also.
The answer was, I needed to add a close after the declare. Now I have
two close cursors in the program. I'm still not sure why it works, but
it does. Hope this might help someone else.
Brian



.

Relevant Pages

  • Re: Touch Screen Experts Please Have A Look
    ... I think the serial port is sensing signal from somewhere? ... image works as perfect as ever with these motherboard so no point of debug. ... > Also are You really sure that You can see the cursor? ... It looks like you serial driver reports some ...
    (microsoft.public.windowsce.platbuilder)
  • Re: basic_string::append() acting weird at release mode
    ... As Igor mentions, you should turn off optimizations if you want to debug ... >> F10 again sends the step cursor back to tstrkey.append. ...
    (microsoft.public.vc.stl)
  • STRDBG Help.
    ... I start up debug: STRDBG PGMUPDPROD ... Put the cursor on statment 101, Hit, and the cursor jumps putting ... Putting a breakpoint anywhere after ... I've tried recompiling the program several times, ...
    (comp.sys.ibm.as400.misc)
  • Re: Touch Screen Experts Please Have A Look
    ... Also are You really sure that You can see the cursor? ... It looks like you serial driver reports some ... way to debug You driver. ... >> Looks like some problems with Your serial port ...
    (microsoft.public.windowsce.platbuilder)
  • Re: Cursor loop
    ... I've created a stored procedure that loops through a cursor, ... DECLARE curPeriod CURSOR LOCAL for SELECT * FROM tblPeriods ... The problem is that this loop only executes one time, ...
    (comp.databases.ms-sqlserver)