Help with func_odbc

aysman · February 21, 2019, 6:55am

Hi Guys,

I would like to ask if there is a way to delete rows in mysql using func_odbc. I have this in my conf file

[DEL_BLOCKED]
dsn=myschema
writesql=DELETE FROM mytable WHERE trans_no = ‘200’

But CLI displays “Function ODBC_DEL_BLOCKED cannot be read”

Thanks in Advanced

jcolp · February 21, 2019, 10:39am

You have specified a writesql, so it is only usable with the Set() application.

aysman · February 21, 2019, 1:44pm

Hi Jcolp,

Thanks for the reply, What should I use instead?

jcolp · February 21, 2019, 1:53pm

You need to use the Set application:

Set(ODBC_DEL_BLOCKED()=)

May work.