El 18/5/15 a las 20:46, José María Terry Jiménez escribió:
> El 18/5/15 a las 19:19, Christian Schmitz escribió:
>>> // insert value
>>> cmd.setCommandText("Insert into test (key) values ('"+CypheredString+
>>> "')")
>>>
>> please use a prepared statement here.
>> You can't put binary data in a query.
>>
>>
Hello
I'm trying to use prepared statements for first time here and i got an
error:
“There is more than one item with this name and it’s not clear to which
this refers.”
In the 2 p.BindType and p.Bind in this code:
dim sql as string = "Insert into test (key) values (:cifrado)"
dim v as Variant = db.Prepare(sql)
dim p as SQLPreparedStatementMBS = v
p.BindType("cifrado", SQLPreparedStatementMBS.kTypeBlob)
p.Bind("cifrado", CadenaCifrada)
The same error if i replace the 2 p.Bind... with
p.Bind("cifrado", CadenaCifrada, SQLPreparedStatementMBS.kTypeBlob)
CadenaCifrada is an String (what i got from E-Cryptit plugin)
I've found this: https://forum.xojo.com/22466-error-using-mbs-plugin but
don't see a solution here
Any ideas?
Best,
_______________________________________________
Mbsplugins_monkeybreadsoftware.info mailing list
[email protected]
https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info
