Greeting fellow Smallworld gurus;

    Has anyone tried to add new tables after the external database
connection?

    According to the Smallworld help, we can add the external database's
table to be accessed into a rope and then send the connection properties
(like data source, user name, password, table rope etc) to the extdb
user.
However, if I want to add in more tables later (i.e after the external
database connection), I must disconnect the previous database connection
and re-establish the connection again with the addition of the new
tables.

    Is there a better way of adding the new tables without disconnect and
reconnect the database connection again?

    Thanks for any comment or guidance.

    Best regards.

Greeting;

    If anyone interested to work in Asia Pacific, please
contact me at the following address, together with your
resume:

    frankie_annie@...

    Thanks.

Hi Frankie,

try to use method
extdb_user.open_collection (name,view)

I have tried it and it works fine.

Best regards
Jiri Horacek
----- Original Message -----
From: <frankie_annie@...>
To: <sw-gis@egroups.com>
Sent: Saturday, October 02, 1999 5:08 PM
Subject: [sw-gis-dev] Connection to External Database


> Greeting fellow Smallworld gurus;
>
>    Has anyone tried to add new tables after the external database
> connection?
>
>    According to the Smallworld help, we can add the external database's
> table to be accessed into a rope and then send the connection properties
> (like data source, user name, password, table rope etc) to the extdb
> user.
> However, if I want to add in more tables later (i.e after the external
> database connection), I must disconnect the previous database connection
> and re-establish the connection again with the addition of the new
> tables.
>
>    Is there a better way of adding the new tables without disconnect and
> reconnect the database connection again?
>
>    Thanks for any comment or guidance.
>
>    Best regards.
>
>
>
>
> ------------------------------------------------------------------------
> MyPoints-Free Rewards When You're Online.
> Start with up to 150 Points for joining!
> http://clickhere.egroups.com/click/805
>
>
> eGroups.com home: http://www.egroups.com/group/sw-gis
> http://www.egroups.com - Simplifying group communications
>
>
>

As long as you keep the handle to the connection, it's easy ...

_global oracle_connection << _unset
$
_global connect_to_oracle <<
	 _proc (_optional data_source)
		 _global my_spec, oracle_connection

		 data_src << data_source.default("access_framme")

		 my_spec << extdb_user.connect_template(
				    :dbtype, :odbc,
				    :connect_name, "access_framme",
				    :server, :odbc,
				    :dbusername, "",
				    :dbpassword, "",
				    :data_source, data_src,
				    :program_name, "swodbc",
				    :no_primary_key_validation, _true,
				    :command, rope.new_with("swodbc.exe")
				       )
		 oracle_connection << extdb_user.new(my_spec)
		 v << gis_program_manager.cached_dataset(:oracle)
		 v.switch(:write)
		 v.add_external_database(oracle_connection)

		 >> oracle_connection

	 _endproc
$
... then you run connect_to_oracle() ...

... and then when you need to ...

oracle_connection.open_collection("an_oracle_table",v)
$

... and it will add the new collection in without having to reconnect ...
Cheers,

Simon

Hello All,

I want to add a button to the popup menu on the gis - only when the current
geometryn is a certain object eg, substation.
How do I go about doing it?

Thanks
Corne

Hi.. Corne

U can customize core_defaults.magik file.
U can find that file in Smallworld product or using class browser..
After compile customized, u must restart graphics_system.
You can restart Main Graphics System by using ACE Menu [select] function, and
save new imgae..

Have a nice day..!

-----Original Message-----
From: corne@... [mailto:corne@...]
Sent: Wednesday, October 06, 1999 7:26 PM
To: sw-gis@egroups.com
Subject: [sw-gis-dev] updating the popup menu in the graphics system




Hello All,

I want to add a button to the popup menu on the gis - only when the current
geometryn is a certain object eg, substation.
How do I go about doing it?

Thanks
Corne



------------------------------------------------------------------------
Join theglobe.com the premiere online community! Take advantage of
FREE homepages, Stock quotes, News, Chat, Games and more! Interact
with people just like you! http://clickhere.egroups.com/click/1042


eGroups.com home: http://www.egroups.com/group/sw-gis
http://www.egroups.com - Simplifying group communications

