And if you want your Lingo-based "database" to run faster, check out an article I wrote for DOUG many years ago at:

http://www.director-online.com/buildArticle.php?id=442

This describes a technique I use to store data in cast members as Lingo routines. I don't know if the timing is still accurate, but when I testing this approach against storing data as just text or field members, my approach was about seven times as fast.

Irv

At 11:26 AM +1200 6/9/04, Tony Bray wrote:
On 9 Jun 2004, at 0:37, Stephen Ingrum <[EMAIL PROTECTED]> wrote:
Details:
the "database" will be updated by only 1 (or maybe 2) people ever.
it will contain 1200-1500  entries
each entry will contain firstname, lastname, storenumber,
images(anywhere from 0-5), other misc textbased fields

For the last 4 years I have had a "database" running using external casts, of text members, to store similar information in lists.


i.e. each text cast member contains a record of [#uniqueStudentID:#app004,#firstname:"Fred", #lastname:"Bloggy", #phone:"678 789",etc]

I have 5 external casts (Apprentices, Employers, Coordinators, Credits, Notes) which are interlinked in my program by the uniqueID.

This database is updated on a more or less daily basis by 2 or 3 people.
The database is used to export Mail Merge files in Word, Spreadsheets in Excel, etc.


For the small number of records that you wish to use I would definitely use Lingo. An understanding of relational databases is a help, but in your case I do not think you will need that knowledge.

Just my $0.05 (we don't have 2 cent coins in NZ)

[To remove yourself from this list, or to change to digest mode, go to http://www.penworks.com/lingo-l.cgi To post messages to the list, email [EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED]). Lingo-L is for learning and helping with programming Lingo. Thanks!]


--

Multimedia Wrangler.

[To remove yourself from this list, or to change to digest mode, go to http://www.penworks.com/lingo-l.cgi To post messages to the list, email [EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED]). Lingo-L is for learning and helping with programming Lingo. Thanks!]

Reply via email to