Home > Archive > Clipper > April 2006 > Need a good, (hopefully free) DBF editor
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Need a good, (hopefully free) DBF editor
|
|
| cgallery@gmail.com 2006-04-07, 3:55 am |
| I had been using dBASE III 1.0 and 1.1 to do some "massaging" of DBF
files. Once I started using X-Harbour/Minigui I had the "Not a dBASE
file"
message whenever I used a Minigui-compiled application to manipulate a
DBF file and then tried to open that file in dBASE III. So I found a
date patch for dBASE which fixed that.
But now I'm getting some larger files, with 1.3M records (about 177-
MB). And when I use dBASE III 1.0 and 1.1 to, for example, modify the
struture (add/delete fields, etc.), I get crashes. I think I have
reached the limit of what dBASE III can accomplish? I am running on
Windows XP Pro.
Are there any suggestions for tools I can use that are: (1) Hopefully
free, (2) Able to search, edit, etc., DBF files. I sorta like DOS-
Window stuff. I really prefer having a command-line instead of all
menu. But I'm open to all suggestions.
Thanks!
Phil
| |
| Ron Pinkas 2006-04-07, 3:55 am |
| Phil
> Are there any suggestions for tools I can use that are: (1) Hopefully
> free, (2) Able to search, edit, etc., DBF files. I sorta like DOS-
> Window stuff. I really prefer having a command-line instead of all
> menu. But I'm open to all suggestions.
Did you try xbScript DOT mode?
Ron
| |
|
| Phil,
I already mail you VRUNFOX which is windows dot prompt similar to dbase3 dot
prompt.
It is actually a command line dbf utility for foxpro.
You can apply almost all clipper commands : USE,
LOCATE,SEEK,REPLACE,DELETE,PACK,ZAP,etc.
Regards
Hoe
| |
| Michael Baumann 2006-04-07, 7:55 am |
| wrote:
> I had been using dBASE III 1.0 and 1.1 to do some "massaging" of DBF
> files. Once I started using X-Harbour/Minigui I had the "Not a dBASE
> file"
> message whenever I used a Minigui-compiled application to manipulate a
> DBF file and then tried to open that file in dBASE III. So I found a
> date patch for dBASE which fixed that.
>
> But now I'm getting some larger files, with 1.3M records (about 177-
> MB). And when I use dBASE III 1.0 and 1.1 to, for example, modify the
> struture (add/delete fields, etc.), I get crashes. I think I have
> reached the limit of what dBASE III can accomplish? I am running on
> Windows XP Pro.
>
> Are there any suggestions for tools I can use that are: (1) Hopefully
> free, (2) Able to search, edit, etc., DBF files. I sorta like DOS-
> Window stuff. I really prefer having a command-line instead of all
> menu. But I'm open to all suggestions.
>
> Thanks!
> Phil
>
Hello Phil,
What about dbu (source code delivered with Clipper 5.x)? It's better
than dBase, but not realy good ...
I personaly use dbMax written by David A. Kennedy in the early 90th in
the last century ;-)
Just take look to
http://www.the-oasis.net/ftpmaster....nt=ftputils.htm
and search for dbx130.zip
You can configurate and compile your "own" dbMax if you are using user
defined function calls in index expressions.
HTH
Regards
Michael
| |
|
| I use Foxpro for this. It is not free but maybe you can find an older
version floating around cheap. Look for the old DOS version if you
want DOS-Window.
Mike
| |
| cgallery@gmail.com 2006-04-07, 6:55 pm |
| Thanks for all the tips. DBU I guess does help. At least it doesn't
crash when manipulating large files. I tried some of the "dot"
packages mentioned but they require a different syntax, I guess, as
commands like "list" just generate errors. Am I missing something?
Does FoxPro work w/ NTX files?
Mike wrote:
> I use Foxpro for this. It is not free but maybe you can find an older
> version floating around cheap. Look for the old DOS version if you
> want DOS-Window.
>
> Mike
| |
|
| No. I do it all the time with fox (append, replace all, browse..).
Just reindex when back in the Clipper app.
| |
| Mahanimann 2006-04-07, 6:55 pm |
| I too used dBase III, but with CDX indexes? No, so I fumbled around and
found dClip, and in my opinion there is nothing like it. It's a 'pure'
dBase clone, but with enormous extensions. Supports a lot of RDDs (also
Advantage I think). Have a look here (it's free):
http://donnay-software.com/
Mahanimann
<cgallery@gmail.com> skrev i melding
news:1144380890.783934.98960@j33g2000cwa.googlegroups.com...
>I had been using dBASE III 1.0 and 1.1 to do some "massaging" of DBF
> files. Once I started using X-Harbour/Minigui I had the "Not a dBASE
> file"
> message whenever I used a Minigui-compiled application to manipulate a
> DBF file and then tried to open that file in dBASE III. So I found a
> date patch for dBASE which fixed that.
>
> But now I'm getting some larger files, with 1.3M records (about 177-
> MB). And when I use dBASE III 1.0 and 1.1 to, for example, modify the
> struture (add/delete fields, etc.), I get crashes. I think I have
> reached the limit of what dBASE III can accomplish? I am running on
> Windows XP Pro.
>
> Are there any suggestions for tools I can use that are: (1) Hopefully
> free, (2) Able to search, edit, etc., DBF files. I sorta like DOS-
> Window stuff. I really prefer having a command-line instead of all
> menu. But I'm open to all suggestions.
>
> Thanks!
> Phil
>
| |
| cgallery@gmail.com 2006-04-07, 6:55 pm |
| Hey, dClip-Free is pretty neat and exactly what I was looking for!
Thanks for the tip Mahanimann!
-Phil
| |
|
| Did you try to use DBF Manager? It's not free and doesn't have command
line. But interface is near to dbu.
| |
| Martin 2006-04-25, 6:55 pm |
| DBU
|
|
|
|
|