NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
</pre>
In PostGreSQL there are other reserved word than in MySQL. In your SQL tool you will see them marked with blue text.<br/>[[Image:Reserved_word1.png|800px|center]]
<div align="center">
''How it looks like in SQL tool before correction''
</div>
[[Image:Reserved_word2.png|800px|center]]
<div align="center">
''How it looks like in SQL tool after correction''
</div>
[[Image:Reserved_word3.png|800px|center]]
<div align="center">
''How it looks like in integrated into the scriptwith escape characters''
</div>
Attribute.SetBoolean("Active"), Cast.Boolean("true");
</pre>
=== Geodata===__NOEDITSECTION__
The column ''userenteredcoord'' has been split up in 3 columns
* user_entered_x
* user_entered_y
* user_entered_mgrs
Search for ''UserEnteredCoord'' and replace the 5.08.04 syntax with:
Attribute.SetString("UserEnteredX", Row.GetString("Longitude"));
Attribute.SetString("UserEnteredY", Row.GetString("Latitude"));
Attribute.SetString("UserEnteredMGRS", Row.GetString("MGRS"));
You also need to verify that the following fields get correct values:
* CoordRefSys
* CoordRefFormat
* UserInputFormat
[[Category:NAA]]