JDB Delete__ command does not delete completely, re-insert results in: throw'101 Duplicate values in column: ',msg.
load 'data/jdb' ffd =: Open_jdb_ jpath , '~temp' db =: Create__ffd 'db19' NB. Table of unique varchar Create__db 'mytype';0 : 0 value varchar; ) +--+ |19| +--+ Insert__db 'mytype';<<'A';'B' NB. two rows Reads__db 'from mytype' NB. insert has worked +-----+ |value| +-----+ |A | |B | +-----+ Delete__db 'mytype';'value=A' NB. remove row 'A' Reads__db 'from mytype' NB. It has gone +-----+ |value| +-----+ |B | +-----+ Insert__db 'mytype';<<'A' NB. But re-insert fails |101 Duplicate values in column: value value: A: throw | throw'101 Duplicate values in column: ',msg ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
