[sqlite] printf function is shown in docs but not found when I try it

In the documentation at http://www.sqlite.org/lang_corefunc.html there's a printf function, however when I try and use it in sqlite3 (on xubuntu 13.10) it says "Error: no such function: printf". Is this because I need to load some extra library to make it work or is it just not available in the

Re: [sqlite] printf function is shown in docs but not found when I try it

Richard Hipp wrote: > On Thu, Apr 17, 2014 at 8:03 AM, wrote: > > > In the documentation at http://www.sqlite.org/lang_corefunc.html > > there's a printf function, however when I try and use it in sqlite3 > > (on xubuntu 13.10) it says "Error: no such function:

Re: [sqlite] printf function is shown in docs but not found when I try it

Simon Slavin wrote: > > On 18 Apr 2014, at 2:49pm, c...@isbd.net wrote: > > > Xubuntu 13.10 (which I'm currently using) has sqlite 3.7.17. > > > > Xubuntu 14.04 has sqlite 3.8.2, I'm not sure if they're likely to move > > to anything newer during its lifetime. > > If

[sqlite] Application with 'grid' form for entering table data wanted

I'm looking for an application (or *simple* development framework) which will provide me with an easily accessible grid form for entering data into a table. Requirements:- This can be a web app or a [Linux] desktop one though I have a slight preference for a web app. Must be able to

Re: [sqlite] Application with 'grid' form for entering table data wanted

RSmith wrote: > > On 2014/06/03 16:07, c...@isbd.net wrote: > > I'm looking for an application (or *simple* development framework) > > which will provide me with an easily accessible grid form for entering > > data into a table. > > > > Requirements:- > > This can be a

Re: [sqlite] Application with 'grid' form for entering table data wanted

Stephen Chrzanowski wrote: > By the sounds of it, the OP wants a spreadsheet app, that isn't a > spreadsheet app, acts like a database, but isn't quite a database, looks > simple to use, but provide editable information in a reasonable format. > You're almost right. Many

[sqlite] Linux sqlite3 executable return value - what does it return?

If I execute some SQL by putting it after 'sqlite3' on the command line as follows:- sqlite3 mydata.db "SELECT * from mytable" Does the return value contain anything that will tell me if the SQL worked or not? If it doesn't then what's the easiest way for a script to tell if some SQL

Re: [sqlite] Linux sqlite3 executable return value - what does it return?

Stephan Beal wrote: > On Mon, Jun 16, 2014 at 5:37 PM, wrote: > > > Does the return value contain anything that will tell me if the SQL > > worked or not? > > > > ... > set_table_name(, 0); > if( data.db ){ > sqlite3_close(data.db); > } >

Re: [sqlite] Linux sqlite3 executable return value - what does it return?

Simon Slavin wrote: > > On 16 Jun 2014, at 9:03pm, c...@isbd.net wrote: > > > > Remember - I said I'm doing an INSERT, either it will insert the > > intended data or there will be an error. > > But there are two types of error: the INSERT command may turn out to be >

[sqlite] Is there a simple command line data editor for sqlite3?

Is there such a thing? Of course I know and use the sqlite3 command line utility but that's just a way of running SQL from the command line. I want some sort of wrapper that runs a SELECT to get the data from a table, presents it to me in editable format and then does an UPDATE or INSERT to put

Re: [sqlite] Is there a simple command line data editor for sqlite3?

RSmith wrote: > On 2014/09/30 19:23, c...@isbd.net wrote: > > Is there such a thing? > > > > Of course I know and use the sqlite3 command line utility but that's > > just a way of running SQL from the command line. > > > > I want some sort of wrapper that runs a SELECT to get

Re: [sqlite] Is there a simple command line data editor for sqlite3?

Mark Lawrence wrote: > On Wed Oct 01, 2014 at 09:50:16AM +0100, c...@isbd.net wrote: > > > > > Linux (xubuntu), > > ... > > in this case I need a command line utility. > > You may be interested in the db-browser *terminal application* > available from CPAN: > >

Re: [sqlite] Is there a simple command line data editor for sqlite3?

Mark Lawrence wrote: > > in a directory that contains sqlite3 databases it lists every file in > > the hierarchy (why, there are thousands) and then fails with:- > > > > Ended searching > > Available databases: > > Can't locate object method "new" via package

[sqlite] Wanted - simple DATA editor for sqlite tables

I'm looking for a straightforward way to edit the *data* in sqlite tables, or at least a simple GUI for creating forms to edit sqlite tables. I don't need *any* database management and I don't want it in this application either because I want to be able simply to issue a command like:- app

Re: [sqlite] Wanted - simple DATA editor for sqlite tables

Alessandro Marzocchi wrote: > Sqlite browser? Exactly what I'm trying to get away from. Sqlite browser is an excellent database management too but an absolutely awful tool for entering data into the database. To even get to the point where one can enter data

Re: [sqlite] Wanted - simple DATA editor for sqlite tables

BareFeetWare wrote: > On 24/03/2013, at 2:53 AM, c...@isbd.net wrote: > > > I'm looking for a straightforward way to edit the *data* in sqlite tables, > or at least a simple GUI for creating forms to edit sqlite tables. > > > I suggest Navicat Essentials for

Re: [sqlite] Wanted - simple DATA editor for sqlite tables

Stephen Chrzanowski wrote: > > I know you said you didn't want a DBMS, but really, when you're saying > you're willing to write an application to manage the data, you're writing a > DBMS. Save time, don't reinvent the wheel unless you're going on a > learning adventure. >

Re: [sqlite] Wanted - simple DATA editor for sqlite tables

Stephen Chrzanowski wrote: > Reading further on, I see that you're looking at end-user. This changes > things a bit. Now you're looking at trying to make things user-proof, > maintain data integrity (Who said 1<>one?), validate data, so on and so > on. You're probably