[development-axapta] SQL Statement

How can I use the update statement using the ODBCconnection class? I need to update the data of a field using a ODBC after I read the information I've already use the Select * from... statement, but I don't know how to run an update. Thanks in advance. Best Regards. Gonzalo

RE: [development-axapta] Question regarding settlements and closing date

We only use one currency, so that should not effect anything. None of our users are particularly advanced, and would be scared of trying anything unusual, so anything that did happen would have been 'automatic'. Then again.. you never know with end users ;) We are running Axapta 3.0 SP2.

RE: [development-axapta] SQL Statement

SELECT * FROM Table where Table.Field1 = 971336 AND DATAAREAID = ' + company + ' + UPDATE Table set Field2 = 'EXPORTED' where Field1 = 971336; In this case the system will select the Table named Table where the field Field is equal to 971336 and then update the Field named Field2 with

AW: [development-axapta] Duplicate voucher Numbers

Hi Girish, hi Harsh I think, this is what you are looking for... HF30SP3_008, Hot Fix Corrections made for: With this HotFix installed a user can't draw a journal number without either saving or delete it. This correction prevents the system from assigning 2 journals with the same number.

RE: [development-axapta] Question regarding settlements and closing date

Hi Matt, sorry cannot recall if SP2 sovled the bug I was thinking of...I think it maybe did. I suggest oyu check you max penny diff you allow in the parameters and also like someone else mentioned the cash discount. If you look in the 'History' button of the transaction what amount do you

[development-axapta] number sequence

Hi all, Perhaps this is a silly question, but is there a way to check if a number sequence exist from x++ code? I thought I would get full acces to them by using a variable of the type NumberSeq. But I can't see how. Logically the next question would be: if this is possible, would i be

RE: [development-axapta] number sequence

Try this, taken from the Best Practice Handbook. :-J Systemdeveloper Jacob Hjelmer Thy Data Center Development A/S Søvej 13b DK-3460 Birkerød Denmark Phone : +45 96 170 470 Fax : +45 45 824 544 URL : http://development.thydatacenter.dk/

RE: [development-axapta] Duplicate voucher Numbers

Hi Tom, Thanks for this information. Is it required that we first upgrade to SP3 or I can have this import directly on SP2? Cheers, Girish -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 29 October 2004 08:42 To: [EMAIL PROTECTED] Subject: AW:

[development-axapta] Re: number sequence

Thanks, this is it! --- In [EMAIL PROTECTED], Jacob Hjelmer Nielsen [EMAIL PROTECTED] wrote: Try this, taken from the Best Practice Handbook. :-J Systemdeveloper Jacob Hjelmer Thy Data Center Development A/S Søvej 13b DK-3460 Birkerød Denmark Phone : +45 96 170 470

[development-axapta] Having / like relational operators

If you are using straight SQL, just build the statement as you've specified. If you are using Axapta's embedded SQL, try using the MATCH function in your where clause. If you are using a query, the query range value can use wildcards, ranges, etc. Both the Match function and query values

[development-axapta] Settle a Transaction

Hoa can I settle a vend invoice via code, I need manually cancel the amount of an open invoice. Best Regards. Gonzalo. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go

Re: AW: [development-axapta] Duplicate voucher Numbers

Hi, I have a similar problem. We are using Ax3.0 with SP3. May be Giresh or Harry help us sharing their exp... or can walk through the steps The problem is when a user tries to craete a Journal , its trying to use already used Numbser sequence number. The error message say The

Re: [development-axapta] SalesTable

Thanks Aji, Thanks for the extensive reply. This completes my analysis and enables me to perform the update and add a my new document. regards, Danny --- Aji Sarosa [EMAIL PROTECTED] wrote: Hi Danny, Container fed by checkIfUpdate is actually built in method checkIfUpdate() in

[development-axapta] Upgrade from SP1 to SP3 directly/ key areas to check after applying the SP

I am using Axapta 3.0 SP1. I am planning to upgrade to SP3. What is best, to upgrade to SP2 first and then SP3 or to upgrade to SP3 directly? After upgrading, what key areas can I check to verify that everything is ok…. ? Thanks __ Renovamos

[development-axapta] Monitoring Axapta Users actions

Hi, As I asked for your help, I am trying to see if I can use any existing tool in Axapta to monitor the User actions. Such as... I have a vendtable. I would like to see the history of a particular record in that table. When I see the record info, I didn't get any valuable information.