Hi all. Is it possible to create a new table and save it with a password, so only those who know the password can open it?
Thanks -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, February 15, 2006 4:52 AM To: [email protected] Subject: MapInfo-L Digest, Vol 4, Issue 22 Send MapInfo-L mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit http://www.directionsmag.com/mailman/listinfo/mapinfo-l or, via email, send a message with subject or body 'help' to [EMAIL PROTECTED] You can reach the person managing the list at [EMAIL PROTECTED] When replying, please edit your Subject line so it is more specific than "Re: Contents of MapInfo-L digest..." Today's Topics: 1. How to remove carriage return from row? (D. Peter Berical) 2. Re: Ordering of Thematic layers (Bill Thoen) 3. External dll with variable path (Peter Horsb?ll M?ller) 4. Re: External dll with variable path (Uffe Kousgaard) 5. [Spam] ADV: Get the recognition you deserve ? enter the MapInfo Meridian Awards ([EMAIL PROTECTED]) 6. MAPINFO EDIT MBX TOOL (Peter Hatton) 7. Re: How to remove carriage return from row? (Trey Pattillo) 8. Selecting intersecting polylines with differen attribute ([EMAIL PROTECTED]) 9. Identifying points greater than x metres from ANY point in another table (Leigh Bettenay) 10. RE: How to remove carriage return from row? (Peter Zyczynski) ---------------------------------------------------------------------- Message: 1 Date: Tue, 14 Feb 2006 09:30:33 -0500 From: "D. Peter Berical" <[EMAIL PROTECTED]> Subject: [MI-L] How to remove carriage return from row? To: [email protected] Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=US-ASCII Hello! I have a MapInfo TAB file with a column containing "boxes" for a carriage return. I want to remove the "boxes" and replace them with a ", ". I've tried the Search and Replaces using Chr$(13), but that tool only recognizes text. I can SQL these records using Chr$(13), but removing them is another story. Does anybody have any experience with this? Thanks! Peter ------------------------------ Message: 2 Date: Tue, 14 Feb 2006 09:15:05 -0700 From: Bill Thoen <[EMAIL PROTECTED]> Subject: Re: [MI-L] Ordering of Thematic layers To: James Stott <[EMAIL PROTECTED]> Cc: [email protected] Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=UTF-8; format=flowed I vaguely remember that thematic map layer names look like array elements, but actually must be enclosed in double quotes when referenced in a string. That is, if your parent layer is named 'markets' then your first thematic layer is called "markets(1)", and the double quotes are important. You might check the docs on that to be sure, but I think you'll have to test to see if a layer is thematic and if so, wrap it in quotes inside your command string. As an aside, I also know that if you separate the thematic layer from its parent using the 'set map order' statement, and then go into Layer Control interactively, you'l crash MapInfo good and hard. James Stott wrote: >I am having some trouble with ordering layers in a mapper window using >MapBasic. > >I have some layers that are added to a mapper by pushing a tool button in >MapInfo. The button adds the layers, and then puts them to the bottom layer of >the mapper window as they are base mapping data. > >The code I have written creates a string of the layers that are in the map >window, and then adds the layer i want at the bottom of the mapper window to >the end of this string. I then use Run Command to run this string. For >example, the code looks something like this: > > --------------------------- > >layer = layer i want moved to bottom of mapper window > >Dim tmpCmdStr As String >tmpCmdStr = "Set Map Order " >Dim i As Integer > > For i = 1 To iNoLayers > > If LayerInfo(FrontWindow(), i, LAYER_INFO_NAME) = layer Then > > Else > > tmpCmdStr = tmpCmdStr + LayerInfo(FrontWindow(), i, LAYER_INFO_NAME)+ > "," > > End If > > Next > > tmpCmdStr = tmpCmdStr + layer > > Run Command tmpCmdStr > >--------- > >This works fine until I encounter a thematic layer, and the set map order >command falls over complaining of Unrecognised Command ( , which is when i >gets to the thematic layer. > >Does anyone have any idea as to why this is happening, and how it can be fixed. > > > ------------------------------ Message: 3 Date: Tue, 14 Feb 2006 12:27:15 +0100 From: Peter Horsb?ll M?ller <[EMAIL PROTECTED]> Subject: [MI-L] External dll with variable path To: <[email protected]> Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset="iso-8859-1" Hi, Has anyone ever tried accessing an external dll in a variable location ? I'm building a MapBasic application, that should use a dll placed in Windows\System32. On my computer I know ehere this is, but I guess I can't be sure whether it always will be located in C:\Windows on other computers ? So how do I tell MapBasic to use the dll from the System32 folder ? I can't use this: Declare Function BLAccessFile$ Lib "C:\Windows\System32\BLMarkProvider.dll" Alias "udtraekDb" () As String and this one the compiler doesn't like (APIWindowSystem32Folder$() is my own function returning the location of Windows\System32): Declare Function BLAccessFile$ Lib APIWindowSystem32Folder$() + "BLMarkProvider.dll" Alias "udtraekDb" () As String I also tried it with ApplicationDirectory$() but that didn't work either, so the problem might be the use of a function ??!! and with this one I can't be sure that MapInfo will use the right dll: Declare Function BLAccessFile$ Lib "BLMarkProvider.dll" Alias "udtraekDb" () As String Any ideas ? Peter Horsbרll Mרller GIS Developer, MTM Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis ------------------------------ Message: 4 Date: Tue, 14 Feb 2006 19:54:51 +0100 From: "Uffe Kousgaard" <[EMAIL PROTECTED]> Subject: Re: [MI-L] External dll with variable path To: <[email protected]> Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset="iso-8859-1" Hi Peter, "C:\Windows\System32" or the similar location is always part of the PATH variable in windows, so there is no need to specify where to find the DLL - Windows will take care of it. If there really is a risk that another DLL with the same name exists, one solution may be to copy the DLL from system32 to the same location as the MBX, before calling any functions in the DLL. Only problem could be if mapinfo loads the DLL at the time of the Declare statement, but that can easily be tested. Regards Uffe ----- Original Message ----- From: "Peter Horsbרll Mרller" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, February 14, 2006 12:27 PM Subject: [MI-L] External dll with variable path Hi, Has anyone ever tried accessing an external dll in a variable location ? I'm building a MapBasic application, that should use a dll placed in Windows\System32. On my computer I know ehere this is, but I guess I can't be sure whether it always will be located in C:\Windows on other computers ? So how do I tell MapBasic to use the dll from the System32 folder ? I can't use this: Declare Function BLAccessFile$ Lib "C:\Windows\System32\BLMarkProvider.dll" Alias "udtraekDb" () As String and this one the compiler doesn't like (APIWindowSystem32Folder$() is my own function returning the location of Windows\System32): Declare Function BLAccessFile$ Lib APIWindowSystem32Folder$() + "BLMarkProvider.dll" Alias "udtraekDb" () As String I also tried it with ApplicationDirectory$() but that didn't work either, so the problem might be the use of a function ??!! and with this one I can't be sure that MapInfo will use the right dll: Declare Function BLAccessFile$ Lib "BLMarkProvider.dll" Alias "udtraekDb" () As String Any ideas ? Peter Horsbרll Mרller GIS Developer, MTM Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l ------------------------------ Message: 5 Date: Tue, 14 Feb 2006 15:35:53 -0500 From: [EMAIL PROTECTED] Subject: [MI-L] [Spam] ADV: Get the recognition you deserve ? enter the MapInfo Meridian Awards To: [email protected] Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset="US-ASCII" Are you Location Intelligent? Get the recognition you deserve. Judge and be judged in the 2006 MapInfo Meridian Awards Recognizing the best in location intelligence; the people who are driving business innovation or changing the world with MapInfo software or data solutions. Share your story for prizes and acclaim. Prizes include 30G iPod and all expenses paid trip to MapWorld in Phoenix, AZ. Enter yourself, nominate someone else or vote for the People's Choice awards. Enter now at www.mapinfo.com/meridianawards ------------------------------ Message: 6 Date: Wed, 15 Feb 2006 08:27:05 +1000 From: "Peter Hatton" <[EMAIL PROTECTED]> Subject: [MI-L] MAPINFO EDIT MBX TOOL To: <[email protected]> Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset="iso-8859-1" Hi all, Hoping someone can help me with the following ...... I used to have a Mapinfo editing tool that I acquired from a colleague but no longer have the mbx. Does anyone know where I can download another copy .......... details were as follows - Ersis Gis toolbox 4.0.2 GTB EDIT .MBX This mbx was great and I would like to acquire again ............. Many thanks for your time ...... Regards Peter Peter HATTON GIS Officer Greater Taree City Council 2 Pulteney Street TAREE 2430 phone 02 6592 5227 e-mail [EMAIL PROTECTED] gov.au This email and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed. Greater Taree City Council is a government organisation and is subject to Freedom of Information legislation. You must assume that any material sent to Greater Taree City Council may be accessible by persons other than the intended recipient. The contents of this message may express views and opinions not necessarily shared by Greater Taree City Council. ------------------------------ Message: 7 Date: Tue, 14 Feb 2006 18:17:53 -0600 From: Trey Pattillo <[EMAIL PROTECTED]> Subject: Re: [MI-L] How to remove carriage return from row? To: [email protected] Cc: "D. Peter Berical" <[EMAIL PROTECTED]> Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset="iso-8859-1" try holding down ALT then on number pad do 0013 the "box" are unprintable, often called contol codes, characters and vary depending on the fonts in use. Also a full line stop for window is #13#10 for called CrLf Carriage Return / Line Feed In a hex editor you will see 0D 0A I may be backwards here but unix uses #10 and mac uses #13 and only the single character Try some of the other ALT+#### up to 32 [space] you can get some neat smiles and rude jestures. 32..127 are the ASCII printable characerts 128..255 are the old dos line drawing [boxes] and depending on the font other funky characters -- called the "extended character set" -- Trey Pattillo Failure is not an option.... It comes standard with all Microsoft products. On Tuesday 14 February 2006 08:30, D. Peter Berical wrote: > Hello! I have a MapInfo TAB file with a column containing "boxes" for a > carriage return. I want to remove the "boxes" and replace them with a ", > ". I've tried the Search and Replaces using Chr$(13), but that tool only > recognizes text. I can SQL these records using Chr$(13), but removing them > is another story. Does anybody have any experience with this? > > Thanks! > > Peter > > > _______________________________________________ > MapInfo-L mailing list > [email protected] > http://www.directionsmag.com/mailman/listinfo/mapinfo-l ------------------------------ Message: 8 Date: Wed, 15 Feb 2006 08:47:53 +0800 (BNT) From: [EMAIL PROTECTED] Subject: [MI-L] Selecting intersecting polylines with differen attribute To: [email protected] Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=iso-8859-1 Hi all, Question: how to write a query which selects all intersecting polylines having one different attribute? select * from T1 where (obj intersects obj) and ( z <> z) doesn't work Hymmm.... Thanks & Regards, Kaz Becek ------------------------------ Message: 9 Date: Wed, 15 Feb 2006 09:36:53 +0800 From: "Leigh Bettenay" <[EMAIL PROTECTED]> Subject: [MI-L] Identifying points greater than x metres from ANY point in another table To: <[email protected]> Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset="us-ascii" Can anyone help me with this simple little problem? I have two point coverages and I want to identify all those points in one table that are more than a specified distance from ANY point in the other table. I could do this by buffering one table, then identifying those points inside buffered regions then inverting the selection. However, I suspect there might be a quicker and sneakier way. Any thoughts would be gratefully welcomed. Leigh Bettenay Chief Geologist Sipa Resources Ltd Level 2, 87 Colin St, WEST PERTH WA 6005 Tel: 08 94816259 Fax: 08 9322 3047 Mobile: 04388 17616 Email: [EMAIL PROTECTED] =========================== ------------------------------ Message: 10 Date: Wed, 15 Feb 2006 13:44:39 +1100 From: "Peter Zyczynski" <[EMAIL PROTECTED]> Subject: RE: [MI-L] How to remove carriage return from row? To: "'D. Peter Berical'" <[EMAIL PROTECTED]> Cc: [email protected] Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset="us-ascii" This is only a suggestion, I haven't tried this. What about exporting the Mapinfo tab file to XLS or TXT, and strip them off in there? Then just import back into Mapinfo. Cheers, Peter Zyczynski ------------------------------ _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l End of MapInfo-L Digest, Vol 4, Issue 22 **************************************** --------------------------------------------------------------------------------------------------------------- This message contains information that may be confidential or privileged. If you are not the intended recipient, you may not use, copy or disclose to anyone any of the information in this message. If you have received this message and are not the intended recipient, kindly notify the sender and delete this message from your computer. _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
