Yet another approach ...
I've been using V12 for my current project and it would be able to
handle the types of things you are talking about very easily.
Rather than keeping pictures, audio files, video, etc.'s in the
database, we put the file name (or cast member name) of pictures,
audio and videoclips into the database, then my code finds and uses
the proper assets at run time.
V12 allows you to have multiple "tables" in a single database file.
For example, one table is my main table that has records that
describe each "page" in my program. When I get to a new "page", the
frame in the score must have a label, I use this label as a key into
the main database and I get back a string of what background picture
to show, what sound file to play, and what text to display on the
page, etc. Another table in the same database file is a simple
translation table. This table consists of only 2 fields, a word (a
key) and a translation. Whenever I want to output a string, I pass
in a key, and it passes back the translation. This way, my client
can change the wording of any strings in the program at any time, and
will eventually be able to translate the product if they wish.
For each "table" that we use, the client builds one tab-delimited
text file. Based on V12's documentation, I wrote a database builder
tool that reads these text files and creates a single V12 database
file. This way, the client can make as many changes to the database
tables that they wish without affecting my work.
Works for me,
Irv
At 9:37 PM +0100 11/20/01, Brennan wrote:
>Hi folks,
>
>I'm relying on the fact that many of you know me well enough (at
>least digitally) to give a more or less personalized answer here.
>
>I'm looking at a kiosk project right now which suggests that a
>database would be a good solution. Much of the source material is
>not yet digitized and none is in a database yet, but there is an
>existing database of material which may conceivably be incorporated
>into the kiosk in a future version - but not this version.
>
>The materials are mixed media - pictures, audio files, video clips
>and (of course) text.
>
<snip>
--
Lingo / Director / Shockwave development for all occasions.
(Home-made Lingo cooked up fresh every day just for you.)
[To remove yourself from this list, or to change to digest mode, go to
http://www.penworks.com/LUJ/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!]