Excruciatingly painful, I think. I cooked up a Dynamic Menus component some
time ago that would change out the right mouse menu. They key was to get all
the possible menus cached in shared variable, create the popup as dependent
of graphics_view, then swap the menu when things changed. The code is rather
involved, but the that is the gist of the design.

-----Original Message-----
From: corne@... [mailto:corne@...]
Sent: Wednesday, October 06, 1999 4:26 AM
To: sw-gis@egroups.com
Subject: [sw-gis-dev] updating the popup menu in the graphics system




Hello All,

I want to add a button to the popup menu on the gis - only when the current
geometryn is a certain object eg, substation.
How do I go about doing it?

Thanks
Corne



------------------------------------------------------------------------
Join theglobe.com the premiere online community! Take advantage of
FREE homepages, Stock quotes, News, Chat, Games and more! Interact
with people just like you! http://clickhere.egroups.com/click/1042


eGroups.com home: http://www.egroups.com/group/sw-gis
http://www.egroups.com - Simplifying group communications

Hi,
   We have a class called selection_monitor that is dependent on the
graphics system. When an object is selected or deselected in the grs, a
method called select_activity or deselect_activity is called on the
object which performs the appropriate action (if any). In your case, if
substation is selected/deselected you would want to modify the popup
menu.
   I would be happy to share the code with you if you're interested.

Hope this answers your question. I wasn't sure if your question
centered on modifying the popup menu or capturing the select/deselect
activity.

Fred


corn-@... wrote:
original article:http://www.egroups.com/group/sw-gis/?start=885
>
>
> Hello All,
>
> I want to add a button to the popup menu on the gis - only when the
current
> geometryn is a certain object eg, substation.
> How do I go about doing it?
>
> Thanks
> Corne
>
>

Greeting;

    I have similar nature of exercise before, what I did was creating a
shared
constant that dedicated in controllng the type of buttons or gui layout
to
create. Next I create the dynamic menu collection depending on the
graphic system; when an action is fired, an event is trirgered to check
the action type, if the action matched the event crtiteria, add on top
of this shared constant and reactivate the menu again (on this
reactivate method, I sill
think it got to be better way of refreshing the menu, perhaps someone
can
suggest).

   Hope this is useful to you.

   Best regards..


corn-@... wrote:
original article:http://www.egroups.com/group/sw-gis/?start=885
>
>
> Hello All,
>
> I want to add a button to the popup menu on the gis - only when the
current
> geometryn is a certain object eg, substation.
> How do I go about doing it?
>
> Thanks
> Corne
>
>

Greeting;

     I have similar nature of exercise before, what I did was creating a shared
constant that dedicated in controllng the type of buttons or gui layout to
create. Next I create the
dynamic menu collection depending on the graphic system; when an action is
fired, an
event is trirgered to check the action type, if the action matched the event
crtiteria,
add on top of this shared constant and reactivate the menu again (on this
reactivate
method, I sill think it got to be better way of refreshing the menu, perhaps
someone
can suggest).

   Hope this is useful to you.

   Best regards..



corne@... wrote:

> Hello All,
>
> I want to add a button to the popup menu on the gis - only when the current
> geometryn is a certain object eg, substation.
> How do I go about doing it?
>
> Thanks
> Corne
>
> ------------------------------------------------------------------------
> Join theglobe.com the premiere online community! Take advantage of
> FREE homepages, Stock quotes, News, Chat, Games and more! Interact
> with people just like you! http://clickhere.egroups.com/click/1042
>
> eGroups.com home: http://www.egroups.com/group/sw-gis
> http://www.egroups.com - Simplifying group communications

Hi friends!!!

I want to know what is the protocol(like :select, :refresh, etc) which is
activated when a user draws trail en the main graphics windows.

