Error When trying to perform edit operations
Posted: Fri 13 Jul 2007 12:29
Hi,
I am using Licensed version(3.80) of SDAC components.
I am facing a problem when performing Certain Edit(Update and Delete) Operations. This problem is specific only in certain cases.
The sequence of operations on database will as follows:
1) There will certain set of Select Operations to validate the data user has entered
2) There will be certain Select Operations to determine whether user is in Edit mode or Add Mode
3) When the user is in Edit mode, he performs certain modifications to the data and accordingly dataset is updated.
4) Now when i Start the transaction to update the changes of dataset to the database i am getting the following message
"Error: Cannot create new transaction because capacity was exceeded."
I know that there can be some problem in my Code but i tried out various options and i couldnt find any success.
I am using Query an UpdateSQL components of SDAC for this purpose.
Can any one help me out in solving my problem.
Regards
Balajee
I am using Licensed version(3.80) of SDAC components.
I am facing a problem when performing Certain Edit(Update and Delete) Operations. This problem is specific only in certain cases.
The sequence of operations on database will as follows:
1) There will certain set of Select Operations to validate the data user has entered
2) There will be certain Select Operations to determine whether user is in Edit mode or Add Mode
3) When the user is in Edit mode, he performs certain modifications to the data and accordingly dataset is updated.
4) Now when i Start the transaction to update the changes of dataset to the database i am getting the following message
"Error: Cannot create new transaction because capacity was exceeded."
I know that there can be some problem in my Code but i tried out various options and i couldnt find any success.
I am using Query an UpdateSQL components of SDAC for this purpose.
Can any one help me out in solving my problem.
Regards
Balajee