RE: MI-L MapInfo Layering problem.....

Lai, You could use MagicMove utility to shift the roads into their 'correct' position. You can get it from -http://www.mapinfo.com/free/mb_40util.cfm HTH Greg -Original Message- From: Laisiasa Ginigini [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 01:10 To: mapinfo-l

MI-L SQL Query

Dear All I have a table which consists of Line, Point and Text data. I need a SQL query that will enable me to pick out either all Text items or all Line items etc. Is this possible to do and does anybody know how ? Thanks in advance Andrew Tracey Development Services Department South Tyneside

RE: MI-L SQL Select

I used once in the SQL requester that where condition instr(1,Col_Name, )0 If possible one should always use pure SQL statements. Where Col_Name like % % Its time eating using function calls from a SQL statement. A simple test on 500,000 records is 3.44 % faster with pure SQL. Best regards,

RE: MI-L SQL Query

Andrew, From the Query, SQL Select option type: Select Columns: * from Tables: your_table_name Where: str$(objectinfo(obj,1)) = n with n representing one of the following numbers: 1 - arc 2 - ellipse/circle 3 - line 4 - polyline 5 - point 6 - layout window frame 7 - region 8 -

MI-L Crystal Reports

Hi, I have created a report in Crystal Reports (CR) which I open from my MapBasic application. I can print the report by refreshing the data (in CR) and using the print option. Is there anyway I can refresh the data and print from my application? Ideally I want to press one button in MI which

RE: MI-L Crystal Reports

Yes u can dde, I suggest picking up CR 8, just because it has a better API for VB intergration -Original Message- From: Ian Hull [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 7:18 AM To: [EMAIL PROTECTED] Subject: MI-L Crystal Reports Hi, I have created a report in Crystal

MI-L Odd Question: Access, VBA and MI

Hi list, This is not a question I really want to ask, but it's been bothering me. stAppName = C:\Program Files\MapInfo\Professional\Mapinfow.exe + P:\Shared Information\LSDDatabase\LSD\LSD.MBX Call Shell(stAppName, 1) My access program says it can't find file Shared! I know it's having a

RE: MI-L Odd Question: Access, VBA and MI

Ben Matt, All you need is to add quotes to your string, so: stAppName = C:\Program Files\MapInfo\Professional\Mapinfow.exe + P:\Shared Information\LSDDatabase\LSD\LSD.MBX Call Shell(stAppName, 1) This'll take care of the space that is causing the problem. Michael Hanna Industrial

AW: MI-L Odd Question: Access, VBA and MI

Ben, I reckon you have to protect the string with the space space somehow. maybe with \ ?? stAppName = C:\Program Files\MapInfo\Professional\Mapinfow.exe + \P:\Shared Information\LSDDatabase\LSD\LSD.MBX\ or instead, try to escape the space somehow. I dont know how to escape it exactly,

RE: MI-L Query by symbols

You need the Select by Drawing Style tool called SDS.MBX, found at www.directionsmag.com It allows you to specify a query by symbol type only or you can specify color and size as well. It also allows you to select all the different object types in a similar fashion. William Woody Woodruff

MI-L Pixshow

Hi all, We currently use MI V5.5 and I having problems with the above tool. When a user closes a window with an image it terminates mapinfo completely. Does any one have a fix to this one. Regards Paul Middleton GIS Manager Eurobodalla Shire Council P.O Box 99, Moruya NSW, 2537, Australia

MI-L create a major streets layer

Hello everyone, We need to figure out how to create maps using TIGER streets that show more than all A1*, A2*, and A3* but not all the A4* streets. Has anyone figured out a way to select a subset of the A4* streets that say, cuts them to around 10%? Another way to phrase our objective is that

RE: MI-L SQL Query

Str$(obj) = text is much simpler -Original Message- From: Driver, Greg 9434 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 26 June 2002 4:55 PM To: 'Andrew Tracey'; '[EMAIL PROTECTED]' Subject: RE: MI-L SQL Query Andrew, From the Query, SQL Select option type: Select Columns: * from

MI-L Integrated Alter Table command

Hello, does anybody knows how to help me with this? I am trying to call Alter Table function through OLE object, but every time the application stop and continue only when window is activated by mouse. Any help would be appreciated. Best regards Stefan Majtan

MI-L Sum MI-L Custom Symbol - North Arrow

Hi All, I have a solution to my problem. Thank you to David, Kathy Woody. Woody, suggested that I used the table - which I will do. Kathy offered to try the symbol for me. David sent me a detailed description of Symbol types and how they work. The .BMP I had built from MI was about 64*32

RE: MI-L Integrated Alter Table command

Hi Stefan, Try issuing the following command before altering the table structure: Set ProgressBars Off Quote out of MapBasic help: When a progress bar displays while MapInfo is minimized, the progress bar is frozen for as long as MapInfo is minimized. If you suppress the display of progress