Hi Varden, Thanks again Varden. I'll try this out and will keep you posted. Thanks Arijit
On 5/16/05, Varden Morris <[EMAIL PROTECTED]> wrote: > > > > > > > Hi Arijit > > > > Look at the OdbcConnection class under system documentation. This will allow > you to set up a Data Source Name (DSN) for a remote database and connect to > it. You will then be able run queries or updates on the database using the > native database syntax for the backend database. > > > > A possible solution is to create a new table in application A that will > store the customer account number and a field with an enum type that will > store a value to indicate rejection. When a record is inserted in > application A you could add code to the insert method on the custTable to > insert a record in the new table. Application B would then do a query on the > new table and fetch and validate the corresponding record in custTable in > application A. If the record passes the validation test it should be > inserted in custTable in application B and then deleted from the new table > created in application A. If it fails the validation the enum field should > be updated to indicate this. > > > > You may set up batch processes in Axapta to do the checks and updates or you > may use .NET to write a windows service that do likewise. > > > > > > Varden Morris > > > > J. Wray & Nephew Ltd. - Group I.S. > > 234 Spanish Town Road > > Kingston 11, Jamaica, W.I. > > > > Phone: (876) - 923 - 6141 Ext. 2226 > Fax: (876) - 923 - 5372 > > Cell: (876) - 3833566 > Email: [EMAIL PROTECTED] [EMAIL PROTECTED] > > > Arijit <[EMAIL PROTECTED]> wrote: > Hi all, > I have a situation here and you gotta get me out of this. Say I have > 2 Axapta Applications (A & B , Both Axapta 3.0 SP3) having 20 % > different application logic and different databases located > geographically apart. These 2 locations are connected by lease line. > From Application A, when i register a customer, I want that customer > data to be updated on Application B database for verification purpose. > When Application B receives the customer record, It validates the > customer according to some pre defined rules and approves/ rejects it. > This approval / rejection status has to be sent back to Application A > database for further action. Both the Applications run SQL 2000 SP3. > Custtable structure is the same in both. > The situation is how to update remote databases from Axapta. Do i have > to write a job for that? This transfer of cust record will take place > when the user clicks the "Send Customer" button. > Cheers > > > Sharing the knowledge on Axapta. > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > 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 the Yahoo! Terms of Service. > ________________________________ > 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. > > ------------------------ 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/
