Syntax:<\/span><\/i><\/b><\/p>\n UNIQID ( class )<\/p>\n While UNIQID is used to have a unique number for a given table opened previously; these numbers are assigned sequentially and therefore they can be used as an access key to the file.<\/p>\n These numbers are kept by copy, extraction, restoration and revalidation of the table.<\/p>\n Warning! This number sequence does not need to be consecutive. For instance, there is no number retrieval further to a Rollback.<\/p>\n The result type is Integer.<\/p>\n Remarks<\/span><\/i><\/b><\/p>\n For a newly created table, numbers are assigned from number 1 and then it will be incremented sequentially. the current number is kept, if a table is reset to 0, the numbers are reassigned starting from 1. There is no other way to decrement this sequence of numbers.<\/p>\n The numbers assigned sequentially cannot be reassigned if a transaction is aborted by Rollback. To implement this kind of function, if all the numbers should be assigned, it is recommended to resort to counters (for instance, a main counter and a grid containing the aborted numbers to be reassigned in priority).<\/p>\n The uniqid instruction is executed even if the table is locked.<\/p>\n The uniqid instruction does not update the [S]fstat variable.<\/p>\n Dysfunctioning generated by the sequences of the database<\/span><\/i><\/b><\/p>\n <\/b>There is a problem if the sequence no longer exists. ERP X3 sends an error message linked to the database. Then the database log file needs to be referred to for further details.<\/p>\n Since sequences are used for generating unique keys, if the uniqid function returns a value lower than the last one to be recorded, ERP X3 will display an error message of the type”Key does not exist in the table”. In that case, the sequence needs to be updated.<\/p>\n How to check the validity of a table sequence?<\/span><\/i><\/b><\/p>\n <\/i><\/b>Example of the \u201cEMPDETAIL\u201d table of a “DEMO” folder<\/p>\n How can I assign the correct value back to the sequence?<\/span><\/i><\/b><\/p>\n # By proceeding with the process started above. If nbruser > 1: Errbox\u00a0 \u2018You are not the only user of this folder!\u2019 : End: Endif<\/p>\n While uniqid([EMP]) <MAXA: Wend<\/p>\n About Us<\/strong><\/span> 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":" UNIQID is used to generate a sequence of unique long integers for each Adonix table. New Stuff: How to conditionally restrict the import update Syntax: UNIQID ( class ) While UNIQID is used to have a unique number for a given table opened previously; these numbers are assigned sequentially and therefore they can be used\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[975,2303],"class_list":["post-5209","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-hits-on-table","tag-uniqid"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/5209","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=5209"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/5209\/revisions"}],"predecessor-version":[{"id":16308,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/5209\/revisions\/16308"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=5209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=5209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=5209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"Uniqid-1\"](\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2014\/05\/Uniqid-1.jpg\")
<\/a><\/p>\n
\n# The most simple solution is to ensure that there is only one user on this particular file<\/p>\n
\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