How to generate automatically CSRs with mooring coordinates retrieved from two separate database fields?
In MIKADO automatic, the mooring coordinates are combined into one field (var36 = Longitude, Latitude).
If you want to link the var36 "Coordinates" to two separate fields (latitude and longitude) of your database, you have to concat them in your query; MIKADO will be able to separate them in the XML output file. For example:
- For Oracle database: var36 = longitude || ',' || latitude
- For Sybase: var36 = ltrim(str(longitude,9,5))+ ', '+ ltrim(str(latitude,9,5))
