Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best way to handle cursors..?
Message
From
15/01/2013 11:34:43
 
 
To
14/01/2013 10:37:53
General information
Forum:
ASP.NET
Category:
Other
Environment versions
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01562212
Message ID:
01562650
Views:
46
Look into static variables.

>As an example, one of the cursors tracks content balancing for the test. We need X number of this type, Y number of that type, etc, up to a max number. After each question is 'used', the counter for that questions type gets updated by 1, and the property value for that type gets recalculated. That property value then gets used to other calculations to select the next question
>
>
>
>
>>Not sure about E/F and I think it's part of .net, so I'm not sure you need approval.
>>
>>That being said, the closest to updatable cursors in VB.net are datatables. In fact it it's the closest I can think of to recordsets in ado. Not sure (again!) what you mean by "cursors that need to be updated between each questions displayed". As far as I know you cannot use dt in sql's like you could cursors; but you can Linq (good luck with that :) ). And you can (I think) bind datatables to datagridviews.
>>
>>Hope (doubt :)) this helps.
>>
>>Marc
>>
>>
>>
>>>With an up to 2 years approval process for new software, bringing in any kind of Framework is kinda out.
>>>
>>>
>>>>Use Entity Framework and create an instance of the entity.
>>>>
>>>>
>>>>>Hey All
>>>>>
>>>>>I'm in the process of translating/converting a VFP application to VB.Net and while I find a lot of my VB coming back to me, I've also found that how I used to do thing have changed, which is ok.
>>>>>
>>>>>However, I'm finding so many ways of handling cursors that's it's a little confusion-making.
>>>>>
>>>>>What I need to be able to do is create 2 update-able cursors that need to be updated between each question displayed. What's the best way to do this now?
>>>>>
>>>>>Dorris


Charles Hankey

Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy

Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.

-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin

Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
Previous
Reply
Map
View

Click here to load this message in the networking platform