Help with func_odbc

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

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

Hi Jcolp,

Thanks for the reply, What should I use instead?

You need to use the Set application:

Set(ODBC_DEL_BLOCKED()=)

May work.

1 Like