Re: [Axapta-Knowledge-Village] URGENT!!!! RecId

2005-03-29 Thread Ricardo Cortés
Hi,   I want to upload General Journals, the header and its lines, so the tables that I want to upload are ledgerjournaltable and ledgerjournaltrans. This tablea are going to be added through an interface made in .Net, but my problem is asign the RecId. I'm using mssql, I hope some can help me.S

RE: [Axapta-Knowledge-Village] URGENT!!!! RecId

2005-03-29 Thread Varden Morris
Hi Chea,   Just execute this command again:   select _tblSales;   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2226Fax:  (876) - 923 - 5372 Cell:  (876) - 3833566Email:   [EMAIL PROTECTED]  

RE: [Axapta-Knowledge-Village] URGENT!!!! RecId

2005-03-28 Thread Chea
hi, any 1 know how to move record to first cursor in Axapta? eg. {     SalesTable    _tblSales;     ;     select _tblSales;     while(_tblSales)     {     if(_tblSales.SalesId == '0005')    info(_tblSales.SalesId); next _tblSales;     }       After this loop, I want m

RE: [Axapta-Knowledge-Village] URGENT!!!! RecId

2005-03-28 Thread nana
Hi Ricardo,   You can try this script, i am using Axapta COM Connector from mssql     if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fnGetRecID]') and xtype in (N'FN', N'IF', N'TF'))drop function [dbo].[fnGetRecID]GO   CREATE FUNCTION fnGetRecID ()RETURNS intWITH ENC

Re: [Axapta-Knowledge-Village] URGENT!!!! RecId

2005-03-28 Thread Subrahmanyam Mamidi
Hi Ricardo,   Ok. Axapta Recids will be generated in Kernel. what exactly do you want to do?. Which Tables you want to upload?. Are you uploading vendors/Customer with Atl addresses???.   Let us know. Someone from the group will help you,   Be more specific always. thanks, subbu SDBCRicardo Cort