Dynamic SQL Error when performing a Global Name Change (Apostrophes in the Primary Key)
If data has been introduced into Ostendo outside of the normal user interface eg: Importing, then in most cases the database will reject the record. The normal Ostendo interface automatically deals with this by changing a ’ to a ` when the record is saved. However in the past it was possible to import data whose primary fields had apostrophes.
This then creates problems later when the record is selected via an SQL statement or updated internally by the database.
To resolve this it is suggested you use the Global Name Change utility to change the primary key from having a ’ to a `. The problem here is that the SQL behind the scenes does not like seeing single apostrophes on their own. The attached document explains how to get around this problem.
Related Articles
Mass Global Name Change
On occasions you may require a global name change to occur across multiple records. eg: you may need 10 customers requiring name changes. A script may be run to read data from a spreadsheet and then process each record in turn. Attached is a Standard ...
Global Name Change - Customer/Supplier etc with a blank name
In versions of Ostendo (Up to and including Update 160) you were able to inadvertently change a key field (eg: Customer or Supplier name) to a blank through the Global Name Change. This of course becomes a big problem and needs fixing ASAP. In order ...
How can I change a Customers or Suppliers Name?
You can amend many key fields in Ostendo. This is especially useful where your Customer or Supplier has changed their name. To reflect that name change in Ostendo go to File>System Configuration>Global Name Change and select the specific field that ...
License Key Name for Ostendo is different from Freeway app Registered Company Name
License Key name for Ostendo is different to the Freeway app company name appearing on the mobility devices. The "Registered To" Company Name appearing in Freeway can be any name you define. It does not have to be the same as the License Name. To ...
Terminal Server Ports and Registry Key Installation Settings
Extract - If running Terminal Services, Please read this Extract from the Ostendo Installation Specification regarding Ports, Registry Keys, etc:- All computer networks must have at least UTP Category 5 Cable and 100mbps network speed. Ensure all ...