The connection aslo works with ttsbegin/commit which is very nice
-----Example------
Connection connection = new Connection();
Statement statement;
Connection connection2 = new Connection();
Statement statement2;
;
try
{
ttsbegin;
statement = connection.createStatement();
statement.executeUpdate("delete from table");
statement.executeUpdate("insert into Table
(ItemId,InventDimId,Qty,RecId) "+
"select ItemId, InventDimId, Qty,
RecId from InventTrans " +
"where
InventTrans.SPA_VirtualReserved = 1 and "+
"InventTrans.StatusIssue = 6
and " +
"inventTrans.TransType = 0
and " +
"inventTrans.DataAreaId = '"
+ curext() + "'");
print "Tid brukt i minutter: ",(WinApi::getTickCount() -
startTime)/1000/60;
statement.executeUpdate("insert into Table2
(ItemId,InventDimId,Qty,RecId) "+
"select ItemId, InventDimId, Qty,
RecId from InventTrans " +
"where InventTrans.StatusReceipt =
0 and "+
"InventTrans.StatusIssue = 4
and " +
"inventTrans.TransType = 0
and " +
"inventTrans.DataAreaId = '"
+ curext() + "'");
print "Tid brukt i minutter: ",(WinApi::getTickCount() -
startTime)/1000/60;
statement.close();
connection2 = new Connection();
statement2 = connection.createStatement();
statement2.executeUpdate("delete from sometable "+
"where RecId not in "+
" (select max(recId) from table group
by ItemId,InventSizeId)");
statement2.close();
ttscommit;
t 03:17 22.06.2004, you wrote:
>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=groups/S=1705006764:HM/EXP=1087966287/A=2164339/R=0/SIG=11e2d64in/*http://www.netflix.com/Default?mqso=60183348>
>5e033c7.jpg
>
>[]
>
>
>
>----------
>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:
> *
> <mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED]
>
> *
> * Your use of Yahoo! Groups is subject to the
> <http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.
[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.
