Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best way to handle cursors..?
Message
 
To
15/01/2013 23:44:25
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:
01562943
Views:
37
>>>Most VFP apps are designed to use cursors (tables and views, basically the same thing).
>>
>>A cursor in VFP is a normalized object in memory that can be sql'd (read joined) together with actual tables in the DB. I still want to hear the argument that this was a bad idea.
>
>quite often the cursor is denormalized on purpose, for instance populating grids to show vendor name instead of key...

In fact you're right. A cursor is a temporary table, no more no less. In fact if you want cursors, you can simulate it with temporary files in the db. You would conceptually get the same effect. Operationally that's another pair of sleeves as we would say in Dutch. That being said, if you check out you temp folder ....

Thanks and take care.

If things have the tendency to go your way, do not worry. It won't last. Jules Renard.
Previous
Reply
Map
View

Click here to load this message in the networking platform