On Date: Wed, 14 Mar 2012 23:13:57 -0400
From: Kevin Benson
wrote:
Quick solution to above error may be to try path with forward slashes:
C:\sqlite\lib>".separator ',' \n .import /sqlite/lib/ddl.txt dzh \n" |
sqlite3 /sqlite/lib/foods.db
and 8.3 path format where needed:
C:\sqlite\lib>".separa
On 15 Mar 2012, at 7:11pm, Waltênio de Bessa Mendes
wrote:
>> *SQLite version 3.7.10 2012-01-16 13:28:40
>> Enter ".help" for instructions
>> Enter SQL statements terminated with a ";"
>> sqlite> $ sqlite3 Biblia
>> ...> ;
>> Error: unrecognized token: "$"
>> sqlite> .tables
>> sqlite> select
2012/3/15 Waltênio de Bessa Mendes
> Dear Simon,
>
> Thanks for help.
>
> I created a database named "Biblia" with a table named "LivroDaBiblia".
> I tried the shell tool and get the following.
>
> *SQLite version 3.7.10 2012-01-16 13:28:40
> Enter ".help" for instructions
> Enter SQL statement
Put an absolute path name for your filename.
You're probably opening up the database in the wrong directory, creating an
empty DB, and thus "no such table".
In particular this happens when running from the IDE or via an Icon where the
working directory is not set.
Michael D. Black
Senior
On 15 Mar 2012, at 6:48pm, Waltênio de Bessa Mendes
wrote:
> I need help when receive a message error *"could not prepare statement no
> such table..." * when try
> execute "*select*" in the code:
Open the database in the shell tool and use '.tables'.
http://www.sqlite.org/sqlite.html
Does
Hi,
I need help when receive a message error *"could not prepare statement no
such table..." * when try
execute "*select*" in the code:
* var db = window.openDatabase("Biblia","","Database",10);
var tx;
var sql = "select nome from LivroDaBiblia;";
$(document).ready(function() {
On Thu, 15 Mar 2012 10:58:34 +0900 (KST), poorw...@itholdings.co.kr
wrote:
>Hello.
>
>I am an elementary programmer in Korea.
>
>My company uses SQLite for some kinds of project. We use it without any
>problems. but recently we got a problem,
>so I searched solutions from internet. but I could
Hello,
I am using SQLite to keep a copy of a database in memory. On load, this
database is read off disk with the Backup API. Our project is .Net and we are
using the System.Data.Sqlite driver 1.0.75. I have been testing performance
under load and noticed some strange behavior. Access to a
Suggest he obtain a gmail account and send from there?
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Richard Hipp
> Sent: Thursday, March 15, 2012 8:18 AM
> To: General Discussion of SQLite Database
> Subject: [sqlite]
Thanks. However - SQLITE_MAX_ATTACHED seems to only apply to a tool you are
compiling - whereas I just submit SQL scripts from the standard shell and
was hoping to be able to attach more than 10 DBs.
I looked and looked and so far have not found any way to do this.
Thanks again.
On Tue, Mar 13,
User 영양갱라인 writes that he is unable to contact
this mailing list because his email user agent is not sending the emails in
a format that our mailing list software (Mailman) can understand. If
anybody on this list can help him out, please do so. If you can speak to
him in Korean, all the better.
Hi *,
month ago I wrote question about possibility to add support of %y (2
digit year) to strftime() function.
Patch is very simple and I hope, that will be useful for many users.
Patch by Alexey is here:
http://sqlite.mobigroup.ru/wiki?name=2-digit+year+patch
(although I think, that it can be
12 matches
Mail list logo