Thanks, I can reproduce this and will fix On Tue, Mar 21, 2017 at 7:48 AM, Tom Arneson <t...@tomarneson.com> wrote:
> I have a sqlite database with a table of gas purchase information > > > > NB. sqlhead works as expected when selecting a field using sql 'from' > > > > 1 sqlhead__db 'date from gaspur where car = 1' > > +----------+ > > ¦date ¦ > > +----------¦ > > ¦2015-12-02¦ > > +----------+ > > > > 1 sqltail__db 'date from gaspur where car = 1' > > NB. returns nothing > > > > NB. sqltail used without 'from' i.e. getting all fields works as expected > > > > 1 sqltail__db 'gaspur where car = 1' > > +-----------------------------------+ > > ¦date ¦gallon¦cost ¦car¦mileage¦ > > +----------+------+-----+---+-------¦ > > ¦2017-02-17¦13.579¦29.05¦1 ¦203281 ¦ > > +-----------------------------------+ > > > > I can extract the date from the return value shown above but > > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
