Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Relating Two Tables
Message
 
To
18/12/2005 20:50:27
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01077578
Message ID:
01079069
Views:
47
>Sorry, all of that is your opinion. Record oriented xbase coding is what is so yesterday. More people dance with the SQL lady than the xbase queen.

SQL is great for transacting with DBs that require it. VFP is cleaner with XBase. Without iterative (record pointer) skills the developer cannot feed an OCX.

If you're using SQL, when you have an opportunity to use SEEK, then you're denying yourself and your users the best that VFP can offer. SELECTS require a lot of resources. They clog the work area, they clog the TEMP folder. Lets say you SELECT into a coursor then iterate the cursor to feed OCX. Look at how many steps you're going through.

There is a little project in downloads that uses seeks - only has two files - do you think it could be made to perform better by substituting SELECTS for the SEEKs?

I think performance would be seriously degraded by switching to SELECTS. It would be interesting to see a side by side.
Imagination is more important than knowledge
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform