Lazarus
Home
Help
TinyPortal
Search
Login
Register
Lazarus
»
Forum
»
Programming
»
Databases
»
How do I create indexes for existing tdbf dbase file??
Free Pascal
Website
Downloads
Wiki
Documentation
Bugtracker
Mailing List
Lazarus
Website
Downloads (Laz+FPC)
Packages (OPM)
FAQ
Wiki
Documentation (RTL/FCL/LCL)
Bugtracker
CCR Bugs
GIT
Mailing List
Other languages
Foundation
Website
Useful Wiki Links
Project Roadmap
Getting the Source
Screenshots
How to use the forum
Forum Rules
About donations (wiki)
Bookstore
Computer Math and Games in Pascal
(preview)
Lazarus Handbook
Search
Advanced search
Recent
FPC 3.2.4-rc1 available
by
Fred vS
[
Today
at 05:45:33 pm]
I hope FreePascal can sup...
by
Fibonacci
[
Today
at 04:22:41 pm]
FPC Unleashed (inline var...
by
ccrause
[
Today
at 04:10:31 pm]
Elite Arcade
by
Guva
[
Today
at 03:41:28 pm]
Building units fails afte...
by
NormanDunbar
[
Today
at 03:36:38 pm]
Little bit...
by
Thaddy
[
Today
at 02:19:01 pm]
[SOLVED] Cannot build Uni...
by
Thausand
[
Today
at 02:18:34 pm]
default pin settings, atm...
by
ccrause
[
Today
at 11:45:37 am]
TChart how setup nicestep...
by
eldonfsr
[
Today
at 05:18:14 am]
AI assisted translation o...
by
schuler
[
Today
at 03:07:59 am]
Can I get the position an...
by
wp
[
Today
at 12:23:04 am]
Translate .lfm file in a ...
by
wp
[
Today
at 12:07:11 am]
Playing video without to ...
by
n7800
[April 17, 2026, 11:51:39 pm]
Delimited text - how find...
by
n7800
[April 17, 2026, 11:28:25 pm]
overloading issues fpc3.2...
by
Martin_fr
[April 17, 2026, 10:21:07 pm]
Ann: Deinline: a de-inlin...
by
LeP
[April 17, 2026, 09:58:08 pm]
Seeking advice on setting...
by
schuler
[April 17, 2026, 03:36:28 pm]
Ann: DeCoperators
by
DomingoGP
[April 17, 2026, 03:23:39 pm]
Error: Compilation raised...
by
marcov
[April 17, 2026, 02:44:06 pm]
TLazSerial : serial port ...
by
CM630
[April 17, 2026, 09:50:34 am]
[Solved] Help needed comp...
by
landolfi
[April 17, 2026, 02:45:10 am]
DataPort or Synpase stat...
by
eldonfsr
[April 16, 2026, 11:32:18 pm]
[FPC 3.2.4, Windows] PTC ...
by
Fred vS
[April 16, 2026, 08:26:24 pm]
IDE: Property editor does...
by
dsiders
[April 16, 2026, 07:04:22 pm]
What is wrong with this c...
by
OH1KH
[April 16, 2026, 04:32:48 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: How do I create indexes for existing tdbf dbase file?? (Read 3918 times)
wpflum
Sr. Member
Posts: 287
How do I create indexes for existing tdbf dbase file??
«
on:
December 01, 2010, 09:00:55 pm »
I'm working on a program that uses dbase files created on another platform. I have not been able to find a way to create indexes for these files on the other system so I figured I'd have to look at a way to handle it on the Pascal side. Originally I wasn't going to use to even bother with indexes since the data was limited but the data keeps growing in complexity and amount so now I'm seeing lags I'd like to fix if possible. Can I create temporary indexes in memory for the couple of files I think I need them for or write them out to a local directory and use them from there?? The dbase files are on a networked drive and I'd rather not have individual machines trying to create indexes and write them back to the drive. Worse comes to worse I can try to write a console program in Lazarus/FPC and get it to work on the other system to create the indexes on the networked drive but I still need to know/understand how to do that.
Help!!
Logged
marcov
Administrator
Hero Member
Posts: 12783
FPC developer.
Re: How do I create indexes for existing tdbf dbase file??
«
Reply #1 on:
December 02, 2010, 11:43:06 pm »
There is a tdbf.regenerateindexes procedure, as well as .addindex, compactindex etc.
I know it is possible, (I did it at a former employer, but don't have the code anymore)but there are several types of indexes for DBF.
Logged
Print
Pages: [
1
]
« previous
next »
Lazarus
»
Forum
»
Programming
»
Databases
»
How do I create indexes for existing tdbf dbase file??
TinyPortal
© 2005-2018