MI Thanks for Multiple columns selection in SQL
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]
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]
MI Dialog remove
Hi, all friends, I remember somedays before there is a post in our list about the dialog remove command. I did not save that mail. Now I have the same problem. I used 'dialog remove' in Mapbasic program, but the dialog did not remove after I call the procedure. It is still there at the background. Dose anybody know how to solve that? Thanks very much. David -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI TIGER Files
Hi all friends, How can I read Census Bureau's TIGER/Line files into MapInfo? There are 17 files for each county in TIGER/Line files, each has a special meaning. I don't know if there is any command in MapInfo can be used to read those files. Thansk a lot. David Hou Blockbuster Entertainment 1201 Elm Street Dallas, TX 75270 214.854.3583 -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI Many thanks for the great help!
Great thanks to Jason Adam, Patrick Phillips, Simon Hume, Marc Pelosse, Martin Hodder, and all our list friends. My problem of moving objects in MapInfo was solved. Here I summarize the main three solutions: The most accurate way to accomplish that would be to first Export as a MID/MIF table. Open your MIF file in Notepad, and add the line: Transform 0,0,0,2000 'that's for %X, %Y, metresX, and metresY. Make sure your Projection clause line supports Meters for the MapUnits parameter (there will be a 7 in the first 2 or 3 digits). Now import the file back to MapInfo. One solution consists of exporting your tab file in DXF, and then import it and specify the parameters for the transformation. Look into the possibility of there being an Offset function of the feature.obj. This is easy to do with MapX and VB. Public Sub MoveFeature(Feat As MapXLib.Feature, FeatX_distance As Double, Y_distance As Double) Feat.Offset X_distance, Y_distance Feat.Update End Sub Thanks very much again for your great help. Best regards, David Hou David Dewen Hou Blockbuster Entertainment Group 1201 Elm Street, Dallas, TX 75270 Tel: 1.214.854.3583 Fax: 1.214.854.4331 Email: [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]