1. dbase
- Posted by Daniel Berstein Zimmermann <dberst at CMETNET.CMET.NET> Oct 22, 1996
- 2033 views
- Last edited Oct 23, 1996
Marcel Kollenaar wrote: > I can tell you that I'm interested in databases. So likely I spend > my time on making access modules for indexfiles and databases. Hi Marcel, I'm also interested in databases. I have some expirience with Clipper 5.2 and other Xbase laguages, which use the standard .dbf file. By now I'm coding some functions that read and write .dbf files, and also some utility function for databases: a browse() function (like browse or dbedit of clipper, based in my menu engine) and some get() function with "pict" capability, and of course an indexing system. For what I've telled you I have an idea (even some functions are ready) of what to code, but for indexing (I expect to make it compatible to Dbase's NDX format or Clipper's NTX format) I just don't know where to start. If you have some specs of this formats I would be very thankful. I will post these function when they get more complete. I think it's great we could share our codes, but some codes posted in the listserver require tons of patience to understand their mechanics. I spend lots of time translating to English (the comments, the function names and the variable names) so they could be easily understood by everyone (hope), and be a source of ideas (hope too) for all. Regards, Daniel Berstein Z. Santiago de Chile dberst at cmet.net
2. Re: dbase
- Posted by Marcel Kollenaar <M.Kollenaar at SLO.NL> Oct 23, 1996
- 2008 views
Hi Daniel, Daniel Berstein Zimmermann wrote: > Hi Marcel, I'm also interested in databases. I have some expirience > with Clipper 5.2 and other Xbase laguages, which use the standard > .dbf file. By now I'm coding some functions that read and write > .dbf files, and also some utility function for databases: a browse() > function (like browse or dbedit of clipper, based in my menu engine) > and some get() function with "pict" capability, and of course an > indexing system. Thats the point....... > For what I've telled you I have an idea (even some functions are > ready) of what to code, but for indexing (I expect to make it > compatible to Dbase's NDX format or Clipper's NTX format) I just > don't know where to start. I had the same problem. I ask my girl friend where to start. She said: "In the middle." So I did. (No dirty joke gentlemen) I found a study book of Wirth "Data structures" and studied the B+tree section and started to code an tree insert, delete and search function. Made my own file structure and so on. I worked back and forth. I can tell you, If you've seen one you've seen them all. It's one principal easy to understand but huge to code. > If you have some specs of this formats I would be very thankful. I don't have have spec's of NDX, NTX format and I can't find information about it on the net. > I will post these function when they get more > complete. I think it's great we could share our codes, Yes, great I look forward to it. When I get my B+tree code stabilized and it does what it has to do I put it on the listserver. > but some > codes posted in the listserver require tons of patience to > understand their mechanics. I spend lots of time translating to You are right. It takes me also lots of time to study others code. > English (the comments, the function names and the variable names) > so they could be easily understood by everyone (hope), and be a > source of ideas (hope too) >for all. Thanks Daniel for your reply. Keep on coding .... A tip .... David Gay wrote some interesting indexing code to link two databases with common fields. I'm now studying this code and try to use it for an applycation I have in mind. Marcel Kollenaar M.Kollenaar at slo.nl The Netherlands
3. Re: dbase
- Posted by David Gay <moggie at INTERLOG.COM> Oct 23, 1996
- 1992 views
>A tip .... David Gay wrote some interesting indexing code to link two >databases with common fields. I'm now studying this code and try to >use it for an applycation I have in mind. How are those index build/link functions working for you anyways? :) I know it is barebones but I am working on features to better enhance and make it easier to use :) Have a good day! David Gay
4. Re: dbase
- Posted by Marcel Kollenaar <M.Kollenaar at SLO.NL> Oct 24, 1996
- 1959 views
Hi David, Sorry, I let you waiting for an answer for the usage of your INDEX.DB code. When I read your message yesterday I took some time last evening to study your code en looked at it through the debugger. > How are those index build/link functions working for you anyways? Excellent. I will use your idea and code for the report section of the database. Reports do need on the fly indexes to sort the output on for subgrouping or subreports. Not all the indexes will be present for those reports so I will make them with your INDEX_DB functions. In database terms I think they call it "Inverted files". I can use the functions also for sorting an entire database like the dBase function SORT(database on field). I do see also some minor disavantages (for me) because the whole database is sorted in memory. In the past I had problems with internal memory. So I have to keep the chunks of data I process (sort) within limits. I think I even have to do a merge sort in temporary disk files when the database is large. > I know it is barebones but I am working on features to better > enhance and make it easier to use :) If these are just barebones, I look forward to your next version. Thanks David and greetings, Marcel
5. Re: dbase
- Posted by Daniel Berstein Zimmermann <dberst at CMETNET.CMET.NET> Nov 04, 1996
- 1975 views
Marcel Kollenaar wrote: > > I will post these function when they get more > > complete. I think it's great we could share our codes, > > Yes, great I look forward to it. Voila... It's quite finished, I'm attaching you the routines and a quite pooor manual, no time for example programs... maybe next week I'll have a good example program. > A tip .... David Gay wrote some interesting indexing code to link two > databases with common fields. I'm now studying this code and try to > use it for an applycation I have in mind. I'm studying too... maybe I'll ask help directly to David. Sayonara! Daniel Berstein dberst at cmet.net (not dberst at CMETNET.net) Santiago de Chile
6. Re: dbase
- Posted by Daniel Berstein Zimmermann <dberst at CMETNET.CMET.NET> Nov 04, 1996
- 1974 views
--------------709727AB7F92 Oooops!!! I forgot to attach the file ;) Here it goes... --------------709727AB7F92
7. Re: dbase
- Posted by Jacques Deschenes <desja at QUEBECTEL.COM> Nov 05, 1996
- 1973 views
- Last edited Nov 06, 1996
I receive the dbase message of Mr. Daniel B. zimmermann, but Eudora didn`t decrypt the mime encoded zip file. I search eudora help to know How to extract the attachement but didn`t find any information about it. Is Anybody knows how to extract the file from the message? Jacques Deschenes Baie-Comeau, Quebec Canada desja at quebectel.com
8. Re: dbase
- Posted by Daniel Berstein Zimmermann <dberst at CMETNET.CMET.NET> Nov 06, 1996
- 1971 views
Jacques Deschenes wrote: > I receive the dbase message of Mr. Daniel B. zimmermann, but Eudora didn`t > decrypt > the mime encoded zip file. I search eudora help to know How to extract the > attachement > but didn`t find any information about it. > Is Anybody knows how to extract the file from the message? Don't know about Euodora, but you can find the file in The Euphoria Official page (Rob Craig), or if you want I'll sendig unzipped (the files were zipped and then attached to the mail) to you. Bye!! Daniel Berstein Zimmermann Santiago de Chile dberst at cmet.net
9. Re: dbase
- Posted by Matt Stancliff <sysop at ATL.MINDSPRING.COM> Nov 06, 1996
- 1977 views
>I receive the dbase message of Mr. Daniel B. zimmermann, but Eudora didn`t >decrypt >the mime encoded zip file. I search eudora help to know How to extract the >attachement >but didn`t find any information about it. >Is Anybody knows how to extract the file from the message? Most of the files I get are like that... all you can do is copy and paste the attachment part from Eudora to Write. You also want to check your settings under Tools, Options, Attachments then look to see if it says "Put attachemnt in body of message" Hope it helps, -Matt Stancliff
10. Re: dbase
- Posted by Marcel Kollenaar <M.Kollenaar at SLO.NL> Nov 06, 1996
- 1971 views
Daniel, I can't read this code .... Can you send the code in plain ASCII. Marcel > > --------------709727AB7F92 > > Oooops!!! I forgot to attach the file ;) > > Here it goes... > > --------------709727AB7F92
11. Re: dbase
- Posted by Ad Rienks <106075.266 at COMPUSERVE.COM> Nov 06, 1996
- 2016 views
Marcel Kollenaar wrote: >Poster: Marcel Kollenaar <M.Kollenaar at SLO.NL> >Subject: Re: dbase >-------------------------------------------------------------------------- ----- >Daniel, >I can't read this code .... Can you send the code in plain ASCII. >Marcel Hi Marcel and others, I had this problem too, but I found the program XFERPRO by SabaSoft (on NLINTERNET, but I'm sure it can be found somewhere else too). This program decodes MIME, UUE, XXE etc., in short, encrypted and encoded files. For me this has worked well. Ad Rienks