OpenEuphoria

Re: eds tables

• Posted by a.c.harper at btinternet.com May 30, 2002
• 456 views

----- Original Message -----
From: "rudy toews" <rltoews at ilos.net>
To: "EUforum" <EUforum at topica.com>
Subject: eds tables


>
>
> hi all,
> i have been trying to work on a table cross-reference addon for the eds
> database.e.  i am using version .5.
> stress.ex will have problems with my code, but createdb and addone work
> ok. the database looks like it should.
> i am trying to use a table in the current database to hold references to
> the other tables. whenever a record gets deleted or a table gets
> deleted, the pointers in database.e get corrupted and the wrong table is
> pointed to. this will cause the reference table to start collecting data
> meant for other tables.
> i believe the way garbage collection is done causes this to happen.
> i have tried to select the current table again but it does not help.
>
snip
>
I'm not sure what you are trying to do, but if you want to know which tables
exist in a database you can use the command
 s = db_table_list() which returns a sequence of all the tables in a
database.

My own enhanced EDS interface (Recent User Contributions February 26)
provides a 'wrapper' for handling records, tables and databases. I found the
tricky bit was keeping track of the current database, table or record -
although I too set up a Control table by default (for recording various
parameters rather than tables). The Control table contains a 'commit' record
which holds a snapshot of tables and record counts per table everytime a
commit command is issued.

Hope that helps,

A.C Harper