DataGrids with no UI

[Bob Sneidar]

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