RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?

[Bayliss, Barry]

Raul,     It sounds like you have an indexing problem.    You need to check the indexes that are set to have AllowDuplicates = No.   Is the table you are using standard?   Barry.   From: Raul Llorente Peña/OPENSOLUTIONS [mailto:[EMAIL PROTECTED] Sent: Friday, 25 February 2005 7:03 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?   I've got a problem. Several users via COM, using same COM session, sometimes invokes the error (Cannot insert a record in table X. The record already exists). X may be an apparently alleatory table. And I need to track so.   Tool of log of database doesn't fit this... Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS   -----"Bayliss, Barry" <[EMAIL PROTECTED]> escribió: ----- Para: <Axapta-Knowledge-Village@yahoogroups.com> De: "Bayliss, Barry" <[EMAIL PROTECTED]> Fecha: 24/02/2005 23:26 Asunto: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?   Hello Raul,   Why is it that you need to find the recID for before the insertion?     Barry.     From: Raul Llorente Peña/OPENSOLUTIONS [mailto:[EMAIL PROTECTED] Sent: Thursday, 24 February 2005 3:08 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?   How can I find what RecId will be the next to be used, before inserting a record and without accessing the table of RecIds (SystemSequences)?   Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS Sharing the knowledge on Axapta. Sharing the knowledge on Axapta.   Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/   To unsubscribe from this group, send an email to: [EMAIL PROTECTED]   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.