<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
To Steve -<br>
<br>
I'm changing the name of the column, i.e making stuctural changes in
the table. I'm not changing the content of any fields. I'm not
changing the column type or constraints, only the column name.<br>
<br>
Detailed description:<br>
<ul>
<li>Create a dataconnection to Oracle Express 10.0 using Oracle
King Provider 3.4 ver. 8.28: Success. Data and graphics can be
previewed.</li>
<li>Create a layer using above-mentioned dataconnection: Success.
Layer can be previewed, objects in the layer can be selected and
propertiesm be shown using the ajaxviewer.</li>
<li>Change a column name or "field name" ("beloved child has many
names" :-) in the oracle table used in the above-mentioned layer
with a third-party tool.</li>
<li>Inspect the layer after the column name change using Maestro:
The column name in the properties window has not changed and
preview doesn't show the layer.</li>
<li>Right-click the relevant featuresource and click on "Purge
Cached Schema
Information".</li>
<li>
Inspect the layer again: The column's name has now changed to
the new name and preview shows the layer again.<br>
<br>
</li>
</ul>
So Jackie's method apparently works.<br>
Alternatively, you can right-click the layer itself and then click
on the ""Purge Cached Schema
Information"" sub-item.<br>
<br>
Regards (and thanks!)<br>
<br>
Bo Victor Thomsen <br>
<br>
<br>
Den 15-08-2011 18:25, Steve G skrev:
<blockquote cite="mid:1313425537452-6688170.post@n2.nabble.com"
type="cite">
<pre wrap="">Can you verify...are you updating records or changing column names (i.e.
"field names")? If you are updating records, then Jackie's approach works,
but if you are making actual changing to the table structures by changing
column names of your data, then I believe the only way is to update your
layer definition (you don't necessarily need to update the data connection
unless you have filters). You don't have to recreate the layer/data
connection definitions...you can just update the xml file with the correct
property names.
-Steve
--
View this message in context: <a class="moz-txt-link-freetext" href="http://osgeo-org.1803224.n2.nabble.com/How-to-change-layer-definition-in-Maestro-when-underlying-datasource-changes-n00b-question-tp6686819p6688170.html">http://osgeo-org.1803224.n2.nabble.com/How-to-change-layer-definition-in-Maestro-when-underlying-datasource-changes-n00b-question-tp6686819p6688170.html</a>
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Med venlig hilsen
Civ.Ing.
Bo Victor Thomsen
Geograf A/S
</pre>
</body>
</html>