Duplicated
Records Error
Under
certain circumstances you might get an error
“Duplicated Records”. In case this happens,
please notify us: tech@suncoastprograms.com
or 800-335-8817, we’d like to know what was
going on before the error occurred. Most times the
duplicated records start out in IRis 2.3 then get
converted into IRis 3.0 where we are now checking for
duplicated records. You can run the steps below in
IRis 2.3 and 3.0 (the directions are based on IRis
3.0 commands).
You
open IRis 3.0, in Navigator you click on “Resource
Management”, and than you click on for example
“Agency Records”. A message “Duplicated Records”
appears. In this case your DATABASE would be Agency
and your FIELD would be Number.
In other cases please substitute
appropriate DATABASE and FIELD.
To
correct the error:
1.
Go into IRis
2.
Go to Tools – Command Window
3.
The password is Shortbread (Case sensitive)
4.
Click on OK
5.
Press the ENTER key on your keyboard.
6.
Type the following commands:
a)
SELECT FIELD,
COUNT(FIELD) AS COUNT
FROM DATA\DATABASE
GROUP BY FIELD
<press
ENTER>
<press
ESC at the browse window
b)
BROWSE FOR COUNT > 1
<press
ENTER>
7.
Write down the information as shown in the browse
screen, if any.
8.
If there were records written down, type the
following:
a)
SELECT
DATABASE
<press
ENTER>
b)
BROWSE FOR FIELD
=”<enter the field data that you noted down
in step 7>”
*
*Note:
If you get the Message: "Operator/Operand type
mismatch", do not include QUOTES in step b)
<press
ENTER>
For
example: The program number that is duplicated is
CICS0001AA. The command would look like this: BROWSE FOR
NUMBER = “CICS0001AA”
9.
Click
on the last program listed and press CTRL +T, this will
put a black rectangle to the left of the record.
Press CTRL + W, this will save and close the table.
10.
Do the step 9 until all but one of the records
has the black rectangle.
11.
Do steps 8-10 until all the records you
noted down are completed.
12.
If you did not have any duplicate records, do
steps 1-7 using different DATABASE/FIELD
plug-ins. Then do steps 8-11.
