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
