Nice, I forgot about that BROWSE command. I cannot do much with the 02 option, right, because the tables are MS tables not R:Base? Or is there an additional config piece being kept by R:Base for this connection?
Thanks, Hans -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Friday, December 05, 2008 2:35 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: MS SQL 2005 table access with R:Base 8 At 03:25 PM 12/5/2008, Hans Manhave/Jackson-Lloyd wrote: >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, At least two options: 01. Specify each column with =nnn Example: BROWSE LastName=20,FirstName=20,CompanyName=30 FROM ... 02. Use the "Table Layout" option to customize individual table and columns with everything you can imagine. LAYOUT settings must be ON in order to save all settings. HELP LAYOUT should reveal everything you need to know. Very Best R:egards, Razzak.
