DataGrids with no UI

Peter Haworth pete at lcsql.com
Wed Sep 26 21:25:46 EDT 2012


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
>



More information about the use-livecode mailing list