Just spent a while trying to work out how to access sqlite in read-only
mode from Tcl.
There seems to be nothing in the API doc :
http://www.sqlite.org/tclsqlite.html
I eventually got the information from an error message:
wrong # args: should be sqlite3 HANDLE FILENAME ?-vfs VFSNAME? ?-readonly
Hi,
I think you should have a look here:
http://www.sqlite.org/uri.html
Hope that helps!
Fredrik
On Tue, Oct 23, 2012 at 10:48 AM, John Gillespie rjkgilles...@gmail.comwrote:
Just spent a while trying to work out how to access sqlite in read-only
mode from Tcl.
There seems to be nothing
Hi All,
I installed
sqlite-netFx40-setup-x64-2010-1.0.82.0.exehttp://system.data.sqlite.org/downloads/1.0.82.0/sqlite-netFx40-setup-x64-2010-1.0.82.0.exe
on my Win 7 machine. But the Server Explorer Add Connection dialogue does not
show a Sqlite source. I have read various posts and could
The analogy you have chosen to explain the algorithm of your program is
clear, but it seems to me that you are using a specific computer language to
achieve its goal. Perhaps, it would be much easier on us, the helpers, to
help you if you provide information that is more tangible; as in a snip of
Quanren Xiong wrote:
I installed sqlite-netFx40-setup-x64-2010-1.0.82.0.exe on my Win 7
machine.
But the Server Explorer Add Connection dialogue does not show a Sqlite
source.
I have read various posts and could not find a solution.
Only the 32-bit setup packages are capable of installing
Thanks for your reply. Sorry last time I installed
sqlite-netFx40-setup-bundle-x64-2010-1.0.82.0.exe, it did not work.
I did not install tried sqlite-netFx40-setup-bundle-x86-2010-1.0.82.0.exe.
Sorry for the typo.
Even my machine is running 64 bit Win7, I just tried
Quanren Xiong wrote:
However when I run the test program, I got following error messages. Do I
need to
install sqlite-netFx40-setup-bundle-x64-2010-1.0.82.0.exe as well?
No. The test application has nothing to do with the Visual Studio
design-time support.
Since the test application is
Hi
I am using Sqlite for my project and getting Error like -SQLITE_NOTADB
whenever i am trying
below scenario-
1- Open and create the database
2- Execute Sqlite_Exec to Insert the record in the database table
3- Close the database
4- Confirm by opening the .db file in sqlite browser tht dtabase
I assume you have some program doing the sqlite_exec?
Care to show us your code?
I just ran a test doing what you describe with SQLite Database Browser Version
2.0b1 and the following program compiled against 3.7.13;
After the 2nd run of this program there are 2 records in test.db which the
On 23 Oct 2012, at 5:58pm, kritesh tripathi tripathi.krit...@gmail.com wrote:
4- Confirm by opening the .db file in sqlite browser tht dtabase table
insert the records
5- Again Open the the database
6- Whenever Executing Sqlite_Exec to Update the colum value of database
table .
hi michale
there is no problem in creating and inserting the records in table ...but
after tht i am trying to update the coloum value of table and using update
command with where clause ..here every time sqlite_exec command failing and
rc returns in sqlite3_prepare such as SQLITE_NOTADB
CHEERS
hi simon
i am not using step 4 in my program...after step 1 to 3 ,db file create in
external sd card .
then i am trying to update the colum value of table using upadte command
with where clause but its failing due to below if condition as i mentioned
in the sqlite3_prepare--lockBtree
OK...here it is again using an updatestill works for me. Does it work for
you?
run it like this...first run with no args creates the table
simple
simple 1 2
simple 2 3
The args just update from/to values so you can see them changing using and
update/where clause.
#1 What OS?
#2 What
Hello,
The documentation says the xRename function is mandatory:
http://sqlite.org/vtab.html#xrename
The xRename method is required for every virtual table implementation.
But it seems possible to not specify it:
static const sqlite3_module fts3aux_module = {
...
0,
On Tue, Oct 23, 2012 at 10:16:07PM +0200, gwenn scratched on the wall:
Hello,
The documentation says the xRename function is mandatory:
http://sqlite.org/vtab.html#xrename
The xRename method is required for every virtual table implementation.
But it seems possible to not specify it:
Hi, ALL,
I'm developing a program that will be cross-platform and utilize
SQLite database.
My main development platform is Windows and when I finish I will move to Mac.
My question is:
1. I know on Mac I need to build an application bundle. Where do I
store the .db file relative to the bundle?
On Oct 23, 2012, at 4:58 PM, Igor Korot ikoro...@gmail.com wrote:
1. I know on Mac I need to build an application bundle. Where do I
store the .db file relative to the bundle?
Inside it? Home directory? Somewhere on the hard drive? What is the
usual place for it?
If the database is
Hi, Doug,
On Tue, Oct 23, 2012 at 2:26 PM, Doug Currie doug.cur...@gmail.com wrote:
On Oct 23, 2012, at 4:58 PM, Igor Korot ikoro...@gmail.com wrote:
1. I know on Mac I need to build an application bundle. Where do I
store the .db file relative to the bundle?
Inside it? Home directory?
On Oct 23, 2012, at 11:35 PM, Igor Korot ikoro...@gmail.com wrote:
So then user home directory (~) should be fine, right?
No. Don't. Lookup NSApplicationSupportDirectory and check the documentation.
Apple has clear APIs and guidelines about where to put what. Learn them.
On 23 Oct 2012, at 10:35pm, Igor Korot ikoro...@gmail.com wrote:
On Tue, Oct 23, 2012 at 2:26 PM, Doug Currie doug.cur...@gmail.com wrote:
On Oct 23, 2012, at 4:58 PM, Igor Korot ikoro...@gmail.com wrote:
1. I know on Mac I need to build an application bundle. Where do I
store the .db
Hi,
On Tue, Oct 23, 2012 at 3:10 PM, Simon Slavin slav...@bigfraud.org wrote:
On 23 Oct 2012, at 10:35pm, Igor Korot ikoro...@gmail.com wrote:
On Tue, Oct 23, 2012 at 2:26 PM, Doug Currie doug.cur...@gmail.com wrote:
On Oct 23, 2012, at 4:58 PM, Igor Korot ikoro...@gmail.com wrote:
1. I
On 23 Oct 2012, at 11:41pm, Igor Korot ikoro...@gmail.com wrote:
On Tue, Oct 23, 2012 at 3:10 PM, Simon Slavin slav...@bigfraud.org wrote:
If your user considers these SQLite databases to be their own documents
(i.e. like a word processor saves text documents, your application saves
hi michael
thanks for the responnse bt still getting the same problem
language-C++
RTOS-micro itron
where-creating db in digital camera external sd card and afterwards usin
this db file for some wifi feature present in digital camera so that user
can see all those images in tv or mobile.
Save yourself some time and show some code, it will make it easy for us to
help you.
Genius might have limitations, but stupidity is no handicap
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of kritesh tripathi
Sent:
Igor Korot wrote:
Well, that the closest definition of the data I'm about to put into
this database.
I am making a sport related application and need to store the data
about the teams, players etc.
User should be able to add/edit/delete this information and this
information will be presented
in
Simon,
On Tue, Oct 23, 2012 at 5:24 PM, Simon Slavin slav...@bigfraud.org wrote:
On 23 Oct 2012, at 11:41pm, Igor Korot ikoro...@gmail.com wrote:
On Tue, Oct 23, 2012 at 3:10 PM, Simon Slavin slav...@bigfraud.org wrote:
If your user considers these SQLite databases to be their own documents
Darren,
On Tue, Oct 23, 2012 at 8:53 PM, Darren Duncan dar...@darrenduncan.net wrote:
Igor Korot wrote:
Well, that the closest definition of the data I'm about to put into
this database.
I am making a sport related application and need to store the data
about the teams, players etc.
User
Igor Korot wrote:
Darren,
On Tue, Oct 23, 2012 at 8:53 PM, Darren Duncan dar...@darrenduncan.net wrote:
You should not have an application installer, at all. Instead, you can ask
the question on where to store the database when the user opens your
program. Or better yet, your application
28 matches
Mail list logo