Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sqlserver update
Message
De
11/07/2016 22:06:26
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Sqlserver update
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows 7
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01638243
Message ID:
01638243
Vues:
94
Dear Experts

I am using these codes for sqlserver 2008
	text TO m.cmd NOSHOW TEXTMERGE PRETEXT 7
    update master set desc1= ?thisform.text2.value,addr1= ?thisform.text3.value,addr2= ?thisform.text15.value,
			phone_o= ?thisform.text4.value,phone_r= ?thisform.text5.value,phone_m= ?thisform.text6.value,
			fax= ?thisform.text7.value,gst_no= ?thisform.text8.value,ntn_no= ?thisform.text10.value,
			nic_no= ?thisform.text11.value,weight= ?thisform.text14.value,qty= ?thisform.text18.value,
			pr_rate= ?thisform.text12.value,rate=?thisform.text13.value,main=?thisform.text17.value,
			qty_m=?thisform.text21.value,qty_p=?thisform.text24.value,jute_m=?thisform.text22.value,
			jute_p=?thisform.text25.value,brqty=?thisform.text23.value where code=?thisform.text1.value
			WHERE code=?Thisform.text1.Value
		ENDTEXT

		if sqlexec(m.con,cmd)<0
			aerror(laerror)
			messagebox(laerror[1,2])
			lok=.f.
		*	exit
		endif
It says:

---------------------------
Microsoft Visual FoxPro
---------------------------
Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'WHERE'.
---------------------------
OK
---------------------------


Please help me
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform