Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

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