unofficial mirror of help-gnu-emacs@gnu.org
 help / color / mirror / Atom feed
* column alignment in sqlplus mode--how?
@ 2004-07-21 21:01 f geisler
  2004-07-22 10:52 ` Mathias Dahl
  2004-07-22 14:43 ` Galen Boyer
  0 siblings, 2 replies; 4+ messages in thread
From: f geisler @ 2004-07-21 21:01 UTC (permalink / raw)


How can I assure columns align in the *SQL* buffer?

When displaying a table in my *SQL* (sql-oracle) buffer, column
alignment is often a problem. The column format is set, and aligns
correctly in a non-emacs window. I presume the problem is related to
tabulation, although a simple replace with spaces did not help.

Thanks in advance for you help.

^ permalink raw reply	[flat|nested] 4+ messages in thread

* Re: column alignment in sqlplus mode--how?
  2004-07-21 21:01 column alignment in sqlplus mode--how? f geisler
@ 2004-07-22 10:52 ` Mathias Dahl
  2004-07-22 14:43 ` Galen Boyer
  1 sibling, 0 replies; 4+ messages in thread
From: Mathias Dahl @ 2004-07-22 10:52 UTC (permalink / raw)


fgbulk@yahoo.com (f geisler) writes:

> When displaying a table in my *SQL* (sql-oracle) buffer,
> column alignment is often a problem. The column format is
> set, and aligns correctly in a non-emacs window. I presume
> the problem is related to tabulation, although a simple
> replace with spaces did not help.

Can you give an example of how it looks? I use sql-oracle
quite much and have no problems with it. I use a lot of

col my_col format a10 trunc

though...

^ permalink raw reply	[flat|nested] 4+ messages in thread

* Re: column alignment in sqlplus mode--how?
  2004-07-21 21:01 column alignment in sqlplus mode--how? f geisler
  2004-07-22 10:52 ` Mathias Dahl
@ 2004-07-22 14:43 ` Galen Boyer
  2004-07-23 19:22   ` f geisler
  1 sibling, 1 reply; 4+ messages in thread
From: Galen Boyer @ 2004-07-22 14:43 UTC (permalink / raw)


On 21 Jul 2004, fgbulk@yahoo.com wrote:
> How can I assure columns align in the *SQL* buffer?
> 
> When displaying a table in my *SQL* (sql-oracle) buffer, column
> alignment is often a problem. The column format is set, and
> aligns correctly in a non-emacs window. 

The only time I've seen this is on

   select attr,count(*) ..
   group by attr;

> I presume the problem is related to tabulation, although a
> simple replace with spaces did not help.
> 
> Thanks in advance for you help.

Try the sqlplus setting
"set tab off"

Does this change the behaviour?

-- 
Galen Boyer

^ permalink raw reply	[flat|nested] 4+ messages in thread

* Re: column alignment in sqlplus mode--how?
  2004-07-22 14:43 ` Galen Boyer
@ 2004-07-23 19:22   ` f geisler
  0 siblings, 0 replies; 4+ messages in thread
From: f geisler @ 2004-07-23 19:22 UTC (permalink / raw)


Galen Boyer <galenboyer@hotpop.com> wrote in message news:<uekn4p0kl.fsf@standardandpoors.com>...
> On 21 Jul 2004, fgbulk@yahoo.com wrote:
> > How can I assure columns align in the *SQL* buffer?
> > 
> > When displaying a table in my *SQL* (sql-oracle) buffer, column
> > alignment is often a problem. The column format is set, and
> > aligns correctly in a non-emacs window. 
> 
> The only time I've seen this is on
> 
>    select attr,count(*) ..
>    group by attr;
> 
> > I presume the problem is related to tabulation, although a
> > simple replace with spaces did not help.
> > 
> > Thanks in advance for you help.
> 
> Try the sqlplus setting
> "set tab off"
> 
> Does this change the behaviour?


Yes! Thanks so much.

^ permalink raw reply	[flat|nested] 4+ messages in thread

end of thread, other threads:[~2004-07-23 19:22 UTC | newest]

Thread overview: 4+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2004-07-21 21:01 column alignment in sqlplus mode--how? f geisler
2004-07-22 10:52 ` Mathias Dahl
2004-07-22 14:43 ` Galen Boyer
2004-07-23 19:22   ` f geisler

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).