×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I know you indicated that you issued a write to the subfile control
record format. But the error seems to suggest that you are acutally
issuing a writing to the subfile record-format. Can you double
check...?
<Clip>
* Subject: Clearing a subfile
* From: Pete Helgren <pete@xxxxxxxxxx>
* Date: Mon, 20 Dec 2010 17:35:20 -0700
I am updating a set of records using SQL and when I am done, I want to
reload the subfile records so the user can see what records have not yet
been processed. The code I saw an example of did it like so:
Set the relative record number for the subfile to zero;
set ON the indicator for SFLCLR (which also sets OFF SFLDSPCTL)
issue a write to the Subfile control record format
set OFF the indicator for SFLCLR (which sets ON the indicator for
SFLDSPCTL)
load the subfile with records
When I do that I get the following:
Incorrect record number in subfile SFLRCDNBR or SFLSIZ field.
It complains about the record number being zero so I set it to 1 and
then tried again. This time it issues a duplicate key error.
So, how do I clear the subfile of all records so I can reload it?
Thanks,
</Clip>
midrange.com
