Look at the syntax for SELECT Each column name must be specified with the width for that column. If the contents of a column exceed the width for that column it wraps.
Dennis McGrath -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Hans Manhave/Jackson-Lloyd Sent: Friday, December 05, 2008 2:25 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: MS SQL 2005 table access with R:Base 8 A follow up question, is there a simple way to limit the width of the columns to a maximum of characters? I tried SELECT *=25 but that doesn't have any effect. Hans -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Walker, Buddy Sent: Friday, December 05, 2008 1:11 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: MS SQL 2005 table access with R:Base 8 Hans Maybe the width is set to 79. Before doing the select set the width to 250 SET WIDTH = 250 Buddy -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Hans Manhave/Jackson-Lloyd Sent: Friday, December 05, 2008 1:54 PM To: RBASE-L Mailing List Subject: [RBASE-L] - MS SQL 2005 table access with R:Base 8 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
