E
Elsworth Burmeister
Guest
Hi Guys Can anyone please give me a working example of how to use the command parameters in and insert statement into a sql db. Ive tried a few times and couldnt get it working. Can the example please include 2 different datatypes to insert into. i keep running into issues where it seems to be overriding the first parameter with the last one. Example below is how i got it working using 1 parameter and its for an update statement: cmd = NEW System.Data.Odbc.OdbcCommand(SUBSTITUTE("UPDATE table SET [mage] = ? WHERE [document] = '&1'","xyz"),connection). cmd
arameters:Add("image", OdbcType:VarBinary). cmdarameters["image"]:Value = oReturn. cmd:ExecuteNonQuery(). OE: 11.7 TIA
Continue reading...
arameters:Add("image", OdbcType:VarBinary). cmdarameters["image"]:Value = oReturn. cmd:ExecuteNonQuery(). OE: 11.7 TIAContinue reading...