Many thanks to you once again, Bill! I will mainly use your first solution as I like the column names to be in separate rows as my database tables can have tens of columns and unnecessary ones can be easily removed. But I can include the second solution as an option. It produces a more compact result.
Best Regards, Esa On Thu, Nov 10, 2022 at 2:06 PM bill lam <[email protected]> wrote: > It should be a bug that already fixed in the latest j904 beta. You may > workaround it by replace {: with its equivalent, eg > > >(([:,&','each}:),{.@:(_1&{.));:'cat dog mouse' > cat, > dog, > mouse > > That said, I would usually do it this way > }:@:;@:(,&','&.>);:'cat dog mouse' > cat,dog,mouse > > > On Thu, Nov 10, 2022 at 4:42 PM esal <[email protected]> wrote: > > > Hi everybody > > > > I have an old verb that transforms a boxed array containing database > table > > column names into a string suitable for copying and pasting into a SQL > > SELECT statement. It crashes J903. > > > > Here is a simplified demonstration. > > > > > > > JVERSION > > > > > > Engine: j903/j64avx2/windows > > > > > > Release-b: commercial/2022-01-28T04:09:50 > > > > > > Library: 9.03.08 > > > > > > Qt IDE: 1.9.5s/5.15.2(5.15.2) > > > > > > Platform: Win 64 > > > > > > Installer: J903 install > > > > > > InstallPath: c:/j903 > > > > > > Contact: www.jsoftware.com > > > > > > > > > > NB. this works > > > > > > ]aux=.;:'cat dog mouse' > > > > > > ┌───┬───┬─────┐ > > > > > > │cat│dog│mouse│ > > > > > > └───┴───┴─────┘ > > > > > > >(([:,&',' each}:),{:)aux > > > > > > cat, > > > > > > dog, > > > > > > mouse > > > > > > > > > > > NB. this crashes J > > > > > > >(([:,&',' each}:),{:);:'cat dog mouse' > > > > > > > > > Best Regards, > > > > Esa > > ---------------------------------------------------------------------- > > 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
