Sage X3 provides a special function Writeb to write into a table. It works similar to Write function but it allows us to optimize the performances when several insertions of database lines must be done.
CLASS: a classidentifier that corresponds to the abbreviation used to open a database table.
Writeb allows you to buffer the lines written in a database table before sending them globally. This instruction should be used when massive inserts are done in a given table.
If a CLOB or a BLOB is present on the table, Writeb behaves exactly as Write (no buffering is done).
Writeb updates fstatto indicate the result of the write operation only when transmitting the data to the database. It is therefore not possible to identify the line in which the error occurred. The best practice is to run the transaction again with [S]adxwrb set to 1. The fstat value will then be returned after every Writeb.
The values available for status are the following:
|0||The write operation has been successful (or has only been placed for the moment in the write buffer).|
|1||Lock error on at least a database line.|
|3||An attempt to create a duplicate key has been detected.|
Hope this helps!
Greytrix is one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.
Greytrix have some unique solutions of Sage X3’s integration with Sage CRM, Salesforce.com and Magento eCommerce. It also offers best-in-class Sage X3 customization and development services to Sage business partners, end users, and Sage PSG worldwide.
For more information on Sage X3 Integration and Services, please contact us at firstname.lastname@example.org.We will be glad to assist you.
- How to attach the Report to the Window in X3
- Adding Crystal Report In X3
- Sage X3 reports as per Indian Business Standards – Part III
- Send Invoice Reports Automatically in Sage X3
- Sage ERP X3 Reports – India Specific Reports – Part I