edit HSQLDB from Max

Jun 23, 2007 at 7:47am

edit HSQLDB from Max

#32590
Jun 23, 2007 at 10:49am

Your patcher code is fine… except that your SQL is probably not
doing what you intend.

You’ve written

UPDATE testtable SET info = sss WHERE ID = 1

which attempts to move data in column sss into column info – and you
have no column sss.

Try:

UPDATE testtable SET info = ‘sss’ WHERE ID = 1

(Somewhat surprisingly, it appears that the quotes don’t need to be
escaped.)

– N.

Nick Rothwell / Cassiel.com Limited
http://www.cassiel.com
http://www.myspace.com/cassieldotcom
http://www.loadbang.net

#107579

You must be logged in to reply to this topic.