Subject Binary columns
From Raffaele Lafratta
Date Sun, 31 Mar 2019 22:46:45 +0200
Newsgroups sqlexpress

I use a prepared statement to insert into a sql server table

oStmt:New("INSERT INTO MYTABLE NAME,UUID VALUES (?,?)"
oStmt:prepare()

.....

cBin:=UUIdCreate()
oStmt:Execute ( {"Raf", cBin} )

UUID is binary

The execute fails with "implicit conversion from char to binary is not
allowed. Use CONVERT function

What can i do ?

Tanks in advance
Raffaele

Recent messages in this thread
 
-# Binary columns (Current message) Raffaele Lafratta 31-Mar-2019 09:46 pm
.-# Re: Binary columns Boris Borzic <bb> 01-Apr-2019 03:02 pm
..\# Re: Binary columns Raffaele Lafratta 01-Apr-2019 04:55 pm