Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dataenvironment
Message
From
28/07/2009 08:07:42
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01414908
Message ID:
01415011
Views:
45
This message has been marked as a message which has helped to the initial question of the thread.
>The "cursors" I've been using for years in DE are just results from USE command
>But dealing with cursors from SQL commands seems more complex than DE "cursors"
>
>Now there are just some doubts:
>Which are the advantages of using SQL, instead of DE cursors?
>Will I have quicker search ? Is data corruption less likely to happen ?

If you are re-thinking your approach on using DE-cursors/views/Slect-cursors,
I'd reccommend you take a few H and research cursoradapters.
There are some white papers / session notes about them...

They are not perfect (see the wiki for some of the not-so-wonderful-aspects)
they are IMHO the easiest way to abstract data usage in out-of-the-box vfp
(from backend type over access type as well as support in the design tools).

Other approaches might be Andy Krameks data classes or xCase -
especially with a fwk supporting xCase or dbcX.

my 0.02 EUR

thomas
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform