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
IRC channel
GIT
Mailing List
Other languages
Foundation
Website
Useful Wiki Links
Project Roadmap
Getting the Source
Screenshots
How to use the forum
About donations (wiki)
Bookstore
Computer Math and Games in Pascal
(preview)
Lazarus Handbook
Search
Advanced search
Recent
Lazarus for Windows on aa...
by
Wallaby
[April 23, 2024, 11:46:56 pm]
Parameter passing odditie...
by
KodeZwerg
[April 23, 2024, 11:04:39 pm]
Can function be used for ...
by
jamie
[April 23, 2024, 10:53:10 pm]
(Solved) TIndexedAVLTree ...
by
lainz
[April 23, 2024, 10:49:03 pm]
Demo Scene Picture sinwav...
by
KodeZwerg
[April 23, 2024, 10:26:21 pm]
fkInternalCalc
by
zraja
[April 23, 2024, 09:31:07 pm]
A fairly simple sound sol...
by
KodeZwerg
[April 23, 2024, 09:23:37 pm]
add new targets to make
by
marcov
[April 23, 2024, 08:38:42 pm]
how to tweek fpmake to co...
by
marcov
[April 23, 2024, 08:29:16 pm]
Quirky windows
by
ASerge
[April 23, 2024, 07:07:16 pm]
[Request] Demo Scene Sub ...
by
Gigatron
[April 23, 2024, 06:29:39 pm]
Unlocking Files
by
KodeZwerg
[April 23, 2024, 06:03:08 pm]
[SOLVED] trunk bug for mi...
by
Key-Real
[April 23, 2024, 05:56:32 pm]
Demo Scene Bitmap Font Sc...
by
Gigatron
[April 23, 2024, 05:56:27 pm]
Compile/Convert Delphi pr...
by
Martin_fr
[April 23, 2024, 05:43:11 pm]
Generics - correct syntax
by
Thaddy
[April 23, 2024, 05:40:59 pm]
InstallAware Using Lazaru...
by
msintle
[April 23, 2024, 05:26:36 pm]
Xcode Command Line Tools ...
by
Joseph
[April 23, 2024, 05:16:39 pm]
Offical launch of the 1 B...
by
Hartmut
[April 23, 2024, 04:49:29 pm]
what to do if my target M...
by
nickysn
[April 23, 2024, 04:16:02 pm]
compiler error in unit
by
paule32
[April 23, 2024, 03:49:50 pm]
Multithreading - synchron...
by
mika
[April 23, 2024, 01:48:51 pm]
May be useful to somebody
by
KodeZwerg
[April 23, 2024, 12:38:22 pm]
match automatic highlight...
by
Чебурашка
[April 23, 2024, 11:35:14 am]
Tchart with dual numbers ...
by
wp
[April 23, 2024, 10:48:18 am]
« previous
next »
Print
Pages: [
1
]
Author
Topic: How do I create indexes for existing tdbf dbase file?? (Read 3693 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: 11458
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