Hi,
Thanks Yannick Leduc, Yas NaKayama, Jacques Paris, Chris Perry, Martin Roundill
and Russel Lawley for all your great help in my question. I feel so warm in my
heart. We are in a big great family!!!
Have a great weedend,
David
Martin Roundill <[EMAIL PROTECTED]> on 01/20/2000 08:29:25 PM
To: David D Hou/IT/Corporate/Blockbuster@BBEGI, "Mapinfo List (E-mail)"
<[EMAIL PROTECTED]>
cc:
Subject: RE: MI Multiple columns selection in SQL
David,
The easiest way to do this is to construct a command string and run that. eg
Dim exp as String
dim cmd as string
exp = "A, B, C"
cmd = "Select "+exp+ "from test"
run command cmd
Hope this helps
Martin
==================================
Martin Roundill
GIS Manager
Waitakere City Council
Private Bag 93109
Henderson
Waitakere City
New Zealand
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, 21 January 2000 10:15
To: Mapinfo List (E-mail)
Subject: MI Multiple columns selection in SQL
Hi dear friends,
I want to select more than one columns in one SQL statement. How can I use a
string or alias variable as the expression after the Select key word? Like I
have a table named Test with four columns A, B, C, and D. Can I do this:
Dim exp as String (or Alias)
exp = "A, B, C"
Select exp From Test
I tried, but it didn't work. Thanks in advance for any help,
David Hou
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
