"Gilles Ganault" <gilles.gana...@free.fr> schrieb im Newsbeitrag news:tmr1v5lfsa26lcbooq20sh0q4358jdf...@4ax.com...
> I was wondering: To help people move from Excel > to a DB to handle data, I'd like to show them a really > good Windows application that will enable them to > create/read/update/delete records, and should present > users with forms to handle records (not tables, as this is too > abstract for users). > > Ideally, it should also a somewhat-protected admin > section where I could perform tasks such as managing tables, > creating/deleting indexes, etc., but I can do without. > > Is there a open- or closed-source Windows application > that you would recommend for end-users? I'd say, what you're looking for (in case a "softer" migration of Excel-VBA-Devs is planned) is more a library IMO - and not an "Application". And Excel-VBA experienced Users/Devs usually have some "Record-" or Recordset-experience per ADO - which is a COM-layer - and COM is (yet) the preferred component- library-mechanism in VBA (as well as in the VB5/6 world). So, I'd suggest, that you take a look at my (free binary) COM- based SQLite-wrapper (dhRichClient3.dll) which you can download here: www.thecommon.net/3.html This wrapper allows an ADO-like usage of Connection-, Command- and Recordset-Objects - so, "record-oriented" working with specified SQL-Selects is no problem - also directly within Excel-VBA-code - or if you want to present them a "standalone Windows-App", then a VB5- or VB6- compiler would be sufficient, to create such a thing with ease (there's a VB6-code Demo-package too on the site above, which implements (in the SQLite-SubFolder) a pretty complete Demo-App around NWind.db, which includes also "Grid-Visualization" with only a few lines of code per Form). And I know, that the wrapper is already used directly within Excel-VBA too, by many "Office-Devs" - and I've already included some Excel-convenience-functions into it, to e.g. support putting the contents of a query (buffered on the return of a query within a cRecordset first) from such an Rs into the XL-cells directly with one or two lines of code per either: XLRange = Rs.GetRows or XLRange = Rs.GetRowsWithHeaders alternatively one can use: XLRange.CopyFromRecordset Rs.GetADORsFromContent or XLRange.CopyFromRecordset Rs.DataSource And with regards to DDL - the wrapper supports that currently only at the "lower-level" per Cnn.Execute "DDL-statement" - but in case you want to do these Table- and Index-Creations in a "more comfortable objectoriented" way, you could look at Jason Peter Browns website, who wrote some wrapper-classes for that: http://www.jasonpeterbrown.com/jpbdbfactory.html And whilst the above is with regards to objectoriented schema- *creation* - what's already directly built-in is, to enumerate and readout an already existing schema (e.g. for visualizing in a TreeView) per: For Each Db In Cnn.Databases For Each Tbl In DB.Tables For Each Clm In Tbl.Columns '... Next Clm For Each Idx In Tbl.Indexes '... Next Idx Next Tbl Next Db Olaf Schmidt _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
