RE: eds tables
a.c.harper at btinternet.com wrote:
>
> ----- Original Message -----
> From: "rudy toews" <rltoews at ilos.net>
> To: "EUforum" <EUforum at topica.com>
> Sent: Thursday, May 30, 2002 6:57 PM
> 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
>
>
>
Thankyou A.C.
i had already downloaded it. didn't get time to really use it though.
i browsed it again after your answer.
Very Good Work!. Well Written.
it is well beyond what i had currently needed. but i will read more on
it. i like the idea of a 'scripting' language usuable by programs too.
my orignal idea was to create a cross reference of the tables in a
database. each database to stand on its own. i didn't want to have apps
needing mods or change database.e (working logic). i had wanted to stay
at a higher level, away from modifying code, just to use it.
this table could be used to 'rename' or give tables an alias name to
work with. maybe even multiple alias,each source or app having its own.
linking of records was a bit more deeper than i had intended.
but it might come in handy.
rudy
linkin
lotterywars
|
Not Categorized, Please Help
|
|
