Hi all,
I am new to VB2005 and need help.
I have some data in dbf and I need to find some records in them. How do I set indexes for this files.
Many thanks
Regards
Trivun
dbf index in vb2005
Hot Topic
- Remoting with Interface hangs
- VB.NET Database usage
- identifying parent element
- SmtpClient sends mail more than once
- Porting ActiveX control to x64
- My remoting application work on XP but does not work on Windows Server 2003
- How can I edit values in an XML document?
- Timeout in WinHttp object
- How do I check if object locked?
- Detecting Proxy Server in VB Net 05
.NET Development
- Exception "Object reference not set to an instance of an object." at changing the value of dataRow[myColumns]
- Socket.BeginReceive - benefit passing in a list of buffers?
- ASCII characters
- DoEvents not available under My.Application
- IHasXmlNode and XPathNavigator
- Using FtpWebRequest to check if a directory exists.
- XPathNavigator and mixed content
- Multithreading, MsgBox causes an Error
- XmlDocument.Load() in .NET 2.0 generating confusing System.IO.IOExceptions
- How can i accesses my static variable from one class to another ?
dbf index in vb2005
daviesl
Hi Trivun,
Although there is more than one program that creates DBF files, I'll assume your DBFs are FoxPro DBFs. There are two types of indexes for FoxPro DBFs. One will have an IDX extension and the other will have a CDX extension. The IDX indexes are seldom used any more so I'll assume you have a CDX file with the same name as the table you want to access.
The FoxPro data engine will automatically make use of any indexes that are appropriate depending on the expressions in the Join or Where clauses of your SQL statement.
Can you give more details about your situation