Error - Can't change sql text because frmxxxxxxxxxxxx.qryMaster_.SelectQuery dataset open
If the above message is encountered where 'frmxxxxxxxxxxx.qryMaster' refers to a tablename, the cause could indicate that the Customised List fields for that user has been corrutped in some way.
Simply go to the list grid of the referred screen and right mouse click to pop up the Customise Field List screen, then press the 'Set back to default' button to reset the that grid. Log out of Ostendo and then back in to test.
Related Articles
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 ...
How do I create email Text to support emailed documents?
Go into File>Reporting Configuration>Specific Email Text and ‘Add’ a new record. Select the area that is covered by this email. Two extra fields will now contain the specific Text. These are the Header and Main Body of the email. These fields can be ...
What Fields can be shown in Specific Email Text
There maybe occasions when you wish to include some fields in the Specific Email Text when sending a document (eg: Invoice) from Ostendo via email. All Form Names other than "Call Centre" can include any fields from the Master Query PROVIDED that ...
Xero Posting Error Message 400
You may received this posting error message when attempting to post invoices to Xero. This appears to be a problem within Xero to do with the customers Due Date setting. Refer below response from Xero support.... "Unfortunately this is a known issue ...
How do I change the GST Method in Ostendo from Payments (Cash) to Invoice Basis?
On occasions there will be instances when an Ostendo Company database needs to be changed from Cash GST method to an Invoice (Accrual) method. This change is a significant change to how a business accounts for its GST, and therefore it is advised ...