NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
==Scripts==__NOEDITSECTION__
=== SQL syntax===__NOEDITSECTION__
{{Note | It is strongly recommended to copy all SQL statements to a SQL tool like PGadminIII or NaviCat and test them before running the script in {{IMSMANG}} 6.0}}
Due to PostGreSQL is case sensitive you need to adopt SQL statements by adding " around column names that contains capital case and because of the " you also need to add \ (escape character).
</div>
=== Data type Byte===__NOEDITSECTION__
In PostGreSQL the data type Byte has been replaced with Boolean. You find all places you need to change by searching for ''Byte''.
'''5.08.04 example'''
Attribute.SetBoolean("Active"), Cast.Boolean("true");
</pre>
=== Geodata===__NOEDITSECTION__
The column ''userenteredcoord'' has been split up in 3 columns
* user_entered_x
* UserInputFormat
===Mandatory information===__NOEDITSECTION__
Verify that the following fields are set and correct:
* Date of Information (previously called Date of Report)
* Data entry form ID
* Approved Date
* Approver
{{NavBox Technical Notes}}
[[Category:NAA]]