1. EDB with Fields
I was wondering if those with EDB viewers could easily modify their
programs to do the following:
1. If a key = 0, label that record as "FIELD NAMES"
2. If a record exists where key = 0, use the sequence in that record to
NAME the data in other records
For instance, if this record exists:
key = 0
data = { "Date","Time","User Name","Path" }
Then data for this record:
key = 879283
data = { "05/10/02","12:15:17","cklester","C:\\Program Files\\Microsoft
Office\\Templates"}
would display like this:
Key: 879283
Date: 05/10/02
Time: 12:15:17
User Name: cklester
Path: C:\Program Files\Microsoft Office\Templates
(or something similar)
I've modified database.e to handle the referencing of data using field
names. For instance, I can use the following:
data = get_data( {"Date","Time","Path"}, "User Name", "cklester")
Basically, this says, "Return the data items of 'Date,' 'Time,' and
'Path' for each record where 'User Name' equals 'cklester.'"
The sequence data would then equal { "05/10/02" , "12:15:17" ,
"C:\Program Files\Microsoft Office\Templates" }.
For me, this is an easier way to reference data in a database.
Also, I've modified db_insert(x,y) so that if x = DB_UNIQUE_KEY (a new
global constant), a random unique key will automatically be generated
for that record.
I'm planning on making the following additions:
key = -1 is an input mask for each field; the db manager could use this
to limit input
key = -2 is a "Display Name" list of field names; for instance, if I
have a field named "DOB," the display name could be "Date of Birth."
Again, the db manager would need to utilize this.
key = -3 is a relationships sequence; this stores foreign keys (I think)
If anybody has any other suggestions or hints/tips/tricks, please let me
know.
Thanks!
ck
2. Re: EDB with Fields
- Posted by tone.skoda at siol.net
May 31, 2002
----- Original Message -----
From: "C. K. Lester" <cklester at yahoo.com>
> I was wondering if those with EDB viewers could easily modify their
> programs to do the following:
Are you talking about EDS GUI?
> For instance, if this record exists:
>
> key = 0
> data = { "Date","Time","User Name","Path" }
>
> Then data for this record:
>
> key = 879283
> data = { "05/10/02","12:15:17","cklester","C:\\Program Files\\Microsoft
> Office\\Templates"}
>
> would display like this:
>
> Key: 879283
> Date: 05/10/02
> Time: 12:15:17
> User Name: cklester
> Path: C:\Program Files\Microsoft Office\Templates
Will all data in one table have such format? If yes then I can replace
treeview with listview.
If not all records in table will have such format then I don't know how
would I do it, maybe as treeview items?
3. Re: EDB with Fields
- Posted by tone.skoda at siol.net
May 31, 2002
----- Original Message -----
From: "C. K. Lester" <cklester at yahoo.com>
> I was wondering if those with EDB viewers could easily modify their
> programs to do the following:
Are you talking about EDS GUI?
> For instance, if this record exists:
>
> key = 0
> data = { "Date","Time","User Name","Path" }
>
> Then data for this record:
>
> key = 879283
> data = { "05/10/02","12:15:17","cklester","C:\\Program Files\\Microsoft
> Office\\Templates"}
>
> would display like this:
>
> Key: 879283
> Date: 05/10/02
> Time: 12:15:17
> User Name: cklester
> Path: C:\Program Files\Microsoft Office\Templates
Will all data in one table have such format? If yes then I can replace
treeview with listview.
If not all records in table will have such format then I don't know how
would I do it, maybe as treeview items?
588
for <rds at rapideuphoria.com>; Fri, 31 May 2002 15:17:18 -0700 (PDT)
Received: from dialup-65.56.135.228.dial1.chicago1.level3.net ([65.56.135.228]
helo=9bbnf01)
by goose.prod.itd.earthlink.net with smtp (Exim 3.33 #2)
id 17Duhs-0001jk-00
for rds at RapidEuphoria.com; Fri, 31 May 2002 15:17:12 -0700
Message-ID: <000a01c208f0$d2ff11a0$e4873841@9bbnf01>
Reply-To: "raymundo haro" <torta at earthlink.net>
From: "raymundo haro" <torta at earthlink.net>
To: <rds at rapideuphoria.com>
Subject: help
Date: Fri, 31 May 2002 17:16:24 -0500
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0007_01C208C6.E423E660"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
X-Scanned-By: MIMEDefang 2.6 (www dot roaringpenguin dot com slash mimedefang)
This is a multi-part message in MIME format.
------=_NextPart_000_0007_01C208C6.E423E660
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
hello,
if anyone can please help me write my first program. i only programmed =
with commodore basic 14 years ago. i write simple programs, but cant run =
them with the interpter.=20
thank you, ray
------=_NextPart_000_0007_01C208C6.E423E660
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4611.1300" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>hello,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>if anyone can please help me write my =
first=20
program. i only programmed with commodore basic 14 years ago. i write =
simple=20
programs, but cant run them with the interpter. </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>thank you, =
------=_NextPart_000_0007_01C208C6.E423E660--
4. Re: EDB with Fields
- Posted by tone.skoda at siol.net
May 31, 2002
----- Original Message -----
From: "C. K. Lester" <cklester at yahoo.com>
> > Will all data in one table have such format? If yes then I can replace
> > treeview with listview.
> > If not all records in table will have such format then I don't know how
> > would I do it, maybe as treeview items?
>
> I'm thinking you could set up a table view or something and have the field
> names in the leftmost column and the field data in the rightmost column...
> no?
If all records will have data (keys will be dummy numbers?) which is
sequence with same number of
members then I would do it this way:
List view like Windows file explorer where files are listed with, in your
example, 5 columns:
Key Date Time User Name Path
879283 05/10/02 12:15:17 cklester C:\Progr..
... ... ... ... ...
This won't work/look good if there will be too many columns, so will
there be many columns, like more than 10?
Also all members of data must be strings or numbers, not nested sequence.
