dbase files under rebol ???
[1/11] from: ronaldoff::free::fr at: 15-Oct-2003 22:46
Hello rebol-list,
Is it possible to work with .dbf files under REBOL ??
If yes, how do you do that ?
Thanks in advance.
--
Best regards,
ronaldoff
[ronaldoff--free--fr]
[2/11] from: petr:krenzelok:trz:cz at: 15-Oct-2003 23:26
ronaldoff wrote:
>Hello rebol-list,
>
> Is it possible to work with .dbf files under REBOL ??
>
> If yes, how do you do that ?
>
REBOL Command + ODBC drivers (I personally use Advantage Database server
ODBC).... I also saw some dbf reader on rebolfrance site, but I doubt it
will be robust enough to work efficiently with dbase files.
-pekr-
[3/11] from: greggirwin:mindspring at: 15-Oct-2003 17:02
Hi Ronald,
r> Is it possible to work with .dbf files under REBOL ??
Like Petr, I've only seen a couple REBOL script implementations that
do some basics. For real work, Command might be your best bet.
-- Gregg
[4/11] from: tim:johnsons-web at: 15-Oct-2003 16:02
* Gregg Irwin <[greggirwin--mindspring--com]> [031015 15:18]:
> Hi Ronald,
>
> r> Is it possible to work with .dbf files under REBOL ??
>
> Like Petr, I've only seen a couple REBOL script implementations that
> do some basics. For real work, Command might be your best bet.
The dbf file format is a known (and fairly simple) layout.
I once did a project with C using raw file I/O on dbf files.
And example of .dbf layout is at
http://www.geocities.com/geoff_wass/dBASE/GaryWhite/dBASE/FAQ/qformt.htm
Given this information, one *should* be able to parse a .dbf file
on a binary port with just rebol/core.
Just don't do a skip in a port open in binary. RT hasn't
fixed that one yet.
tj
> -- Gregg
>
> --
> To unsubscribe from this list, just send an email to
> [rebol-request--rebol--com] with unsubscribe as the subject.
--
Tim Johnson <[tim--johnsons-web--com]>
http://www.alaska-internet-solutions.com
[5/11] from: g:santilli:tiscalinet:it at: 16-Oct-2003 9:45
Hi ronaldoff,
On Wednesday, October 15, 2003, 10:46:27 PM, you wrote:
r> Is it possible to work with .dbf files under REBOL ??
I have a very basic DBF parser that I just used to extract some
data from a bunch of DBF files. I did it in a hurry so don't
expect anything good, ;) but it could be a start, so let me know
if you want me to post the code. (Note: there are various versions
of DBF around, I was only interested in one, so maybe this won't
work for you.)
Regards,
Gabriele.
--
Gabriele Santilli <[g--santilli--tiscalinet--it]> -- REBOL Programmer
Amiga Group Italia sez. L'Aquila --- SOON: http://www.rebol.it/
[6/11] from: petr:krenzelok:trz:cz at: 16-Oct-2003 12:32
Tim Johnson wrote:
>* Gregg Irwin <[greggirwin--mindspring--com]> [031015 15:18]:
>>Hi Ronald,
<<quoted lines omitted: 13>>
> Just don't do a skip in a port open in binary. RT hasn't
> fixed that one yet.
I think it is possible, but I would not use such solution. First, as you
said - open/skip is buggy for 3 years at least and I really don't
understand RT not fixing the problem. Second - once there are index
files involved, memo files etc., shared db access, things start to
complicate and I would warn from trying to change some data in database
that raw way :-) For some basic data extraction simple parser aproach
should work, but - I use 50MB databases, almost two hunderds of
collumns, relations, etc. :-) Command + /ODBC is good value here, really ...
-pekr-
[7/11] from: fjouen:free at: 16-Oct-2003 15:28
Hi
You can find a dbase viewer in rebol on the rebol france server:
http://www.rebolfrance.org/telechargement.html/dbview. I wrote this
program some year ago and it could be improved.
Best regards from Paris
François Jouen
Laboratoire Développement Complexité & Informatique
Ecole Pratique des Hautes Etudes
41, rue Gay-Lussac F-75005 Paris
Tél: 33 (0)1 44 10 78 83
Fax: 33 (0)1 43 26 88 16
e-mail: [fjouen--ephe-sorbonne--org]
[fjouen--free--fr]
[8/11] from: greggirwin:mindspring at: 16-Oct-2003 17:30
Hi Petr,
PK> I think it is possible, but I would not use such solution.
I actually think it would be great to have a free REBOL dBase module,
and I don't think it would be that hard (especially since François and
Gabriele have given us starting points). Yes, there are some
variations to account for, but handling 95% of the cases shouldn't be
too much.
I have a folder set aside for doing it, but it hasn't made it to the
top of my list. :)
-- Gregg
[9/11] from: carlos:lorenz:bol at: 16-Oct-2003 23:32
> I actually think it would be great to have a free REBOL dBase module,
> and I don't think it would be that hard (especially since François and
> Gabriele have given us starting points).
> -- Gregg
As a Visual Fox Pro developer I'd love to have such module :)))))
Carlos
[10/11] from: petr:krenzelok:trz:cz at: 17-Oct-2003 10:23
Gregg Irwin wrote:
>Hi Petr,
>PK> I think it is possible, but I would not use such solution.
<<quoted lines omitted: 3>>
>variations to account for, but handling 95% of the cases shouldn't be
>too much.
well, it always starts the easy way and complicates later. All I wanted
to say is - that any such stuff without support for indexing, updating
databases, sharing/locking, is not practically of much use. And once you
decide to reimplement CA-Clipper of FoxPro in Rebol not even having
open/skip working, let me know, it will be at least interesting to
watch :-)
Just kidding - not trying to distract from any such activity ...
cheers,
-pekr-
[11/11] from: greggirwin:mindspring at: 17-Oct-2003 10:36
Hi Petr,
PK> well, it always starts the easy way and complicates later. All I wanted
PK> to say is - that any such stuff without support for indexing, updating
PK> databases, sharing/locking, is not practically of much use. And once you
PK> decide to reimplement CA-Clipper of FoxPro in Rebol not even having
PK> open/skip working, let me know, it will be at least interesting to
PK> watch :-)
Yes, certain things complicate matters (SKIP being one of my main
deterrents on things like this), but I used to use a dBase
engine--under VB1--that was written entirely in pure VB and it worked
extremely well, with support for indexes, memos, etc.. Of course, I
wasn't going against 50M DBs... :)
Without SKIP working properly, it would be a real PAIN just because of
how you'd have to make it work.
-- Gregg
Notes
- Quoted lines have been omitted from some messages.
View the message alone to see the lines that have been omitted