Yes - that fixes it! I set up the conditions as a string so my selection
and update would be on the same records. I didn't notice the absence of
"where" in the update.
My JVERSION is:
Engine: j9.4.1/j64/windows
Build: commercial/2023-02-27T15:32:45/clang-15-0-7/SLEEF=1
Library: 9.4.20
Platform: Win 64
Installer: j9.4 install
InstallPath: c:/pgm/j9.41
Contact: www.jsoftware.com
On Sat, Mar 18, 2023 at 11:30 AM Eric Iverson <eric.b.iver...@gmail.com>
wrote:
> 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
>
--
Devon McCormick, CFA
Quantitative Consultant
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
