How to Create Index on DBF Files using ado and vb6
-
Guys, I was assigned to convert an existing foxpro application into vb6. There's a module there in foxpro source code that will automatically create an index (cdx) on tables that has no index. The foxpro code goes something like this.. INDEX ON ALLTRIM(Prefix) + ALLTRIM(Rec_No) TAG PREREC OF TableName.CDX I've tried and researched all posible solution to convert this code into ado and vb6. Can anyone out there help me? Thanks! CHITZ :) -- modified at 5:26 Tuesday 17th January, 2006
-
Guys, I was assigned to convert an existing foxpro application into vb6. There's a module there in foxpro source code that will automatically create an index (cdx) on tables that has no index. The foxpro code goes something like this.. INDEX ON ALLTRIM(Prefix) + ALLTRIM(Rec_No) TAG PREREC OF TableName.CDX I've tried and researched all posible solution to convert this code into ado and vb6. Can anyone out there help me? Thanks! CHITZ :) -- modified at 5:26 Tuesday 17th January, 2006
I'm curious why you don't create the index while designing the database, or are you leaving the data in the FoxPro database and just creating a VB front end?
"The words of God are not like the oak leaf which dies and falls to the earth, but like the pine tree which stays green forever." - Native American Proverb
-
I'm curious why you don't create the index while designing the database, or are you leaving the data in the FoxPro database and just creating a VB front end?
"The words of God are not like the oak leaf which dies and falls to the earth, but like the pine tree which stays green forever." - Native American Proverb
Yah! These dbf files comes from our clients, they're just sending them to us to process, and not all of these foxpro tables have index. The task that was given to me is to change our current program's front end (from Visual Foxpro to VB6 since all of our projects are now created using VB6) while leaving the database input as is. I badly needed to index these tables automatically for the the program to process queries faster since these database contains huge amount of records and once i've performed a single query, the process is so slow :(. Also i think it's not applicable to create database index manually if the number dbf tables are not just one or two. Chitz :) -- modified at 23:36 Tuesday 17th January, 2006