RE: SUM: MI-L fetch next is skipping records

2002-06-03 Thread DPC
Ok - it seems that fetch from the MB window simply wasn't going to work out. I guess it didn't like the various commands I issued in between fetches. I ended up using the MB window to instead loop through each row using the rowid, select the record, perform my stuff, then incrementing a rowid al

Re: MI-L fetch next is skipping records

2002-06-03 Thread Eric_Blasenheim
Darrin, My guess is that your problem stems from running the Fetch in the MapBasic Window. When you do this, the "next" that MapBasic processes is a global because you are not running a MapBasic program. For each MapBasic program, each table has it's own current record number that Fetch Next wo

Re: MI-L fetch next is skipping records

2002-06-03 Thread Cameron Crum
I saw this a while back in an Access table. I assumed it was a bug between MB and Access. I use the fetch rec n now and don't have a problem. I don't think you can use this via the MB window though. Hope you find a solution. Cameron Darrin Clement wrote: > Sorry - This is a follow-up to this mo

MI-L fetch next is skipping records

2002-06-03 Thread Darrin Clement
Sorry - This is a follow-up to this morning's question. It turns out that what is actually happening is that the [fetch next] command seems to skip records. It happens on any table I use, no matter what the source. Even an Excel table we created as a test. We have packed the table and also tri

MI-L running an Oracle procedure from MapBasic???

2002-06-03 Thread Norah Mitchell
Hello List, How do I run an Oracle procedure from MapBasic? The code below returns "INVALID SQL STATEMENT": Dim hdbc, hstmt As Integer hdbc = Server_Connect("ODBC", DSN=ORACLE7;DLG=1") hstmt = Server_Execute (hdbc, "EXECUTE PROC1") Server hstmt Close NMitchell

MI-L Collision Conference

2002-06-03 Thread John Haynes
Hi Guys, I'm setting up a booth at the Southeastern Collision Conference, a meeting of law enforcement officials who deal in the investigation and reconstruction of automobile collision sites. While I have a lot of generic GPS, highway structure, aerial photography, etc., etc., I can show, I

MI-L Thanks for the help

2002-06-03 Thread Brian_VanDruten
Thanks to Paul Staub, Jennifer Blek, and Mark Neuhaus for helping me with the DRG clipping question. Sincerely, Brian Van Druten Forestry Technician Alligator River NWR - List hosting provided by Directions Magazine | www.dire

RE: MI-L Clipping the collars off of DRG's

2002-06-03 Thread Scott B. Huntington
Is there a way to make a raster image editable? I've tried saving a copy (didn't work). This would be really handy if it would work. I have LOTS of raster images (quads with collars). I have found a good source of collarless quads. http://www.charttiff.com/ -Original Message- From: B

MI-L opening multiple tables

2002-06-03 Thread Jack Riley
I'm trying to write some MapBasic code to allow a user to open multiple tables. I'd like to get a list of the ones they choose and then rename them. For instance, it they choose roads06037.TAB, I'd like it to show up in the layer control as "Streets". If they also choose water06037, I'd like it t

Re: MI-L Map file protection

2002-06-03 Thread Bill Thoen
ilker wrote: > > are there any way map file protection for illegal coping? A lot of people have been asking for a way to protect map data from being copied illegally, but no one seems to have developed a practical way to do it. There are two approaches that come to mind. One method is to encryp

MI-L Map file protection

2002-06-03 Thread ilker
are there any way map file protection for illegal coping?

MI-L Hospital/GIS References

2002-06-03 Thread Skinner, Ric
Dear Fellow Health Geographics Professionals: I believe there is more going on the hospital community with GIS than is obvious from the scattered references I'm finding on the internet. Therefore, I would like to like to confirm this by compiling a list of publications, poster sessions, presentat

MI-L Map file protection

2002-06-03 Thread ilker
are there any way map file protection for illegal coping?

MI-L two batch processing questions

2002-06-03 Thread Erin Rubio
Darrin, We developed a tool to automate batch map production, zooming to each object in a table (such as ZIP codes) in turn, creating a .wor and optionally printing and creating digital output. You can specify a column (such as ZIP) for the title of each layout. (Single layout created for each .w

MI-L two batch processing questions

2002-06-03 Thread DPC
Hello, 1) We're trying to automate a mapping job that runs through several maps using a table of ZIP codes on which to center each successive map. Since we don't have MapBasic, we're using the "Fetch First, Fetch Next" workaround to loop through records in the MapBasic window. (This was a grea

Fw: MI-L RE: Selecting text objects

2002-06-03 Thread David M Haycraft
Dear Listers If you're a Mapinfo Pro user and you want to Select some rows of a table, not by values in the text fields, but by the Drawing Style of the objects in the Obj field, then it's a real chore. Select-by-Drawing-Style (SDS.MBX) is a free Mapbasic tool that lets you perform this task thr

Re: MI-L A program from Australia

2002-06-03 Thread Caroline Hilton
Hi Andre You could be after the program known as "Discover", by a company called Encom in Sydney. It does the things you say, plus loads more. For info and your local reseller see www.encom.com.au, or contact [EMAIL PROTECTED] hope this helps Caroline .. Pelican G

MI-L RE: Selecting text objects

2002-06-03 Thread Brorsen, Gert
Do a search for SDS.MBX, should be easy to find and very useful. > -Original Message- > From: Ron Gutiw [mailto:[EMAIL PROTECTED]] > Sent: Saturday, 1 June 2002 02:09 > To: MapInfo-L (E-mail) > Subject: Selecting text objects > > > Listers: > Is there a way to select all TEXT ONLY objec