NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
==Scripts==__NOEDITSECTION__
=== SQL syntax===__NOEDITSECTION__
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).
SELECT Loc_VillageGUID, mMREID FROM loc_link_mre WHERE loc_link_mre.Loc_VillageGUID IS NOT NULL
</pre>
'''need needs to be changed to'''
<pre>
SELECT \"Loc_VillageGUID\", \"mMREID\" FROM loc_link_mre WHERE \"Loc_VillageGUID\" IS NOT NULL
</pre>
=== 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'''
<pre>
Attribute.SetByte("IsActive"), Cast.Byte("1");
</pre>
'''needs to be changed to'''
<pre>
Attribute.SetBoolean("Active"), Cast.Boolean("true");
</pre>
[[Category:NAA]]