Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Seeking Opinions On Transactions....
Message
From
13/05/2002 15:48:19
Jason Dalio
Northern Interior Regional Health Board
Prince George, British Columbia, Canada
 
 
To
All
General information
Forum:
Visual Basic
Category:
Other
Title:
Seeking Opinions On Transactions....
Miscellaneous
Thread ID:
00655833
Message ID:
00655833
Views:
47
Looking to get some input from others who have already done similar things. I have a form with a tab control on it. On these tabs there are multiple TreeView objects. When the user clicks on a node item the corresponding data is called from SQL server and displayed in etxt boxes. The problem I am having is how to store the data when new items are added. I don't want the new items to be added until the user clicks save so I have to temporarily store the data somewhere first. Originally I was using dynamic arrays to store all of the data but I figured these would amass in size at some point and not be efficient. I'm worried that using arrays will suck up too much memory on the client. Alternatively, I could use the arrays to only store the new items but I haven't tried that yet. So now I am thinking about using a temporary table on the server to store the new records, then when the user clikcs save, itterate through the table and do batch transactions with stored procedures for the updates. So if you have an opinion or an idea around this I'd love to hear it. Thanks.
Next
Reply
Map
View

Click here to load this message in the networking platform