Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best way to handle cursors..?
Message
 
À
15/01/2013 23:44:25
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Versions des environnements
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01562212
Message ID:
01562943
Vues:
36
>>>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform