The default display width is 80 characters. Set it to 90, and the state
should show.
SET WIDTH 90
Hans Manhave/Jackson-Lloyd wrote:
I have can access a table in an external MS SQL database. I figure this
because I can enter "LIST MyTableName" and 76 column names come up. I'm
using the R> prompt interface.
If I enter at the R> prompt:
SELECT InsuredID NamedInsured State FROM MyTableName WHERE NamedInsured
CONTAINS 'MANHAVE'
The output is only two columns: InsuredId and NamedInsured, the State
column doesn't even show in the header. It doesn't matter what other
columns I request, I only get the first two, whatever they might be. Using
SELECT * only gives me two and there are 76 of them.
What am I doing wrong?
Thank you.
---
Hans Manhave
Operations Director
Jackson-Lloyd Ins
P.O.Box 187
Longview, TX 75606
903-758-6206
