New topic: Related tables and Recordsets
<http://forums.realsoftware.com/viewtopic.php?t=38716> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message Paul Burnside Post subject: Related tables and RecordsetsPosted: Thu Apr 21, 2011 10:01 pm Joined: Mon May 08, 2006 8:50 pm Posts: 745 So, I'm still learning about SQLite, Recordsets, Tables and Relationships. I've been tinkering with a listbox that gets populated from a recordset and transparently saves data changes back to the table through the recordset using: rs.edit, rs.update and db.commit commands. All works fine when dealing with a single table. Now I am tinkering with a simple join of two tables. The recordset gets populated and, therefore, the listbox gets populated correctly BUT . . . . the transparent save doesn't work when the recordset is built on a JOIN of two tables. My guess is that it has something to do with how the tables were initially setup. That is to say that the database has no specific relational or referential commands attached to it to identify which tables are related. As mentioned above, the JOIN works fine for populating the recordset/listbox. Just doesn't work when saving back to the database. So, my question is . . . am I thinking right. Do I need to run an SQL command to setup some kind of permenant referential integrity between the two tables? Any comments would be appreciated. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
