Does anyone know the syntax for the SQL "update" command, I've been using Doc Kimmels SQL Protocol and I've been successful in inserting rows but I have not been able to figure out the update row syntax.
To insert the data: empnum: "123" and lname: "Smith" I use the statement below: insert db ["insert into employes values (?,?)" empnum lname] What is the syntax to update this row with the new value lname: "Jones" WHERE empnum='123' but I'm using a variable for the "WHERE" part. The following is wrong but it should look something like this: insert db ["UPDATE employes SET (?,?)" lname fname "WHERE lname=(?)" lname] -- To unsubscribe from the list, just send an email to lists at rebol.com with unsubscribe as the subject.
