Re: Bible as EDS Database
- Posted by Sabal.Mike at notations.com Sep 08, 2003
- 441 views
If you're using EDS, create a secondary key as {Book name, chapter, verse, unique verse ID} and search on the secondary key. Although, if this is your primary application, you may just be better off making the primary key {Book name, chapter, verse} and using the unique verse ID only for true SQL requirements. >>> cklester at yahoo.com 09/08/2003 3:30:09 PM >>> Okay, I've got a 5+MB EDS (EuSQL) database formatted thusly: 1. unique verse ID (1-31102) 2. book name 3. chapter # 4. verse # 5. text What's the fastest way to look up, say, "Revelation 21:14," using an SQL query or the EDS way?