Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert not working on remote view
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Insert not working on remote view
Miscellaneous
Thread ID:
00772565
Message ID:
00772565
Views:
41
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
Next
Reply
Map
View

Click here to load this message in the networking platform