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

2005-03-11 Thread Raul Llorente Peña/OPENSOLUTIONS
t;[EMAIL PROTECTED]> 10/03/2005 23:37 Por favor, responda a Axapta-Knowledge-Village@yahoogroups.com Para cc Asunto RE: RE: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?   Raul,     We had a problem with the COM connector in th

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

2005-03-10 Thread Bayliss, Barry
@yahoogroups.com Subject: RE: RE: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?   Hi, Barry!! I'd like to do so, but the code is embedded in an huge Java program. I asked the Java programmers to give me the part where we made the test, and it&#

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

2005-03-10 Thread Raul Llorente Peña/OPENSOLUTIONS
54 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: RE: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?   Yes, that solves the problem or duplicated RecId's inserted in several tables, but doesn't solve the insert-error issue... R

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

2005-03-09 Thread Bayliss, Barry
AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?   Preston , the problem isn't that records are inserted with same RecId, but Axapta doesn't allow to do so!!   If I de

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

2005-03-06 Thread Raul Llorente Peña/OPENSOLUTIONS
IL PROTECTED]> escribió: -Para: De: "Preston A. Larimer" <[EMAIL PROTECTED]>Fecha: 04/03/2005 20:34Asunto: RE: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?Definitely duplicate recID?s is not what you want, the menu path I gave you runs

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

2005-03-04 Thread Preston A. Larimer
: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?   Preston, the problem isn't that records are inserted with same RecId, but Axapta doesn't allow to do so!!   If I deactivated the system-hidden indexes of many tables, Axapta woul

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

2005-03-04 Thread Raul Llorente Peña/OPENSOLUTIONS
uot;Preston A. Larimer" <[EMAIL PROTECTED]>Fecha: 03/03/2005 15:39Asunto: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?Try Administration\Periodic\SQL Administration\Check Record Id?s(Button)  -Preston Preston A. Larimer Professi

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

2005-03-03 Thread Bayliss, Barry
-Village@yahoogroups.com Subject: Re: Re: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?   We've tested this point until exhaustment.   The problem doesn't come when selecting or updating records. The problem comes when we insert records co

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

2005-03-03 Thread Preston A. Larimer
oups.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.    

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

2005-03-03 Thread Raul Llorente Peña/OPENSOLUTIONS
ECTED]> 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() prio

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

2005-03-03 Thread Karsten Krabbes
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 updated br karsten --- In Axapta-Knowledge-Village@yahoogroups.com, Raul Llorente Peña/OPENSOLUTIONS <[EMAIL

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

2005-03-03 Thread Raul Llorente Peña/OPENSOLUTIONS
álisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS-"Bayliss, Barry" <[EMAIL PROTECTED]> escribió: -Para: De: "Bayliss, Barry" <[EMAIL PROTECTED]>Fecha: 02/03/2005 23:57Asunto: RE: RE: [Axapta-Knowledge-Village] How can

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

2005-03-02 Thread Bayliss, Barry
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 reco

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

2005-02-25 Thread Raul Llorente Peña/OPENSOLUTIONS
rente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS-"Bayliss, Barry" <[EMAIL PROTECTED]> escribió: -Para: De: "Bayliss, Barry" <[EMAIL PROTECTED]>Fecha: 24/02/2005 23:26Asunto: RE: [Axapta-Knowledge-Village] How ca

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

2005-02-24 Thread Bayliss, Barry
  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-Kno

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

2005-02-24 Thread Raul Llorente Peña/OPENSOLUTIONS
<[EMAIL PROTECTED]>Fecha: 24/02/2005 14:46Asunto: Re: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?Raul,What is it you want us to tell? I am just telling you that looking at the other value would bring you closer to finding the recid. But that there is still

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

2005-02-24 Thread Danny Gaethofs
Raul, What is it you want us to tell? I am just telling you that looking at the other value would bring you closer to finding the recid. But that there is still the problem Axapta pulls out a number of record id's at a time. So next thing you should focus on is where are these stored and h

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

2005-02-24 Thread Raul Llorente Peña/OPENSOLUTIONS
>Fecha: 24/02/2005 13:45Asunto: Re: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?Raul,Why do you select the firstonly record. This will give you the record for SysEvent (id 3).Now try this:select firstonly SSwhere SS.name == "seqno" you would get clos

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

2005-02-24 Thread Danny Gaethofs
Raul, Why do you select the firstonly record. This will give you the record for SysEvent (id 3). Now try this: select firstonly SS where SS.name == "seqno" you would get closer to the matching values. They do not match but this must have something to do with the fact that the kernel is pul

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

2005-02-24 Thread Raul Llorente Peña/OPENSOLUTIONS
ss Solutions-AxaptaOPEN SOLUTIONS-"David Casas" <[EMAIL PROTECTED]> escribió: -Para: De: "David Casas" <[EMAIL PROTECTED]>Fecha: 24/02/2005 10:23Asunto: Re: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?Hi Raul, To see the nex

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

2005-02-24 Thread David Casas
Hi Raul,   To see the next RECID to be used with the following sentence in the SQLAnalyzer:   select * from systemsequences where id = -2The field NextVal is the value for the next transaction ID Regards!!   David - Original Message - From: Raul Llorente Peña/OPENSOLUTI