Passage de paramètres dans une requête SQL de type INSERT
De zBasic
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