Re: dbaccess sql output

Terron Wright wrote: > > Is there away to force a sql dbaccess script to produce output with each > record being displayed horizontally? My script is: > > select * from atable> > The output looks like this: > > acolumn1 test > acolumn2 test2 > acolumn3 test3 > acolumn4 test4 > > I would like for the report to look like this: > > acolumn1 acolumn2 acolumn3 acolumn4 > > I can do this if I do a select and put in each individual column but > that is time consuming. Does anyone have a solution or suggestion? Terron, I've tried soooo many tricks! Using environment variables ROWS, COLUMNS after altering my screen window. Nothing helps. Methinks the screen size of 80x24 (how quaint ;-) is hard coded into dbaccess. The only way I have been able to do this is by running the SQL statement in an ACE report, which seems to assume a wider display (132) by default. -- -- Jake (In pursuit of undomesticated aquatic avians) +-----------------------------------------------------------+ | Impeccable Logic: A thought process which successfully | | resists chicken bites | +-----------------------------------------------------------+