Thank you, Chris, worked immediately. -----Ursprüngliche Nachricht----- Von: Programming <programming-boun...@forums.jsoftware.com> Im Auftrag von chris burke Gesendet: Samstag, 30. November 2019 13:19 An: Programming forum <programm...@jsoftware.com> Betreff: Re: [Jprogramming] sqlupdate
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-osnabrueck.de> wrote: > 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 e. $dat do. 0 return. end. > > if. 0 e. $nms do. nms=. sqlcols tab end. > ... > > I am running j805/j64/windows. > Thanks for your help. > > Markus > > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm