gjs@faust.UUCP (11/15/85)
> The application involves in part Drug side effects. Some drugs have > only a few side effects, some have up to 20-30. The Cornerstone demo gives > the impression that Cornerstone will adjust to just the number of records > entered without having to predefine a maximum number. There are at least > three other parameters that are highly variable in number, so this is an > important feature. > Since dBase is a more widely occuring program, I was wondering, does > dBase also do this? > Does Reflex (formerly from Analytica, now from Borland) have this > capability? If it did, this might be the program of choice just on Price > considerations. I recently searched for a database program which would allow multiple values in a field, e.g. several phone numbers for a client or some number of movements in a piece of music. The only ones I found are Cornerstone and DayFlo. I also examined dBase III, Rbase 4000, Reflex, Condor, DataBase Manager II, and the Software Digest reviews. Cornerstone allows up to 255 values per field. Strings are truly variable length, so there is very little space overhead. A search in a field will match on any of the values, but a sort goes by just the first value. A truly relational database allows you to establish a one-to-many relation, but it takes more work to set up the database files and the report formats. -- George Snyder -- Intermetrics Inc. -- inmet!gjs --