Hans,
Try
SELECT colname1=4,colname2=8,colname3=12,colname4=5, ... etc.
Jan
----- Original Message -----
From: "Hans Manhave/Jackson-Lloyd" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, December 05, 2008 12:25 PM
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
