On Sun, 21 Aug 2005 12:38:30 +0300 Παναγιώτης Σιδηρόπουλος <[EMAIL PROTECTED]> wrote:
> > How big are the .dbf, and .mdx file ? > > .dbf is 16.4 MB > .fpt is 40.2 MB > .mdx is 24.6 MB Ok, so .mdx is not trivially small. > > > What I need is to simply seaqrch fr specific values on this database. I > > > use following piece of code to search for records: > > > > > > CurrentDictionaryTable.IndexName := 'I_NAME'; > > > StrPCopy( pcharDescription, '<an existing value>' ); > > > if CurrentDictionaryTable.SearchKeyPChar( pcharDescription, > > > stGreaterEqual ) then begin Instead of pcharDescription, try a hardcoded string, of which you are sure it's in the database. > > > Variables are properly initialized. > > > TFBD's TableLevel property is set to 25. > > > Can anyone tell me what is wrong? > > > > Can you send me a test project (.dbf+test code) that reproduces the problem? > > It is quite big for delivering through Internet. > DBF file is properly displayed in a dbgrid. > > The problem is as simple as this: you have a string field indexed .dbf > file (tablelevel is 25 if it is crusial). Can you SearchKey or > SearchKeyPChar? and how? SearchKey/SearchKeyPChar work; at least I've seen them working ;-). > If you think it will help, I can prepare a small sample project, please > just ask. Compress your data into a .zip file (or 7z or whatever), and upload to: ftp://neli.hopto.org/incoming/tdbf into a custom-created directory with short name. Note that you cannot read your uploaded files. Micha _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
