Re: [Jprogramming] sqlupdate

2019-11-30 Thread Schmidt-Gröttrup , Markus
Thank you, Chris, worked immediately. -Ursprüngliche Nachricht- Von: Programming Im Auftrag von chris burke Gesendet: Samstag, 30. November 2019 13:19 An: Programming forum Betreff: Re: [Jprogramming] sqlupdate j805 has an earlier version of the sqlite addon with no sqlupdate

Re: [Jprogramming] sqlupdate

2019-11-30 Thread chris burke
j805 has an earlier version of the sqlite addon with no sqlupdate function. For an update you need to construct a SQL expression and run that, e.g. something like sqlcmd__db 'update tab set d="elmo" where rowid=7' On Sat, Nov 30, 2019 at 3:26 AM Schmidt-Gröttrup, Markus < m.schmidt-groett...@hs-

[Jprogramming] sqlupdate

2019-11-30 Thread Schmidt-Gröttrup , Markus
I am wondering what is wrong with the surrounding such that sqlupdate is not available, when other sql-verbs are. load 'data/sqlite' db=. sqlopen_psqlite_ AVDB,'/aufgaben.sqlite3' sqlupdate__db |value error: sqlupdate__db sqlinsert__db 3 : 0 'tab nms dat'=. y if. 0