DataGrids with no UI

Peter Haworth pete at lcsql.com
Thu Sep 27 13:05:59 EDT 2012


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 <bobs at twft.com> 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 <todd at geistinteractive.com
> >wrote:
> >
> >>
> >> On Sep 26, 2012, at 4:10 PM, Monte Goulding <
> monte at 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 at 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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



More information about the use-livecode mailing list