StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Application Framework - V1
»
Business Objects and Data Access (How do I?)
»
Modify/update same row more than two times from BO on transaction not...
Modify/update same row more than two times from BO on transaction not update it from 2nd time...
Post Reply
Like
2
Modify/update same row more than two times from BO on transaction not...
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Fabian R Silva, -
Fabian R Silva, -
posted 13 Years Ago
ANSWER
Topic Details
Share Topic
Group: StrataFrame Users
Posts: 153,
Visits: 1.2K
Hello,
problem is that when loop the 2nd time, Save(lOnTr, sTrKEy) not do nothing because isDirty() is false... (1st time work ok)
how I can update a 2nd time the same table "Counter" on a transaction?
I need this because this will lock the number on MyTabkecounter an allow to use it in AnotherTable on a transaction without fear of that this number can be repeated
MyTableCounter
------------------------------
Id
|
Number
-----------------------------
1
5
2
99
3
999
dsk = "myDB"
lOnTr = true
sTrKey = "aTrKey"
BusinessLayer.TransactionBegin(dsk, trKey, IsolationLevel.ReadCommitted);
MyTableCounter.FillByPrimaryKey(1);
for(lnk=0;lnk<=5;lnk++)
{
MyTableCounter.Number += 1;
MyTableCounter.Save(lOnTr, sTrKey); --> this doesn't execute from 2nd time
AnotherTable.NewRow();
AnotherTable.MyTableCounterId = MyTableCounterId.Id;
AnotherTable.Number = MyTable.Number;
AnotherTable.Date = DateTime.Now.Date;
AnotherTable.Save(lOnTr, sTrKey);
}
MyTableCounter.FillByPrimaryKey(2);
for(lnk=0;lnk<=5;lnk++)
{
MyTableCounter.Number += 1;
MyTableCounter.Save(lOnTr, sTrKey); --> this doesn't execute
AnotherTable.NewRow();
AnotherTable.Number = MyTable.Number;
AnotherTable.Date = DateTime.Now.Date;
AnotherTable.Save(lOnTr, sTrKey);
}
BusinessLayer.TransactionCommit(dsk, sTrKey);
Tags
transactions
Reply
Like
2
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
Modify/update same row more than two times from BO on transaction not...
Fabian R Silva, -
-
13 Years Ago
There is a way to do this, but purists would frown upon it :) Since...
StrataFrame Team
-
13 Years Ago
Hi Ben, I am facing the same situation as described in this post....
Andrew Harper
-
10 Years Ago
thanks you for the response Today I ended up doing a process to...
Fabian R Silva, -
-
13 Years Ago
Post Reply
Like
2
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search