1. dbase

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

new topic     » topic index » view message » categorize

2. Re: dbase

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

new topic     » goto parent     » topic index » view message » categorize

3. Re: dbase

>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

new topic     » goto parent     » topic index » view message » categorize

4. Re: dbase

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

new topic     » goto parent     » topic index » view message » categorize

5. Re: dbase

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

new topic     » goto parent     » topic index » view message » categorize

6. Re: dbase

--------------709727AB7F92

Oooops!!! I forgot to attach the file ;)

        Here it goes...

--------------709727AB7F92

new topic     » goto parent     » topic index » view message » categorize

7. Re: dbase

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

new topic     » goto parent     » topic index » view message » categorize

8. Re: dbase

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

new topic     » goto parent     » topic index » view message » categorize

9. Re: dbase

>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

new topic     » goto parent     » topic index » view message » categorize

10. Re: dbase

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

new topic     » goto parent     » topic index » view message » categorize

11. Re: dbase

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

new topic     » goto parent     » topic index » view message » categorize

Search



Quick Links

User menu

Not signed in.

Misc Menu