Umm yeah! I will be very interested. :-) Yeah this is exactly the kind of stuff that I am looking for. I wouldn't mind paying for something like this either.
I'll contact you back channel on this its sounds very interesting. Todd On Sep 26, 2012, at 6:25 PM, Peter Haworth <p...@lcsql.com> 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 <t...@geistinteractive.com>wrote: > >> >> On Sep 26, 2012, at 4:10 PM, Monte Goulding <mo...@sweattechnologies.com> >> 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 >> 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 Todd -- Todd Geist ------------------------------------ http://www.geistinteractive.com 805-419-9382 GoDraw Draw on Photos with FileMaker Go http://www.geistinteractive.com/godraw _______________________________________________ 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