I'll add you to my ever growing list of interested parties. Pete lcSQL Software <http://www.lcsql.com>
On Thu, Sep 27, 2012 at 9:26 AM, Bob Sneidar <[email protected]> wrote: > That sounds great Peter. I'm definitely interested. > > Bob > > > On Sep 26, 2012, at 6:25 PM, Peter Haworth wrote: > > > Hi Todd, > > I'm not sure of your timeframe but you might be interested in a product > I'm > > working on, liquidSQL. It will eliminate the scripting and SQL statement > > coding for a high percentage of the functions in an application, leaving > > you to deal with the more complex ones. > > > > It will bind columns (including fields, option menus, radio buttons, > > checkboxes) in datagrids to rows in an SQL table, and controls on a card > to > > individual columns in a table or SQL expressions. It's not limited to > > datagrids though, you will be able to use scrolling fields, tables, > option > > menus, as the container for rows you retrieve, or no container at all, > just > > next/prev/first/last buttons to browse through the data. > > > > It will handle the formatting of data such as dates and currency and > handle > > validation checks of user entered data. > > > > The user will be able to specify selection criteria by simply typing into > > fields on the form( or selecting from option menus) if you allow that, or > > you can predefine the data to be selected. > > > > It will handle the display/entry of data from multiple tables on one > stack > > (eg invoice header, invoice lines), figuring out how the tables are > linked > > together automatically in most circumstances, and will automatically > handle > > the display of data from foreign keys. > > > > You will be able to automatically generate stack layouts for a specified > > table, or you can drag/drop controls from a built in palette to create a > > layout yourself. > > > > I'm in the later stage of development right now and would hope to have > beta > > available within a couple of months. > > > > Pete > > lcSQL Software <http://www.lcsql.com> > > > > > > > > On Wed, Sep 26, 2012 at 5:43 PM, Todd Geist <[email protected] > >wrote: > > > >> > >> On Sep 26, 2012, at 4:10 PM, Monte Goulding < > [email protected]> > >> wrote: > >> > >>> If you work out how to get a library to listen to changes in a datagrid > >> (which you will need to do if you want to bind it to a table) then could > >> you post it on the list. I have a custom control (mergDataGridScroller) > >> that needs to know when the data is changed. At the moment it requires > you > >> to dispatch updateContentRect to it after changing the datagrid data > but if > >> it could listen to changes it would be nicer. I can't se anything in the > >> api that helps me with that though. > >> > >> > >> Will do. > >> > >> > >>> > >>> PS there was database binding in the ide a few years back. I think it > >> was taken out because it wasn't used. > >> > >> Yeah, I remember. But that was quite a few years back. > >> > >> I am simply unwilling to do wire this stuff up by hand every time. I > >> would rather gargle thumbtacks. Either I find a way to effectively do > data > >> binding or I am moving on. > >> > >> I am very spoiled by 20 years of doing DB stuff in FileMaker where the > >> binding is all done for you. FileMaker has it limits though, and it > would > >> be nice to break free of those as well. I just want something in the > middle. > >> > >> > >> > >> > >> Todd > >> > >> -- > >> Todd Geist > >> ------------------------------------ > >> http://www.geistinteractive.com > >> 805-419-9382 > >> > >> > >> _______________________________________________ > >> use-livecode mailing list > >> [email protected] > >> Please visit this url to subscribe, unsubscribe and manage your > >> subscription preferences: > >> http://lists.runrev.com/mailman/listinfo/use-livecode > >> > > _______________________________________________ > > use-livecode mailing list > > [email protected] > > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
