At this point, I have to give a shameless plug to my soon-to-be-released product, SQLMagic. If I were a marketing person, I'd probably come up with a slogan something like "SQLmagic, it makes your code disappear", but I'm not so I won't.... but it does :-)
Take a look at the video at the bottom of http://www.lcsql.com/sqlmagic.html to get a flavor for how it works. It shows how to create a three-table inquiry transaction complete with search capabilities in a few minutes without writing any Livecode scripts or figuring out any SQL statements. It's equally easy to create Insert, Update, and Delete processing, even mixing processing modes within one transaction. SQLMagic takes care of all the SQL statements, data conversion, locking, and navigation between tables. Please contact me off list if you are interested in what you see. I will be on vacation for a couple of weeks but plan to go into full beta mode when I return at the beginning of June. Pete lcSQL Software <http://www.lcsql.com> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Sun, May 17, 2015 at 12:02 PM, Skip Kimpel <skiplon...@gmail.com> wrote: > If you plan on doing any type of database projects in the future, do > yourself a favor and learn SQL. Extremely powerful when combined with LC! > > SKIP > > > On May 17, 2015, at 2:37 PM, Michael Gruenthal <mgruent...@mac.com> > wrote: > > > > Take a look at Andre Garzia¹s dbLib at > > http://andregarzia.com/pages/en/dblib/ > > He doesn¹t seem to be actively developing it anymore, but it works. > > > >> On 5/17/15, 12:03 PM, "Eric A. Engle" <engleer...@yahoo.com> wrote: > >> > >> Ugh. I am learning SQL. It is ugly. I am hoping someone has a stack > which > >> could convert livecode statements into SQL queries. It would save me > >> having to learn syntax. Any thoughts are appreciated. Thank you. > >> _______________________________________________ > >> use-livecode mailing list > >> use-livecode@lists.runrev.com > >> Please visit this url to subscribe, unsubscribe and manage your > >> subscription preferences: > >> http://lists.runrev.com/mailman/listinfo/use-livecode > > > > > > > > _______________________________________________ > > use-livecode mailing list > > use-livecode@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
