FUNCTION Edit ( Table AS String [ , Request AS String, Arguments AS , ... ] ) AS Result |
Request is a SQL WHERE clause used for filtering the table, and the Arguments are quoted as needed by the SQL syntax, and substituted inside the Request string, like the Subst() function does.
This feature allows you to write requests that are indepedendant of the underlying database type!
Please insert a good functional example HERE!
code here!
This example doesn't work:
PUBLIC SUB SaveData() DIM hResult AS Result DIM currentgg AS String DIM currentmm AS String DIM currentaa AS String DIM sSQL2 AS String $hConn.Begin currentgg=txtGiorno.Text currentmm=txtMese.Text currentaa=txtAnno.Text sSQL2="'" & currentgg & "','" & currentmm & "','" & currentaa & "'" 'sSQL2="gg='" & currentgg & "',mm='" & currentmm & "',aa='" & currentaa & "'" hResult=$hConn.Edit("tblDEFAULT","id=1",sSQL2) $hConn.Commit END