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

[Raul Llorente Peña/OPENSOLUTIONS]

We've tested this point until exhaustment. The problem doesn't come when selecting or updating records. The problem comes when we insert records concurrently from COM in ANY table. We made the test of inserting records in a test table that had not indexes. Axapta created an hidden index that includes recid, and company id. We deactivated this index from Oracle (evidently, this wouldn't be been possible from Axapta, and of course we didn't resinchronize the table!!). The results shows that sometimes RecId's appears duplicated (but the rest of fields no...). If we reactivate the hidden index, the familiar error ("record couldn't be inserted in table X. Record already exist)" reappears...Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS-----"Karsten Krabbes" <[EMAIL PROTECTED]> escribió: -----Para: Axapta-Knowledge-Village@yahoogroups.comDe: "Karsten Krabbes" <[EMAIL PROTECTED]>Fecha: 03/03/2005 13:46Asunto: Re: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?Why don't you use the tablemethod exist() prior to creating the record ?Our problem seems not to be the recid. It seems the record is already inserted into the table and needs to be updatedbrkarsten--- In Axapta-Knowledge-Village@yahoogroups.com, Raul Llorente Peña/OPENSOLUTIONS <[EMAIL PROTECTED]>wrote:> ------------------------ Yahoo! Groups Sponsor --------------------~--> What would our lives be like without music, dance, and theater?Donate or volunteer in the arts today at Network for Good!http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM--------------------------------------------------------------------~-> Sharing the knowledge on Axapta. 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:   http://docs.yahoo.com/info/terms/


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.