RE: MI MB: Run Command Limitation
There certainly used to be a length limit for the select statement used by ODBC too. - David Booth Senior GIS Officer Merseyside Information Service -Original Message- From: Jacques Paris [SMTP:[EMAIL PROTECTED]] Sent: 21 September 2000 16:18 To: Mike Taylor; 'Mapinfo List' Subject: RE: MI MB: Run Command Limitation I have written the most sophisticated program of all : dim a,b as string onerror goto crash a="" boucle: a=a+"A" b="print "+""""+a+"""" print len(b) run command b goto boucle goto fin crash: print "error "+err() fin: end program and it gets stuck on a command at 508 characters (error 965, expression too complex). The run command accepts thus a string of 507characters. That would be 512 - 5 (let us assume that it is some code id). Aren't they other places in MI where the 512 character limit is imposed? Don't I remember something of the sort with the "where" clause of the SQL requester? Jacques PARIS e-mail[EMAIL PROTECTED] For MapInfo support, see the Paris PC Consult enr. site at http://www.total.net/~rparis/gisproducts.htm -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike Taylor Sent: September 21, 2000 1:04 AM To: 'Mapinfo List' Subject: RE: MI MB: Run Command Limitation Hi again Seems I spat the dummy at the wrong statement. I changed the string (from select to print) that I was sending to run command. eg, From: qs = "select ... lots of stuff ... from table into anothertable" run command qs To: qs = "print ""select ... lots of stuff ... from table into anothertable""" run command qs This worked fine, so I will change my question to why is this happening with select?? The amount of characters seems to be variable as well depending on the expression? I've attached a program which will generate the problem on my machine. -Original Message- From: Mike Taylor [mailto:[EMAIL PROTECTED]] Sent: Thursday, 21 September 2000 15:20 To: 'Mapinfo List' Subject: MI MB: Run Command Limitation Hi I seem to have run into a size limitation on the string you can pass to run command. It works when I trim the string down to 421 characters and fails (badly, invalid page fault) when it is 422 characters. The command also fails when I put it into the mapbasic window of professional. Is there any workaround for this? Why is 422 the magic number? -- 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] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI MB: Creating and Committing tables (Urgent!)
Hi Chris, It's nothing to do with the actual file names having spaces in them (interpreted by Mapinfo as underscores), is it? For example long file name.tab would get opened in MapInfo as long_file_name The other possibility is if there was a table with that name and somehow only some of its component files got deleted (eg no .tab, but .dat and .id files still present). - David Booth Senior GIS Officer Merseyside Information Service -Original Message- From: Martin, Christopher (WSA Telford) [SMTP:[EMAIL PROTECTED]] Sent: 22 September 2000 10:04 To: '[EMAIL PROTECTED]' Subject: MI MB: Creating and Committing tables (Urgent!) I've got some code which takes in some data, does some calculations and then produces a host of other tables... e.g. Select NISLID, R_FLOW, RDNAME, FLOW, FLOW / R_FLOW "Stress_All" from x2010dm_TR where Flow_Category = 3 into x2010dm_TR_100plus Commit Table x2010dm_TR_100plus As "working\96-10dm\x2010dm_TR_100plus.TAB" TYPE NATIVE Charset "WindowsLatin1" When I run this code, I get an error at the Commit Table line: 'File "x2101dm_TR_100plus.TAB" does not exist. Unable to create table.' Old versions of this table exist but aren't read-only or anything. However, I tried deleting them, but still got the same error message... Any thoughts? Chris Martin GIS Consultant WS Atkins Consultants Ltd (01952) 201234 -- 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]
RE: MI text objects
You can use update column to populate your column with objectinfo(obj,3). The mapbasic would be something like Update table Set columnname = objectinfo(obj,3) - you'd probably have to be sure that all the objects are text before hand, though. - David Booth Senior GIS Officer Merseyside Information Service -Original Message- From: Peggy Corey [SMTP:[EMAIL PROTECTED]] Sent: 19 September 2000 14:49 To: [EMAIL PROTECTED] Subject: MI text objects Hello all! Is there a way to extract the text from text objects, and stick them in a table? TIA Peggy Corey GIS Techinician City of Fort Wayne 427-2646 -- 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]
RE: MI Count Points in Polys
Hi Jonathan, If you mean the number of vertices in a polygon, then select the poly and use objectinfo(selection.obj,20) or use OBJ_INFO_NPNTSinstead of 20 if you are using mapbasic.def. If you mean something else, then apologies for barking up the wrong tree - it's Friday after all! - David Booth Senior GIS Officer Merseyside Information Service -Original Message- From: Stokes Jonathan [SMTP:[EMAIL PROTECTED]] Sent: 15 September 2000 14:04 To: MapInfo-L (E-mail 2) Subject: MI Count Points in Polys hey all happy Friday to those of you who are up and roughly in that diurnal frame of reference. just a quickie. Does anyone know how I could get a count of the number of points in a polygon (2 different tables.). am having a go myself but the old grey matter is not working all that well. TIA Jonathan Jonathan Stokes GIS Analyst Mail: [EMAIL PROTECTED] Web: www.geoplan.com Phone: +44 (0) 1423 722715 Fax: +44 (0) 1423 525545 Yellow Marketing Information Limited 14-15 Regent Parade Harrogate North Yorkshire HG1 5AW UK Confidentiality: This e-mail and its attachments are intended for the above named only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please contact the sender immediately and delete the email. Security: Please note that Internet e-mail is not a 100% secure communications medium. We advise that you understand and observe this lack of security when e-mailing us. Viruses: We have taken steps to ensure that this e-mail and attachments are free from any virus, we advise that in keeping with good practice the recipient should make a further virus check. The Company: Neither Yellow: Marketing Information Limited, nor any of the associated divisions accepts responsibility for the contents of this message. Any views or opinions contained in this email are solely those of the author unless expressly stated otherwise. -- 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]
RE: MI RE: grabber tool problem
Yes - snap - turn snap off and the problem is fixed. You can turn it back on again until it next happens. - another unnatural, involuntary finger movement for regular digitizers! - David Booth Senior GIS Officer Merseyside Information Service -Original Message- From: Ian Macey [SMTP:[EMAIL PROTECTED]] Sent: 13 September 2000 16:23 To: 'Robert Brough' Cc: MI List (E-mail) Subject: MI RE: grabber tool problem Hi I have found that this tends to occur when the snap feature is turned on. By turning the snap feature off you are then able to pan around the window as normal. -Original Message- From: Robert Brough [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 13, 2000 4:14 PM To: [EMAIL PROTECTED] Subject: MI: grabber tool problem Dear listers, We are using MapInfo 6.0 and since version 5.5. we have noticed that occasionally the grabber tool stops working when trying to move maps in the map window (this never seems to occur in the layout window). It occurs when using both vector and raster maps. I have looked in the message archive but can't find any postings from anybody with a similar problem. Does anybody have any idea why this may be, or has anybody noticed the same thing? Thanks Robert Brough The National Trust (In Cornwall) e-mail: [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] -- 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]
RE: MI MB reading binary data
You might be able to use the unix command dd with the argument conv=swab to byte-swap the file before copying to NT - it used to work with Landsat data off reel to reel tapes read by HP-UX about ten years ago! - David Booth Senior GIS Officer Merseyside Information Service -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: 13 September 2000 19:26 To: [EMAIL PROTECTED] Subject: MI MB reading binary data Mappers, Using mb code, under NT, I'm trying to read binary data that was created on a UNIX machine which writes the data most significant byte first. My mb code wants to read binary data as least significant byte first. Anyone know how to work around this short of writing a byte exchanger? Does MapBasic have a patch or something available? Thanks, SI -- 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]
RE: MI Converting Non-Earth N E to a proper Projection N E
Hi Steve, The way to fix this problem is to export your non-earth table to mif/mid, which preserves the coordinate values. Edit the header of the mif file and replace the coordsys... line with the correct one for your projection, then re-import the table. As you've found, using Save As with the correct projection doesn't work in the case of NEM tables. Hope you haven't got too many to do - I ended up automating the procedure in mapbasic after the first few hundred tables! - David Booth Senior GIS Officer Merseyside Information Service -Original Message- From: Steve McCrone [SMTP:[EMAIL PROTECTED]] Sent: 04 September 2000 08:12 To: [EMAIL PROTECTED] Subject: MI Converting Non-Earth N E to a proper Projection N E Hello Mappers: I have some vector (say polylines) data that was saved using: Non-Earth m, Bounds -10, -10, 10, 100. This was done since the PRJ file did not contain the appropriate projection parameters. The coordinates of the nodes of the plines are grid coordinates in the Rectified Skew Orthomorphic (RSO) projection. Therefore, when the user clicks the mouse on a feature, the correct E N is displayed. The appropriate RSO projection parameters have been added to the PRJ file and now I wish to convert all of the existing data (in Non-Earth) to RSO. When I simply change the projection to RSO the data gets all messed up. I am able to write some Map Basic code that programmatically extracts the E N from each node and stores them into an ASCII file. I then import these coordinates into MI and generate lines from the points. I also could write some MB code to create the new tables. Is there a simpler way of doing this? Perhaps without getting into MB programming at all. I am working in MapInfo 5.0 and MapBasic 4.1.2. Thanks -- 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 6.0 Page Setup
Hi there, Can anyone confirm that MapInfo 6.0 reverts to the windows default printer and paper size (or the preferred printer set up under the options menu) for each new layout opened, irrespective of changes made using the page setup menu? If anyone has a fix (other than going back to 5.5), I'd be very happy to hear it, as I have quite a few applications that rely on the user using page setup to set a non-standard paper size before making and printing multiple layouts. - David Booth Senior GIS Officer Merseyside Information Service -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
