Hi Peter Ah, I must have missed that the ability to put a column alias in when looking at the Select statement. It's a toss-up now whether to go this way of via Greg's suggestion. You guys spoil me!!! :-)
Thanks a lot Terry -----Original Message----- From: Peter Horsbøll Møller [mailto:[EMAIL PROTECTED] Sent: 17 October 2005 14:01 To: Terry McDonnell Subject: RE: MI-L Need to display data in a grid Terry, You can use the column Alias for renaming the columns. Select NAME_CUTOF1 "Much more meaningful name 1", NAME_CUTOF1 "Much more meaningful name 2" From sTab I guess you should do this thru Run Command in your MapBasic application: For i = 1 To NumCols(sTab) sCol = ColumnInfo(sTab, "COL"+1, COL_INFO_NAME) if sCmdStr = "" Then sCmdStr = "Select " + sCol + " " + Char$(34) + GetMeaningfulColumnName$(sCol) + Chr$(34) else sCmdStr = sCmdStr + ", " + sCol + " " + Char$(34) + GetMeaningfulColumnName$(sCol) + Chr$(34) end if Next where the function GetMeaningfulColumnName$() will return the meaningful name for the column --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 18327
