[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.axapta.programming

Updating record in numbersequencetable upon import from excel

Pat Brown

12/2/2005 3:31:00 PM

I need to know where I may be able to modify the query used durring import to
an axapta table.
I need insert the 'nextrec' field value from a particular record in the
numbersequencetable into the recid field in my table and incrememnt the
nextrec value while importing.
I have done this same thing using t-sql from a .net application, but I need
to know where I can find the sql that is executed upon import from excel into
axapta table.
Thanks in advance.
1 Answer

Allan Wallis

12/4/2005 6:52:00 PM

0

If you are using an import definition group then put your code on the
conversion tab

"Pat Brown" wrote:

> I need to know where I may be able to modify the query used durring import to
> an axapta table.
> I need insert the 'nextrec' field value from a particular record in the
> numbersequencetable into the recid field in my table and incrememnt the
> nextrec value while importing.
> I have done this same thing using t-sql from a .net application, but I need
> to know where I can find the sql that is executed upon import from excel into
> axapta table.
> Thanks in advance.