General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Andrew,
Please do the following:
Create a database called DeleteMe. Add Table1 (Field1 C(10), Field2 I). Put a Primary or Candidate index on each field. Don't add any records.
Go into MS Access and link to DeleteMe. (You'll need to make a datasource or whatever.)
Start adding records:
Add "abcde", 0
Add "abcde", 0 again.
Decide by what happens whether indexes are updated properly when VFP databases are used through ODBC. (If you're still not sure, post back and I'll tell you what happened when I did it.)
Lesson, don't assume, perform a simple test. You'll learn a few things along the way! ;-)
>Well, does the VFP ODBC driver update indexes correctly? If so, then I can index. I had assumed that it did not. I have already discovered that, despite the MDAC documentation, the ODBC driver is not thread-safe.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only