database questions

Mark Wieder mwieder at ahsoftware.net
Sun Aug 3 13:37:00 EDT 2003


John-

I would suggest, though, that you rethink your database design so as
not to have 600 fields per record. On a guess, not knowing your
particular needs, I'd say that you might be better served with at
least a couple of tables, one with the client information, and one
with one record per exam question and uniquely identified by the
combination of clientID and questionID.

And *do* look into SDB for a native transcript DB implementation...

-Mark Wieder

Friday, August 1, 2003, 9:17:29 AM, you wrote:

JRB> I am a newbie. I am working on a project which will require that I
JRB> store data in a database (a separate record for each client, and about
JRB> six hundred fields per record). Each time it is used, it will need to
JRB> generate a new record for that client (it is a program that will 
JRB> administer and score an exam of sorts) My questions:





More information about the use-livecode mailing list