I saw the query_trail_menu (in the core of Smallworld's product) they
use this:

_pragma(classify_level=restricted, topic={graphics_interaction})
_method my_trail_menu.note_change(drawing,what,_gather info)

	 ## Dependency mechanism, recognised protocols are :reset,
	 ## :trail and :trail_display_coordinate_system which all
	 ## cause the trail-list to be redisplayed.

	 _if what _is :reset _orif
	     what _is :trail _orif
	     what _is :trail_display_coordinate_system _orif
	     what _is :units_changed

         _then
            ....more code

But, when I change then name of this program("my_trail_menu"), it doesn't
works, ¿what is drawing in this case?.

Thanks a lot!!!






______________________________________________________

Greeting;

    Are you saying the addition or amendment of the trail did not pick up
and reflect in the list? If yes, you can try either of the following
suggestion (both in the note change method):

      a.  If the drawing is graphics_system  and what is refreshed, then
          refresh. Here I am suuming that each time a trail is changed or
          added, user will physically do a refresh.

      b.  If the state message is "Enter Geometry", then if the drawing
is
          graphics_system, what is state and info is logical_mouse, then
          refresh the list. Here I am assuming no need for user to
physically
          do a refresh. But this method might involved unnecessary
resources.

     Hope this help.



"von pannk" <marengle-@...> wrote:
original article:http://www.egroups.com/group/sw-gis/?start=891
>
> Hi friends!!!
>
> I want to know what is the protocol(like :select, :refresh, etc)
which is
> activated when a user draws trail en the main graphics windows.
>
> I saw the query_trail_menu (in the core of Smallworld's product) they
> use this:
>
> _pragma(classify_level=restricted, topic={graphics_interaction})
> _method my_trail_menu.note_change(drawing,what,_gather info)
>
>  ## Dependency mechanism, recognised protocols are :reset,
>  ## :trail and :trail_display_coordinate_system which all
>  ## cause the trail-list to be redisplayed.
>
>  _if what _is :reset _orif
> 	    what _is :trail _orif
> 	    what _is :trail_display_coordinate_system _orif
> 	    what _is :units_changed
>
>         _then
>            ....more code
>
> But, when I change then name of this program("my_trail_menu"), it
doesn't
> works, ¿what is drawing in this case?.
>
> Thanks a lot!!!
>
>
>
>
>
>
> ______________________________________________________

Greeting;

    You can incorporate the owner_draw_list_view in the activate_in
method, example :

       .menu_items[:select1]<< owner_draw_list_view.new( _self, f,
					 :rwo_list,
					 :|set_rwo_index()|,
                                         :|description|,_unset,
                                         _unset,:many)

            where RWO_LIST is a rope of parent and children list

    So when any of this node is clicked, set_rwo_index will perform
the following:

    _method optical_fibre.set_rwo_index(index_vec, _optional modifier)
            ##
            ## Callback from list_view mouse click, selects rwo(s)
	    ## from INDEX_VEC. Modifier may be doubleclick, event is
            ## activate the corresponding record editor
            ##

  	    .selection << index_vec

	    _if modifier _is :double_click _andif
                .selection1.size _is 1 _then
                   _self.activate_editor|()|
	    _elif modifier _is :expand_or_compress _andif
                .selection1.size _is 1
	    _then
                _protect
	            _self.busy? << _true
  	            _self.expand_or_compress_branch(.selection[1])
                _protection
                    _self.busy?<< _false
                _endprotect
	   _endif

_endmethod

    Hope this help.

"suhyun moon" <syds9703-@...> wrote:
original article:http://www.egroups.com/group/sw-gis/?start=892
> Hello Everyone
>
> I want to know how to use  alternative_tree  method
>
> >> method alternative_tree(alt_tree, optional exclusion_set) in
ds_version_view
>
> and...
>
> How to manage alternative list..??
>
> Regards..
> -------------------------------------
> Email    :  syds97034@...
> Samyand data system inc.
> GIS dept.

Greeting Smallworld Gurus;

    Have anyone try to link your Smallworld database with external
Smallworld database that located in different locations (distributed
via the WAN)?

    I know manage soc allows one to distribute database across, however
there are few concerns that I would like to seek your opinion and
suggestions:

    a.  Each external Smallworld database has its related styles,
        priority...etc. After linking up the external database, I
        have to copy each of this external style.ds into my database
        in order for me to see the geometry with already assigned
        styles. Without this, I basically have to redefine the styles
        for all this external database. Is there anywhere to escape
        from this trouble?

    b.  After linked with all the external Smallworld database, I tried
        to build a relationship with this external tables. If I am
        not mistaken, the current version of Smallworld does not allow
        building table relationship via the distributed databases. So
        I have to copy the whole external tables into our database (also
        the spatial scanner do not have the across database scan
        facilities). Copying tables definitely is not a way of solving
        this tables relationship requirement, wondering any better
approach
        of doing this?

   Any comments or suggestions are greatly appreciated.

   Thanks and best regards.

> Hi friends!!!
>
> I want to know what is the protocol(like :select, :refresh,
> etc) which is
> activated when a user draws trail en the main graphics windows.

I'd just add a write statement to see what is actually happening:

> _pragma(classify_level=restricted, topic={graphics_interaction})
> _method my_trail_menu.note_change(drawing,what,_gather info)
>
>  ## Dependency mechanism, recognised protocols are :reset,
>  ## :trail and :trail_display_coordinate_system which all
>  ## cause the trail-list to be redisplayed.
       write(" my_trail_menu.note_change( ", drawing,what, info)
   _endmethod

HTH,

Kirmo Uusitalo

Hi, the problem is (at least in version 2.2(1)), that
the method

_method graphics_system.changed_geometry(_gather args)

	 ## Change protocol called to notify the sub-menus which are
	 ## dependent on changes of trail

	 _for m _over _self.dependents()
	 _loop
		 _if m.is_class_of?(geometry_panel) _orif
		     m.is_class_of?(query_trail_menu)
		 _then m.note_change(_self,_scatter args)
		 _endif
	 _endloop

_endmethod
$

hardwires the names of menus which are eligible to
receive these messages, so your custom menu won't work...

Bye, Robert


Von Pannk a écrit:
>
> Hi friends!!!
>
> I want to know what is the protocol(like :select, :refresh, etc) which is
> activated when a user draws trail en the main graphics windows.
>
> I saw the query_trail_menu (in the core of Smallworld's product) they
> use this:
>
> _pragma(classify_level=restricted, topic={graphics_interaction})
> _method my_trail_menu.note_change(drawing,what,_gather info)
>
>         ## Dependency mechanism, recognised protocols are :reset,
>         ## :trail and :trail_display_coordinate_system which all
>         ## cause the trail-list to be redisplayed.
>
>         _if what _is :reset _orif
>             what _is :trail _orif
>             what _is :trail_display_coordinate_system _orif
>             what _is :units_changed
>
>         _then
>            ....more code
>
> But, when I change then name of this program("my_trail_menu"), it doesn't
> works, ¿what is drawing in this case?.
>
> Thanks a lot!!!
>

Yes, Robert is correct. We ran into this same problem (darn difficult
to find). I just overwrote this method adding our custom menu to the if
statement.

Fred

robert.schweiker-@... (robert schweikert) wrote:
original article:http://www.egroups.com/group/sw-gis/?start=897
> Hi, the problem is (at least in version 2.2(1)), that
> the method
>
> _method graphics_system.changed_geometry(_gather args)
>
>  ## Change protocol called to notify the sub-menus which are
>  ## dependent on changes of trail
>
>  _for m _over _self.dependents()
>  _loop
> 	 _if m.is_class_of?(geometry_panel) _orif
> 		    m.is_class_of?(query_trail_menu)
> 	 _then m.note_change(_self,_scatter args)
> 	 _endif
>  _endloop
>
> _endmethod
> $
>
> hardwires the names of menus which are eligible to
> receive these messages, so your custom menu won't work...
>
> Bye, Robert
>
>
> Von Pannk a écrit:
> >
> > Hi friends!!!
> >
> > I want to know what is the protocol(like :select, :refresh, etc)
which is
> > activated when a user draws trail en the main graphics windows.
> >
> > I saw the query_trail_menu (in the core of Smallworld's product)
they
> > use this:
> >
> > _pragma(classify_level=restricted, topic={graphics_interaction})
> > _method my_trail_menu.note_change(drawing,what,_gather info)
> >
> >         ## Dependency mechanism, recognised protocols are :reset,
> >         ## :trail and :trail_display_coordinate_system which all
> >         ## cause the trail-list to be redisplayed.
> >
> >         _if what _is :reset _orif
> >             what _is :trail _orif
> >             what _is :trail_display_coordinate_system _orif
> >             what _is :units_changed
> >
> >         _then
> >            ....more code
> >
> > But, when I change then name of this program("my_trail_menu"), it
doesn't
> > works, ¿what is drawing in this case?.
> >
> > Thanks a lot!!!
> >

The method ds_version_view.alternative_tree() will return an object_tree
type object to be displayed in an owner_draw_list_view

Use it like this:


new_tree << a_view.alternative_tree(alternative_tree)


The argument is an exemplar of any class of alternative_tree object, which
is just a a specific subclass of object_tree. You can then use the new_tree
that is returned in an owner_draw_list_view (similiar to the Object
Control's vhs_tree display). Be warned that the method
ds_version_view.alternative_tree() can take a "Loooooooong" time  to
complete if you have a large number of alternatives in the view.

-----Original Message-----
From: Suhyun Moon [mailto:syds97034@...]
Sent: Wednesday, October 06, 1999 7:19 PM
To: sw-gis
Subject: [sw-gis-dev] how to use alternative_tree ??


Hello Everyone

I want to know how to use  alternative_tree  method

>> method alternative_tree(alt_tree, optional exclusion_set) in
ds_version_view

and...

How to manage alternative list..??

Regards..
-------------------------------------
Email    :  syds97034@... <mailto:syds97034@...>
Samyand data system inc.
GIS dept.
--------------------------------------

   _____

  <http://clickhere.egroups.com/click/718>
  click here <http://clickhere.egroups.com/img/000718/small.gif>

Click Here!
eGroups.com home: http://www.egroups.com/group/sw-gis
<http://www.egroups.com/group/sw-gis>
www.egroups.com <http://www.egroups.com>  - Simplifying group communications

Hello sw-gis list,
This question relates to the model_object_editor class!, What a mess!

Anyway once I have found my way around these sorting the CFG files and adding
those awfull little unit items, (these are surely back to front? add value then
set the unit  Ooops its changed!).

How do I add a button?

Thanks in advance,

The Sneak!


----------------------------------------------------------
               "like Hotmail but faster and a lot better"
   Carol Vorderman, The Mirror, writing about http://www.funmail.co.uk

How can I create a field with that ensures that duplicate values are not
inserted into the database?

The main problem is during posting/merging if two users create records which
contains a field which is unique (within each alternative) - but during a
merge operation the two clash. How can this be detected or resolved
efficiently?

Met vriendelijke groet
Colin Mackay
EDS Utility Competence Centre,
Leeuwarden, Nederland
> * colin.mackay@...
>
>

We are trying to find out using Smallworld if a file is currently in use by
somebody.

The following methods are available in Smallworld :
system.file_writable?(filename) and system.access(filename, mode)

If we do the following while a file is being accessed by somebody :
system.file_writable?("c:\Project Register.xls") or
system.access("c:\Project Register.xls", 2) (2 = writable) the result
should be _false but it is not.  Whether the file is being accessed (in
use) or not, the results always is _true.

Is there any way of checking if a file is in use?

Anybody knows of a fast way to migrate a simple_chain
without manifold into a chain with manifold ?

When I change the geometry info in the Case, the change
doesn't show up in the "Field Modifications" dialog, so
no way of editing a conversion method.

A plain apply just deletes the existing simple_chains:
not exactly what I want.

A scenario like
	 add a second geometry field for the chain
	 apply
	 copy all simple_chains to the new field
	 remove the old field
would work, but if somebody knows of a way of doing this
using directly the Case tool I would be glad to know...

Bye, Robert

Hi

The methods you mention determine whether a file is writable.  Just because
a file is in use, for example opened in a spreadsheet application, does not
mean it is not writable.

There is a utility 'lsof' which allows you to determine whether a file
is opened by an application.  This utility is available for nearly all UNIX
systems (not sure about NT).  You could run it using system.do_command() from
within Magik.

>We are trying to find out using Smallworld if a file is currently in use by
>somebody.
>
>The following methods are available in Smallworld :
>system.file_writable?(filename) and system.access(filename, mode)
>
>If we do the following while a file is being accessed by somebody :
>system.file_writable?("c:\Project Register.xls") or
>system.access("c:\Project Register.xls", 2) (2 = writable) the result
>should be _false but it is not.  Whether the file is being accessed (in
>use) or not, the results always is _true.
>
>Is there any way of checking if a file is in use?

Andrew Gay                         Tadpole Cartesia
amg@...                  Waterloo House, Waterloo St
andrew@...                Clifton, Bristol BS8 4BT UK
phone: +44 (0)117 9238853          fax: +44 (0)117 9238834

Try the hard way:


_global try_file_access <<
_proc (file_name)
	 ## Checks file-access by trying to open the file

	 _local strm
	 _local ok? << _false

	 _catch :try_access

	        _handling file_no_access _with _proc ()
						        _throw
:try_access
					        _endproc

		 strm << external_text_output_stream.new_appending
(file_name)
		 strm.close ()
		 ok? << _true
	 _endcatch

	 _return ok?

_endproc


Then try_file_access("c:\Project Register.xls") will deliver _false
if this file is opened by an other application.

The condition-handling in this procedure is not comfortable, but it
shows you how to handle this situation. You should implement your
own functionality for "open file with access-check".

Regards

Herbert Mueckenheim
Geomagic GmbH


> -----Ursprüngliche Nachricht-----
> Von: corne@... [SMTP:corne@...]
> Gesendet am: Montag, 11. Oktober 1999 08:53
> An: sw-gis@egroups.com
> Betreff: [sw-gis-dev] File in use
>
>
>
> We are trying to find out using Smallworld if a file is currently in
use by
> somebody.
>
> The following methods are available in Smallworld :
> system.file_writable?(filename) and system.access(filename, mode)
>
> If we do the following while a file is being accessed by somebody :
> system.file_writable?("c:\Project Register.xls") or
> system.access("c:\Project Register.xls", 2) (2 = writable) the result
> should be _false but it is not.  Whether the file is being accessed
(in
> use) or not, the results always is _true.
>
> Is there any way of checking if a file is in use?
>
>
>
>
------------------------------------------------------------------------
>
> eGroups.com home: http://www.egroups.com/group/sw-gis
> http://www.egroups.com - Simplifying group communications
>
>
>

Hello everbody:

I have a simple program which is activated from one icon in the toolbar.
I want to show a tooltip in this icon. How can I get it?

Greetings,

Johnny

Hi Johnny,

	 You should have two messages defined on graphics_system, structured
as follows:
	 'icon_name'_thlp  text of icon_balloon_help_text
	 'icon_name'_ohlp text of status_bar on bottom of your grs

	 Success!

Wil Hendriks

> -----Ursprüngliche Nachricht-----
> Von: Johnny Espinoza Lopez [SMTP:jespinoza@...]
> Gesendet am: Dienstag, 12. Oktober 1999 12:06
> An: Sw-Gis-Dev (Correo electronico)
> Betreff: [sw-gis-dev] tooltip
>
>
> Hello everbody:
>
> I have a simple program which is activated from one icon in the toolbar.
> I want to show a tooltip in this icon. How can I get it?
>
> Greetings,
>
> Johnny
>
> ------------------------------------------------------------------------
>
> eGroups.com home: http://www.egroups.com/group/sw-gis
> http://www.egroups.com - Simplifying group communications
>
>
>

Hi all, as you can see in this web site, since this summer i find my
difficultie in using air photo in Smallworld.  But now i found a clue
and i want to share it with all of your's.

When i tried to load a georef air photo i receive a message like :
value out of range.  Why ? because i tried to use some coordinate who
where out off the scope of smallworld.  In fact as i see SW can hold
only coordinate with 10 or less numbersomething like that -500000000 mm
to 500000000 mm for a sum of 1000000000 mm, and I where trying to loade
an air photo with 555000000 m as coordinate so i can't.

To fix this prob I create a new database with this parameter and i
change the unit from mm to m so now i can load my air photo.

Did someone thinks i am wrong ?

A last thing, when i use the raster loader, my air photo is loaded but
she lost is greys scale and she is now in white and black.  How can i
keep my greyscale ?

THX all

Martin Chevrier
Université de Montréal

I will be out of the office from 10/10/99 until 10/14/99.

I will respond to your message when I return.

Hiya,

Ever come across this one ? Running a translation from (another) gis to
Smallworld, I have an external database available (Microsoft Access 97) and
am using swodbc (rev 3.0(0) of Smallworld) to access records in the external
database. During this time, huge files (750Mb) are appearing in my temp
directory (called JET6C.TMP etc) (the source Access database is only 180Mb)
which eventually kills the NT server,as there is no disk space left.

If I close the extdb and reopen it, the files get cleared out. So now I have
to periodically close and reopen the database during translation.

Ever heard anything similar ? Got a better solution ?

Cheers,

Simon Garton