Passage de paramètres dans une requête SQL de type INSERT

De zBasic
Aller à : navigation, rechercher


Sub Main
	GlobalScope.BasicLibraries.loadLibrary ("zBasic")
	
	sReq = "INSERT INTO ""Client"" " & _ 
			"(""nom_client"", ""prenom_client"", " & _
			" ""valeur_client"", ""date_client"") " & _
			"VALUES (?,?,?,?)"
	sUrl = "C:\Users\Dude\Documents\Client.odb" 
	
	oCnx = zSQL.Demarre(sUrl)
	zSQL.Parametre(aParam, 1, "Gabin")
	zSQL.Parametre(aParam, 2, "Jean")
	zSQL.Parametre(aParam, 3, 28.82)
	zSQL.Parametre(aParam, 4, "2024-03-21")
	sRet = zSQL.Prepare(oCnx, "InsertClient", aParam, "REQ")
End Sub