Re: SQL Cursor issues

[Sam_L <lennon_s_j@xxxxxxxxxxx>]

Sounds like it's probably a bug in you code. In debug, check the fields 
that control what is selected by the cursor. Perhaps something is being 
reset from the subfile or other display file to program variable 
interaction.

Also be sure you are checking the SQL status after both opening and 
closing the cursor.

Sam

On 6/11/2022 3:13 PM, Alan Cassidy wrote:
> Good day all,
>
> I have a program that declares and opens a cursor. The fetch is Load-All 
> into a DS array that I use to populate a subfile. When the program first 
> runs, works fine, I'm getting data displayed in the subfile, apparently 
> data that should be there.
>
> Here is the sequence of events:
>
> 1. Declare and open cursor M1.
>
> 2. Fetch all selected records into a DS array.  Data is returned to the 
> array.
>
> 3. Close the cursor.
>
> 4. Populate the subfile from the DS array. I see data, looks good.
>
> 5. Press F5 to refresh the data. (The cursor is based on an SQL View 
> that should return data that reflects changes to the underlying 
> tables/files the View is based on.
>
> 6. Returns ZERO rows. No data. Diagnostic data says zero too. So the 
> subfile is what I call empty.
>
> 7. F5 again. Repeat steps 1 thru 4 again, this time there is data again.
>
> After that it's a cycle. Press F5, blank screen. F5 again, data. F5 
> again, blanks. F5 again, data!
>
> I thought of doing a DYNAMIC SENSITIVE SCROLL CURSOR so the cursor 
> itself could get updated dynamically from data changes, /and/ at the 
> same time I can FETCH FIRST again and start over.
>
> Except then I need to rerun the Declare and Open when they request to 
> position to certain other places in the data, plus I want to implement 
> something like this for another place in the program where the users can 
> request a different ORDER BY.
>
> Any idea why this is happening, and more important how to "fix it"?
>
> To anybody who replies, THANK YOU!
>
> --Alan