Looking a bit closer I think I see the problem.
The update where clause should not include the word where.
Example from the jdrt'update' tutorial:
jd'update f';'boolean=1';'byte';'x' NB. update where.
The error message had an obscure hint: |Not found: table where: throw
i think it will work if you remove the word where from the update.
There is still the issue of the crash. What is you JVERSION?
On Sat, Mar 18, 2023 at 11:13 AM Eric Iverson <eric.b.iver...@gmail.com>
wrote:
> I don't see anything obvious. The crash on 13!:1'' is concerning.
>
> Please send (directly) what I need to reproduce the error. Perhaps best
> would be a csv text file (or simple script to create the table). And a
> script that shows the error.
>
> On Sat, Mar 18, 2023 at 1:31 AM Devon McCormick <devon...@gmail.com>
> wrote:
>
>> Hi, I'm getting the following error, for these arguments:
>>
>> ('update ',tblnm);(}.cond);'handtype'
>> +-----------+-------------------------------+--------+
>> |update sim2|where simnum>=0 and simnum<1000|handtype|
>> +-----------+-------------------------------+--------+
>>
>> jd ('update ',tblnm);(}.cond);'handtype';<,"2 ht1
>> |Not found: table where: throw
>> |throw[0]
>> tblnm
>> |value error: tblnm
>>
>> 13!:4''
>> |Not found: table where: throw
>> |throw[0]
>> dbr 1 [ dbr 0
>>
>> 13!:1''
>> $ht1
>> 876 2 3
>> $,"2 ht1
>> 876 6
>> jd 'info schema sim2'
>> +-----+--------+----+-----+
>> |table|column |type|shape|
>> +-----+--------+----+-----+
>> |sim2 |simnum |int | _ |
>> |sim2 |holecard|byte| 8 |
>> |sim2 |highhand|byte|10 |
>> |sim2 |handtype|byte| 6 |
>> |sim2 |fhrank |byte| 2 |
>> +-----+--------+----+-----+
>>
>> If I do 13!:1'' immediately after the error, jconsole exits with this
>> message: Process shell<1> exited abnormally with code 5.
>>
>> Since I can't look at the stack immediately without crashing, I have to
>> cut
>> it back to see it (here with another table):
>>
>> jd 'update sim6';'where simnum>=0 and simnum<100';'fhrank';<fhr1
>> |Not found: table where: throw
>> |throw[0]
>> 13!:19''
>> |stop: getloc
>> | throw'Not found: ',(2}.>CHILD),' ',,":y
>> |getloc[7]
>> 13!:1''
>> |stop
>> * throw'Not found: ',(2}.>CHILD),' ',,":y
>> |getloc[7]
>> | tnms=:,<a[tloc=:, getloc root
>> |addtablepathnoind[8]
>> | addtablepathnoind f
>> |From[3]
>> | From from
>> |Read__dbl[1]
>> | r=. Read__dbl y
>> |jd_reads[26]
>> | jd_reads'/lr ',y
>> |jd_read[0]
>> | jd_read y
>> |jdi_read[0]
>> | w=.;{:,old=. jdi_read'jdindex from ',tab,' where ',w
>> |jd_update[20]
>> | r=. ('jd_',opx)~a
>> |jdx[:54]
>> | DBX jdx y
>> |jdx[1]
>> | jdlast_z_=: jdx y
>> |jd_jd_[1]
>> |jd[0]
>> | jd'update sim6';'where simnum>=0 and simnum<100';'fhrank';<fhr1
>>
>> I have a small copy of this database I can make available.
>>
>> --
>>
>> Devon McCormick, CFA
>>
>> Quantitative Consultant
>> ----------------------------------------------------------------------
>> For information about J forums see http://www.jsoftware.com/forums.htm
>>
>
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
