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
@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
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
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
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:
[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
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
-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
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.
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
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
á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
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
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
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
<[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
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
>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
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
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
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
21 matches
Mail list logo