Hi Nick,

Make sure that the rv_udfield remote view and the lv_x_emp cursors are open. I think the insert is trying to look for the one of them (probably the rv_udfield) and can't find it in the current data session.

Yes, you'll need the tableupdate to finalize the changes. Make sure your tablebuffering is set to 3 or 5 (I usually use 5).

HTH,
Arriyel

>I have a remote view that I am trying use INSERT command on and I keep getting a dialog box to select a dbf. Here is code:
>
>
>

>				INSERT into rv_udfield (firstname, middle , lastname, dateappoint, ;
>					division, unit, position, dob, eyes, ht, wt, department, ;
>					issuedate, extrahelp, pmt, archive, idnumber) VALUES ( ;
>				ALLTRIM(lv_x_emp_itc.firstname), ;
>				ALLTRIM(lv_x_emp_itc.mid), ;
>				ALLTRIM(lv_x_emp_itc.lastname), ;
>				lv_x_emp_itc.dateappoint, ;
>				ALLTRIM(lv_x_emp_itc.division), ;
>				ALLTRIM(lv_x_emp_itc.unit), ;
>				ALLTRIM(lv_x_emp_itc.position), ;
>				lv_x_emp_itc.dob, ;
>				ALLTRIM(lv_x_emp_itc.eyes), ;
>				ALLTRIM(lv_x_emp_itc.ht), ;
>				ALLTRIM(lv_x_emp_itc.wt), ;
>				ALLTRIM(lv_x_emp_itc.department), ;
>				lv_x_emp_itc.issuedate, ;
>				ALLTRIM(lv_x_emp_itc.extrahelp), ;
>				ALLTRIM(lv_x_emp_itc.pmt), ;
>				ALLTRIM(lv_x_emp_itc.archive), ;
>				(x))	
>

>
>I should be able to use INSERT command on remote views right? Also will I need do tableupdate command on remote views?
>
>Thanks
>Nick Patel