John Stanton wrote:
> Fred J. Stephens wrote:
>> Would it be possible to incorporate a clear screen command, like "clear"
>> in BASH? This would be handy to keep the view in the command line
>> interface uncluttered.
>> Maybe ".clear"?
> You have the source and it uses curses so the addition
Fred J. Stephens wrote:
> Would it be possible to incorporate a clear screen command, like "clear"
> in BASH? This would be handy to keep the view in the command line
> interface uncluttered.
> Maybe ".clear"?
You have the source and it uses curses so the addition should be fairly
simple.
>
We actually added this type of capability to Sqlite (actually fixed
point display format numbers), but it may be unnecessary in your case.
Instead of representing integers as BCD how about using the 64 bit
Sqlite integers? You may have sufficient precision. The COBOL-style
COMP3 integers are
Derrell Lipman wrote:
> In konsole (and xterm, I'm pretty sure), you can just hit CTRL-L to
> clear the screen whenever you're at an sqlite> prompt.
Excellent! Thats what I needed.
Thank you.
Fred
___
sqlite-users mailing list
sqlite-users@sqlite.org
On 3/26/08, Derrell Lipman <[EMAIL PROTECTED]> wrote:
> On Wed, Mar 26, 2008 at 4:14 PM, Fred J. Stephens <[EMAIL PROTECTED]> wrote:
> > Mike McGonagle wrote:
> > > Hum, on the Mac (10.4.9), the terminal window can be cleared from
> within the
> > > terminal program itself. I would imagine
On Wed, Mar 26, 2008 at 4:14 PM, Fred J. Stephens <[EMAIL PROTECTED]> wrote:
> Mike McGonagle wrote:
> > Hum, on the Mac (10.4.9), the terminal window can be cleared from within
> the
> > terminal program itself. I would imagine that other terminal programs also
> > provide this. Does this
Hello Puneet,
I guess I can select and reinsert all columns except for the column with
the default value.
I guess it would be nice (efficient) to update a single column to its
default value via the update command.
Thanks,
-Alex
On Tue, Mar 25, 2008 at 1:40 PM, P Kishor <[EMAIL PROTECTED]>
Hello Puneet,
On Tue, Mar 25, 2008 at 1:40 PM, P Kishor <[EMAIL PROTECTED]> wrote:
> On 3/25/08, Alex Katebi <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I was woundering how I can update a column in my table back to its
> default
> > value.
> >
> > For example:
> >
> > create table t1
On Wed, 26 Mar 2008 23:32:44 +0100, you wrote:
>Hello
>
>I noticed that the PDO::SQLite driver that comes with PHP 5.2.5 is
>3.3.17, while the non-OOP version is 2.8.17.
>
>Does someone know how to recompile PHP with the latest SQLite source?
You don't have to, the alternative is:
Hello
I noticed that the PDO::SQLite driver that comes with PHP 5.2.5 is
3.3.17, while the non-OOP version is 2.8.17.
Does someone know how to recompile PHP with the latest SQLite source?
Thank you.
___
sqlite-users mailing list
Imho the shell should rather implement the ! command to ask the bash (or
other shell) to execute a command in its preferred format. This
way any executable could be launched from sqlites command prompt. A clear
screen would be available as !clear or !cls.
Michael
-Ursprüngliche
Any ideas why I¹m getting this error when I try to install sqlite3 ?
I run sudo ./configure --prefix=/usr/local¹
And I get:
checking build system type... i386-apple-darwin9.2.2
checking host system type... i386-apple-darwin9.2.2
checking for gcc... gcc
checking for C compiler default output
Mike McGonagle wrote:
> Hum, on the Mac (10.4.9), the terminal window can be cleared from within the
> terminal program itself. I would imagine that other terminal programs also
> provide this. Does this functionality really need to be in SQLite?
> Mike
You're right I guess. In Konsole under KDE
Hum, on the Mac (10.4.9), the terminal window can be cleared from within the
terminal program itself. I would imagine that other terminal programs also
provide this. Does this functionality really need to be in SQLite?
Mike
On Wed, Mar 26, 2008 at 1:59 PM, Fred J. Stephens <[EMAIL PROTECTED]>
Would it be possible to incorporate a clear screen command, like "clear"
in BASH? This would be handy to keep the view in the command line
interface uncluttered.
Maybe ".clear"?
___
sqlite-users mailing list
sqlite-users@sqlite.org
Hi guys:
Iam using sqlite3 library in apache filter module(I call the sqlite3funciton in
input filter and output filter). Now there is a problem:when the apache is
working in debug mode, the sqlite3 can create dbfile; but when apache is
working in normal mode, the sqlite3 returnSQLITE3_CANTOPEN
Liam,
I know a great deal about oracle internals, Oracle stores "numbers" as you
indicate in a bcd format. But It can be up to 22 bytes long. But usage in
oracle proc/proc++/sql/plsql is really dependent upon your native conversion to
host datatype.
The number storage formats betweend Sqlite
yes i have write permissions !
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ken
Sent: Wednesday, March 26, 2008 7:55 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQL error: SQL logic error or missing database
do you have
I am porting a numerical application from Oracle to SQLite. For the
most part, I have been successful, but there are slight disagreements
in the floating point number results. I have traced this back and
found a problem. According to
http://articles.techrepublic.com.com/5100-22_11-5224536.html,
I've got an AIR app that does simple inserts into a SQLite db. The
insert looks like so:
var insStmt:SQLStatement = new SQLStatement();
insStmt.sqlConnection = dbconnection;
sql = "insert into hours(description,projectidfk,clientidfk,hours,date)
Hi,
My system do have Memory : 2000 MB is it fine for sqlitie to
start on with ?
Is their any disk size limitation for sqlite i.e.Incase do sqlite
require a min of any n MB disk to make transactions ?
BFOS:root> ./sqlite3 bhanu.db
SQLite version 3.5.7
Enter ".help" for instructions
BanuPrakash G wrote:
> Database or disk is full is the Error message i get from the sqlite
>
> :root> ./sqlite3 mediadb.sql
> SQLite version 3.5.7
> Enter ".help" for instructions
> sqlite> CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100));
> SQL error: database or disk is full
>
> sqlite>
do you have write permissions on mdiadb and the directory???
BanuPrakash G <[EMAIL PROTECTED]> wrote: Database or disk is full is the Error
message i get from the sqlite
:root> ./sqlite3 mediadb.sql
SQLite version 3.5.7
Enter ".help" for instructions
sqlite> CREATE TABLE t1(a INTEGER, b
There can be only one thread that has an exclusive write lock on the database.
Most likely this is a bug in your application.
Heres what I do for my multi threaded app:
1. All transactions use "begin immediate" (that way I don't do a bunch of
work only to find the db locked later).
2. The
Igor Tandetnik Wrote:
>The first case is slower, since it has to make an extra sqlite3_mprintf
>call (that achieves precisely nothing).
Thanks a lot Igor.Its am clear now.
___
sqlite-users mailing list
sqlite-users@sqlite.org
"Mahalakshmi.m"
<[EMAIL PROTECTED]> wrote
in message
news:[EMAIL PROTECTED]
> I want to know why we have to use sqlite3_mprintf before
> sqlite3_prepare()
We don't; wherever did you get this idea from?
> Case 1:
> Query = sqlite3_mprintf ("DELETE FROM MUSIC WHERE URL = ?;");
>
"P Kishor" <[EMAIL PROTECTED]> wrote in
message
news:[EMAIL PROTECTED]
> Given a table t (name, date)
>
> I want to find all rows within, say, 6 months of a specific row, say
> name = 'foo'. So, I am doing
>
> SELECT name
> FROM t
> WHERE
>(SELECT julianday(date) FROM t WHERE name =
Database or disk is full is the Error message i get from the sqlite
:root> ./sqlite3 mediadb.sql
SQLite version 3.5.7
Enter ".help" for instructions
sqlite> CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100));
SQL error: database or disk is full
sqlite> BFOS:root> df
Filesystem
Hi,
I want to know why we have to use sqlite3_mprintf before sqlite3_prepare()
Case 1:
Query = sqlite3_mprintf ("DELETE FROM MUSIC WHERE URL = ?;");
sqlite3_prepare(db, Query ,-1,,0);
sqlite3_free(Query);
case 2:
We can also use directly - sqlite3_prepare(db, "DELETE FROM MUSIC WHERE URL
=
Even create a database i.e. ./sqlite mydb.db3
when i attemt to execute any command i.e. create tables,insert etc i see
the ERROR Message
SQL error: SQL logic error or missing database.
I think because of some library dependency this issue is being observed
...any pointers ??
Thanks
/BP
Yes, it works. Thank Dennis!
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Cote
Sent: Wednesday, March 26, 2008 12:36 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] how can I find source of sqlite V 2.x
Russell wrote:
>
> My
Dennis Cote wrote:
>Then you should add an index on the Name column and use that to process
>your queries in Name order more quickly.
>create index on MyTable(Name);
Thanks a lot Dennis. My process is more fast by means indexing.
Dennis Cote wrote:
>If you really insist on reordering your
32 matches
Mail list logo
