Instead of:
INSERT into rv_udfield (rv_udfield.firstname,....

should be:
INSERT into rv_udfield (firstname,....

whithout table name.


>I am trying to insert into a remote view (rv-) values from a local view (lv-) and I keep getting syntax error. Does anyone see something wrong with this statement:
>
>

>				INSERT into rv_udfield (rv_udfield.firstname, rv_udfield.middle , ;
>					rv_udfield.lastname, rv_udfield.dateappoint, rv_udfield.division, ;
>					rv_udfield.unit, rv_udfield.position, rv_udfield.dob, ;
>					rv_udfield.eyes, rv_udfield.ht, rv_udfield.wt, rv_udfield.department, ;
>					rv_udfield.issuedate, rv_udfield.extrahelp, rv_udfield.pmt, ;
>					rv_udfield.archive) 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))	
>

>
>Thanks
>Nick Patel