Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert not working on remote view
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Insert not working on remote view
Divers
Thread ID:
00772565
Message ID:
00772565
Vues:
42
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform