Re: [sqlite] Reporting Solutions that work with SQLite / VB 2015?

2017-04-03 Thread Cousin Stanley
Cousin Stanley wrote: >> regarding your sqlrpt program >> >> Can the floating point numbers be formatted >> for example ah la %8.4f James K. Lowden wrote: > Cousin Stanley, > > Indeed you now can. > > I added a -p option, doc

Re: [sqlite] Reporting Solutions that work with SQLite / VB 2015?

2017-03-25 Thread Cousin Stanley
James K. Lowden wrote: > I recently wrote a utility to produce simple reports. > > https://github.com/jklowden/sqlrpt > > Numeric columns are aligned on the decimal point and formatted > with the thousands separator consistent with the locale. > > Wide text columns are formatted to fit

Re: [sqlite] SQL / SQLite for Beginners

2016-05-25 Thread Cousin Stanley
R.A. Nagy wrote: > All, > > A recent convert to using SQLite, I have put together a series of videos > on learning SQL, as well as covering the basics of using SQLite. > > https://www.youtube.com/playlist?list=PLItP5KoawLqkPV2jqAVCH79fZGO5k0Uzy > > Would this be the proper mailing list / way

[sqlite] SQLite3 API

2015-12-01 Thread Cousin Stanley
>> Any plans for distribution of your cobol/sqlite interface ? > > The SQLite3 Interface for GnuCOBOL [sql3i4gc] > will soon be available from the Contribution area > of the GnuCOBOL Project > > > > It is being released under the GNU

[sqlite] SQLite3 API

2015-11-27 Thread Cousin Stanley
> I have written (in COBOL) an SQLite3 interface for GnuCOBOL > Robert Any plans for distribution of your cobol/sqlite interface ? -- Stanley C. Kitching Human Being Phoenix, Arizona

Re: [sqlite] Last record in db

2011-08-22 Thread Cousin Stanley
Black, Michael (IS) wrote: > select * from table where rowid=max(rowid); $ sqlite3 m2d1.sql3 -- Loading resources from /home/sk/.sqliterc SQLite version 3.7.3 Enter ".help" for instructions Enter SQL statements terminated with a ";" > .tables t1 t2 t3 > .schema t1 CREATE TABLE t1(id

Re: [sqlite] Loading Data

2011-07-30 Thread Cousin Stanley
NewsGroup gmane.comp.db.sqlite.general Subject .. Loading Data Date . 2011-07-28 Post_By .. Daniel Spain Edit_By .. Stanley C. Kitching I added some white space and new-line characters to Daniel's original post using a first pass through Python and a

Re: [sqlite] Insert a structure

2011-05-16 Thread Cousin Stanley
Enrico Thierbach wrote: > From my experience I would recommend you to convert your structure > into some kind text format JSON, with the excellent and well-performing > yajl library, is usually my favorite choice here. Thanks for recommending yajl The yajl-tools package under

[sqlite] sqlite command-line system escape

2009-09-21 Thread Cousin Stanley
Is there an escape character or sequence that can be used from the sqlite3 command-line to run system commands ? For example sqlite> ! dir Using sqlite3 version 3.5.9-6 under Debian Linux I thought I remembered doing this in earlier versions from a few years