New topic: Sqlite
<http://forums.realsoftware.com/viewtopic.php?t=47587> Page 1 of 1 [ 3 posts ] Previous topic | Next topic Author Message jetpr Post subject: SqlitePosted: Sat Apr 13, 2013 5:53 pm Joined: Wed Sep 20, 2006 5:12 pm Posts: 641 Location: Puerto Rico Hi If any one have a class to compare two table and sync the Fields _________________ Thanks for any contribution and God blesses all (I start Using RS in 10/12/2010) Mac Mini with Lion v10.7.5 and Real Studio 2012r1 Pro And Windows 7 RS2012r1 Personal and Linux RS2012r1 Personal Register user my Hobbies R/C Turbines Jets Models Top DaveS Post subject: Re: SqlitePosted: Sat Apr 13, 2013 6:33 pm Joined: Sun Aug 05, 2007 10:46 am Posts: 4753 Location: San Diego, CA If you are just talking about including whole RECORDS the are in one table and not another.. Then just CREATE table3 AS SELECT a.* FROM table1 a UNION SELECT b.* FROM table2 b; Union will automatically DISTINCT the records for you. If you are talking about synching FIELDS within RECORDS..... good luck _________________ Dave Sisemore iMac I7[2012], OSX Mountain Lion 10.8.3 RB2012r2.1 Note : I am not interested in any solutions that involve custom Plug-ins of any kind Top jetpr Post subject: Re: SqlitePosted: Sat Apr 13, 2013 6:48 pm Joined: Wed Sep 20, 2006 5:12 pm Posts: 641 Location: Puerto Rico I am talking about compare fields with out the Data Like Db1 to Db2 and Fields my Db1 is the Control and Db2 is the One is Working _________________ Thanks for any contribution and God blesses all (I start Using RS in 10/12/2010) Mac Mini with Lion v10.7.5 and Real Studio 2012r1 Pro And Windows 7 RS2012r1 Personal and Linux RS2012r1 Personal Register user my Hobbies R/C Turbines Jets Models Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 3 posts ] -- 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]
