Miles,
Try
Update Untitled Set xy =str$(x) + str$(y)
where xy is a Char data type
OR
Update Untitled Set xy = (x * 100) + y
where xy is a float data type.
Regards,
David
Miles Da Costa [EMAIL PROTECTED] 20/08/2003 04:38:17
hello,
I have 2 integer columns that hold x and y
Lars,
i dont think you can, even if you use the Execute Process Task within
the DTS, anything that runs under the SQL scheduler does not interact
with the desktop, i.e. so the mapinfow.exe will run as a process but you
will not see anything.
Also if you have SQL installed on a server, the
There is always the gis news group at the following location.
http://groups.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8group=comp.infos
ystems.gis
There is also an Applied GIS + Remote Sensing mailing list started recently,
which I can't give you the details of as I've just deleted all my old
Micheal,
we have been experiencing simialr problems too after upgrading to MU7 on
Windows 2K, on brand new Compaq w4000 workstations. All other software
works much quicker on these machines, as expected, apart from MI7. The
slowest operations seem to be opening map or browser windows. For
HI Dave,
I have similar problems when running a workspace under a scheduler too.
The workspace effectively does the same as your script. (Dave is your script
an MBX or a workspace?) It opens, then updates a linked SQL server data-only
table. Then opens a table with graphics and joins it too the
Michael,
what Paul suggested will work,
a way of doing this if you are not too famialiar with mapbasic is to set
the projection of the map window to something other then BNG then set it
back to BNG once more using the map options dialog.
To change the projection of the map go to Map Options,
I would disagree, if you do the SQL select in MapInfo then it will do it
on your workstation and not use any of the Oracle resources, including
indexes.
To speed the query up you would need to write an mbx that sent a SQL
statement to the Oracle server, where the query can be made and the
In short: I guess there is still room for improvement !!
Sorry to hear this is still true, I haven't used Oracle with MI for a
few months now, but like to follow the threads on their relationship to
see if things have improved.
With regard to Oracle views there is a work around for this, I
Soren,
I have experienced/discovered this too in the past, and have reported it
to MapInfo, they say it is due to the way that MI handles one to many
relations (sorry cant find the correspondence), but I think its just a
bug in the info tool!! or at least a design feature they need to sort
out.
Keith,
how are you running the MBX, by double clicking the mbx file itself or
through MI, and run MapBasic Program?
If you are doing it the former way then there may be due to the settings
in the OS for associations for mbx's. See the posts from earlier
(October) on MapInfo-L, entitled
Hi List,
does anyone have a good knowledge of how MI handles large raster files
that are located on a network server and that are opened on client
workstations.
Basically I am trying to get an idea of the network traffic involved and
also the load on the memory of the client PC based on redraws
Bill,
You will need to select from the SYSOBJECTS table the names where the
xtype is U, for user-defined. This avoids all the system tables that are
present in each database too.
the general form of the query you need is simply :-
Select cast(name as varchar(100)) From 'sysobjects' where xtype
[EMAIL PROTECTED]
- Original Message -
From: David Andrews [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 05, 2001 05:40
Subject: MI-L Duplicate running of a MBX
Hi list,
Does anyone else experinced this?
If you run a mbx by double clicking the application itself from
Hi list,
Does anyone else experinced this?
If you run a mbx by double clicking the application itself from within
explorer or as an icon on the desktop, i.e. the actual mbx file, then
MapInfo starts up and the mbx is executed twice.
If the mbx is run any other way, i.e from within MapInfo, or
[EMAIL PROTECTED] Til:David
Andrews [EMAIL PROTECTED],
Sendt af:
[EMAIL PROTECTED]
[EMAIL PROTECTED]cc
I spoke to soon,
Adding -noexec seems to have fixed it on my machine, NT 4 running MI
6.0, but not on a colleagues a Win 98 machine running MI 6.5. The
problem happens with both mbx's and tab files also.
Hmm...
Steve,
simply use the Search and Replace tool. Goto Tools Tool Manager and
look for Search and Replace.
It will now be on the Tools menu. select it to run the app.
Select the table and the column then enter the text to search for and
replace it with an empty string.
Dave
Morrier, Steve
I wouldn't split the regions into single tables , but simply make
queries for each and save them As Query tables. This will then allow
you to keep the original table intact also and any edits will be
reflected back into that table.
As for writing a very simple one off MapBasic app, open the
Mark,
simply add 2 new columns, one called eastings another called row_order
(or whatever you want) to your table.
Then issue the following mapbasic commands.
Update table Set eastings = centroidx(obj)
Select * from Primary_Roads order by eastings into sorted_table
Update sorted_table set
I dont know for sure but I believe you can put any mapbasic statements
in the Tab file as long as they are before the metadata definitions.
Jacques Paris [EMAIL PROTECTED] 08/17 3:18 pm
I am looking for the specifications of the .TAB file, and particularly
to
the statements that could be
Lan-wei,
the file mapinfo.prj under your MapInfo installation directory contains
all of the geodetic parameters used for ellipsoids and projections in
MapInfo. It can be viewed with any text editor.
Read the appendix on projections in the MapInfo manual to get an
explanation of the elliposoidal
Karl,
try this.
Select * From {region table} where Obj Intersects Any (Select Obj From
Selection)
of course replace {region table} with the name of the your polygon
table.
Dave
P.S. Look on the http://www.spatialplus.com/tipsbody.htm website for
this other helpful tips.
Karl Kliparchuk
Try downloading Link Plus from http://www.spatialplus.com/prodbody.htm
You can link to as many file types as you like with this.
David
Eagle, David A [EMAIL PROTECTED] 08/07 3:21 pm
Listers,
Using the Hotlink tool is it possible to launch more than one document
or
media item at the same
Jacqui,
Or if you are not sure of the MapBasic Command, once a mapper is open in
MapInfo goto the menu bar and select MAPOPTIONS then PROJECTION in the
dialog box. If the projection is currently BNG then change the projection to
anything else. Select OK and close the dialog. Then do it again
it a little clearer.
David
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of DORIER
Herve
Sent: 22 May 2001 07:11
To: David Andrews; Anitra Robertson; MapInfo Users
Subject: RE: MI-L GIS Oracle Login Issue
Hi !
I'm not sure that I understand your problem
Anitra,
I know your frustration have experienced the same problem. Its not really
your contractors fault though.
This is a fault in the MapInfo/Oracle implementation and one of the many
things that MapInfo have not thought about or tested in its connection to
Oracle. I assume that they thought
I have experienced the same thing.
MapInfo say its because MI cant handle one to many relationships.
But its fine in the resulting query browser.
I think that its a bug in the info tool.
Dave Andrews
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
Hi list,
we are in the process of implementing a fairly large GIS within a Oracle 8i
Spatial and MapInfo environment on Windows NT.
We have begun the design of the database structure, including normalised
tables, lookups, and use of views, etc. and whilst testing out some issues I
attempted to
28 matches
Mail list logo