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

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:


May work.

1 Like