I am getting an intermittant error message when keying in a form and then clicking on the "NEXT" button to go to the next record. I don't get the error in my development directory but I am seeing it at the customer's site. I have a set of 75 records as our test data that we are using to TEST various fixes that I have tried. The last test I tried failed once in 2 out of the 3 keying trials. This is the first time I have tried LOCAL VIEWS in one of my applications so I don't know what the problem is. It seams to me like maybe the view is taking too long to update the database when the record pointer moves to the next record. Each time I get the error message I get different line numbers where it is failing but I am always seeing some Database update code in each of the errors. Here is how I have my "Update Criteria" set in my VIEW with 82 records.

Send SQL Updates
Update All
Key and Modified Fields
SQL Update



Here are some of the error messages that I am getting.

Any Ideas?

1)
01/11/2005 11:13:12 Err Msg: File does not exist.
Key From Image will be shut down.
01/11/2005 11:13:12 Program: PROCEDURE FRMDATAENTRY.DISPLAYIMAGE K:\KYRIS\TEST\FPHSTEXE\KFI4\FRM\DATAENTR101.SCT
01/11/2005 11:13:12 Line: 25
01/11/2005 11:13:12 Source: SELECT Detail.* FROM kfi!detail101 Detail, KFISETS WHERE ( Detail.set_id = Kfisets.set_id AND UPPER(ALLTRIM(Kfisets.user_id)) == ( UPPER(ALLTRIM(enteredid)) ) ) AND EMPTY(Detail.keyedby) ORDER BY Detail.key_id into cursor Viewcalv46
01/11/2005 11:13:12

2)
01/11/2005 10:18:19 Err Msg: Unknown member OLESLIDER.
Key From Image will be shut down.
01/11/2005 10:18:19 Program: PROCEDURE FRMDATAENTRY.DISPLAYIMAGE K:\KYRIS\TEST\FPHSTEXE\KFI4\FRM\DATAENTR101.SCT
01/11/2005 10:18:19 Line: 81
01/11/2005 10:18:19 Source: SELECT Detail.* FROM kfi!detail101 Detail, KFISETS WHERE ( Detail.set_id = Kfisets.set_id AND UPPER(ALLTRIM(Kfisets.user_id)) == ( UPPER(ALLTRIM(enteredid)) ) ) AND EMPTY(Detail.keyedby) ORDER BY Detail.key_id into cursor Viewcalv97
01/11/2005 10:18:19

3)
01/20/2005 11:05:46 Err Msg: File does not exist.
Key From Image will be shut down.
01/20/2005 11:05:46 Program: PROCEDURE FRMDATAENTRY.CMDNEXT.CLICK K:\KYRIS\TEST\FPHSTEXE\KFI4\FRM\DATAENTR101.SCT
01/20/2005 11:05:46 Line: 21
01/20/2005 11:05:46 Source: UPDATE kfi!detail101 SET keyedby=detail.keyedby,field1=detail.field1,field3=detail.field3,field5=detail.field5,field7=detail.field7,field8=detail.field8,field9=detail.field9,status_flg=detail.status_flg,field13=detail.field13,field14=detail.field14,field15=detail.field15,field16=detail.field16,field17=detail.field17,field19=detail.field19,field21=detail.field21,field25=detail.field25,field28=detail.field28,f_xsize=detail.f_xsize,f_ysize=detail.f_ysize WHERE keyedby=OLDVAL('keyedby','detail') AND field1=OLDVAL('field1','detail') AND field3=OLDVAL('field3','detail') AND field5=OLDVAL('field5','detail') AND field7=OLDVAL('field7','detail') AND field8=OLDVAL('field8','detail') AND field9=OLDVAL('field9','detail') AND status_flg=OLDVAL('status_flg','detail') AND field13=OLDVAL('field13','detail') AND field14=OLDVAL('field14','detail') AND field15=OLDVAL('field15','detail') AND field16=OLDVAL('field16','detail') AND field17=OLDVAL('field17','detail') AND field19=OLDVAL('field19','detail') AND field21=OLDVAL('field21','detail') AND field25=OLDVAL('field25','detail') AND field28=OLDVAL('field28','detail') AND f_xsize=OLDVAL('f_xsize','detail') AND f_ysize=OLDVAL('f_ysize','detail') AND key_id=OLDVAL('key_id','detail')