{"id":9931,"date":"2017-02-19T10:53:31","date_gmt":"2017-02-19T10:53:31","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=9931"},"modified":"2019-03-11T06:32:32","modified_gmt":"2019-03-11T06:32:32","slug":"how-to-flush-the-write-buffer-in-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2017\/02\/19\/how-to-flush-the-write-buffer-in-sage-x3\/","title":{"rendered":"How to flush the write buffer in Sage X3"},"content":{"rendered":"

Sage X3 version 7 has a new function Flush the Write buffer, which is filled by the\u00a0Writeb<\/a>\u00a0instruction.<\/p>\n

Flush:<\/strong> The\u00a0Flush\u00a0instruction sends to the database the lines that have not already flushed when the\u00a0Writeb<\/a>\u00a0syntax is used to create lines in the database.<\/p>\n

Syntax:<\/strong><\/p>\n

Flush[Class]\n

Parameter Details:<\/strong><\/p>\n

CLASS\u00a0is the abbreviation of the table in which the flush is done. By default, the current table as defined by\u00a0File<\/a>or by\u00a0Default<\/a>\u00a0File<\/a>\u00a0is considered.<\/p>\n

When several lines have to be written in a database table, it is important to use the\u00a0Writeb<\/a>\u00a0instruction instead of the\u00a0Write<\/a>\u00a0syntax. The difference is that the lines are sent to the database by groups of\u00a0adxwrb<\/a>\u00a0lines. This avoids too many exchanges with the database server and is therefore less time consuming. The only consequence is that the\u00a0fstat<\/a>\u00a0value is returned only at flush time or for every\u00a0adxwrb<\/a>\u00a0record. This means that the development partner can no longer identify the exact line where the error occurred; however, it is still possible to retry the create transaction with\u00a0adxwrb<\/a>\u00a0equals to 0 (that disables the buffering).<\/p>\n

It is mandatory to flush the write buffer before a\u00a0Commit<\/a>; otherwise, an error occurs if lines remain in the flush buffer at\u00a0Commit<\/a>.<\/p>\n

Flush updates the\u00a0fstat<\/a>\u00a0variable to give the result of the write operations, as indicated by the following table:<\/p>\n\n\n\n\n\n\n
fstat value<\/strong><\/td>\nDescription<\/strong><\/td>\n<\/tr>\n
0<\/td>\nThe write operation has been successful.<\/td>\n<\/tr>\n
1<\/td>\nThe write operation failed due to locking issues.<\/td>\n<\/tr>\n
3<\/td>\n\u00a0The write operation failed on a duplicate key creation attempt.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Hope this helps.<\/p>\n

About Us<\/strong><\/span>
\nGreytrix<\/a> \u2013 a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.<\/p>\n

Greytrix<\/a>\u00a0caters to a wide range of Sage Enterprise Management (Sage X3) offerings \u2013 a Sage Business Cloud Solution. Our\u00a0unique GUMU™ integrations include Sage Enterprise Management (Sage X3) for Sage CRM<\/a>,\u00a0Salesforce.com<\/a> and\u00a0Magento eCommerce<\/a>\u00a0along with Implementation and Technical Support worldwide for Sage Enterprise Management (Sage X3)<\/a>. Currently we are Sage Enterprise Management Implementation Partner<\/a> in East Africa, Middles East, Australia, Asia.\u00a0We also offer best-in-class\u00a0Sage X3 customization and development services<\/a>,\u00a0integrated applications such as POS<\/a> | WMS<\/a> | Payment Gateway<\/a> | Shipping System<\/a> | Business Intelligence<\/a> | eCommerce<\/a> and have developed add-ons such as Catch \u2013 Weight <\/a>\u00a0and Letter of Credit<\/a> for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.<\/p>\n

Greytrix is a recognized Sage Rockstar ISV Partner<\/a> for GUMU™ Sage Enterprise Management \u2013 Sage CRM integration also listed on Sage Marketplace<\/a>; GUMU™ integration for Sage Enterprise Management \u2013 Salesforce is a 5-star app listed on Salesforce AppExchange<\/a>.<\/p>\n

For more information on Sage X3 Integration and Services, please contact us at\u00a0x3@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

Sage X3 version 7 has a new function Flush the Write buffer, which is filled by the\u00a0Writeb\u00a0instruction. Flush: The\u00a0Flush\u00a0instruction sends to the database the lines that have not already flushed when the\u00a0Writeb\u00a0syntax is used to create lines in the database. Syntax: Flush[Class] Parameter Details: CLASS\u00a0is the abbreviation of the table in which the flush is\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[1797,1942,2086,2441],"class_list":["post-9931","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","tag-sage-erp-x3-technical-blogs","tag-sage-x3-technical-assistance","tag-setup-timeout-in-sage-x3","tag-write-buffer-in-sage-x3"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/9931","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=9931"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/9931\/revisions"}],"predecessor-version":[{"id":17306,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/9931\/revisions\/17306"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=9931"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=9931"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=9931"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}