Axapta 3 introduces new sql commands to bulk updates. Search for
"recordset" in the Axapta Developers Guide in the Help menu...
UPDATE_RECORDSET myTable
SETTING field1 = myTable.field1 * 1.10;
S.
_____
From: Jay Sathasivam [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 22 June 2004 9:17 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Speedup my Insert Records Process
Hi Guys,
I am try to Update like 5000 or more records and I am using
ttsbegin;
Select forupdate tablename
tablename.Field1 = xxxx;
tablename.Field2 = sdfsdf;
tablename.insert();
ttscommit;
My problem is it's taking more time but I am thinking to use storeprocedure
in Oracal Database but I want's to know how to execute (Passing Parrameter)
from Axapta.
Please let me know ASAP.
Best Regards
Jay
---------------------------------
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129nnv19n/M=298184.5022502.6152625.3001176/D=gr
oups/S=1705006764:HM/EXP=1087966287/A=2164339/R=0/SIG=11e2d64in/*http://www.
netflix.com/Default?mqso=60183348> click here
<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=
:HM/A=2164339/rand=211302274>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
<http://groups.yahoo.com/group/development-axapta/>
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
