Hello Roger,
Sorry for the long delay. I did not see this in the swamp of recent email.
I guess I am lost on how to obtain a many reader or one writer mutex in SQLite.
I interpret the mutex returned by sqlite3_mutex_alloc() as being an exclusive
mutex since the documentation states "The sqlit
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/23/2011 08:46 AM, Fabio Spadaro wrote:
> Hi
When you quote other messages, only quote the relevant pieces that you are
replying to. Several hundred lines is not appropriate.
> What is the difference between "sqlite3.version" (typed on command
> I resolved with:
>CREATE TRIGGER insert_nameTable after insert on
>name_tabl begin
>update set ww = datetime('now','localtime')
>where rowid = new.rowid; end"
You don't have to fire a trigger for such default:
CREATE TABLE "test" (
"mydate" CHAR DEFAULT (date
Am 23.05.2011 17:52, schrieb Christoph P.U. Kukulies:
> Am 23.05.2011 17:02, schrieb Drew Hohmann:
>> Hello,
>> What steps do I need to take to get SQLite to appear in the list of Data
>> Providers in Visual Studio 2010? I've installed the latest
>> System.Data.SQLite (1007200), and when I select
Am 23.05.2011 17:02, schrieb Drew Hohmann:
> Hello,
> What steps do I need to take to get SQLite to appear in the list of Data
> Providers in Visual Studio 2010? I've installed the latest
> System.Data.SQLite (1007200), and when I select a Data Source the only
> options for a data provider are
> .
Hi
2011/4/22 Pavel Ivanov
> > In my system is set up with 11:35:07 while I am in the data 9:37:30
> > Why?
>
> http://www.sqlite.org/lang_createtable.html
> "If the default value of a column is CURRENT_TIME, CURRENT_DATE or
> CURRENT_TIMESTAMP, then the value used in the new row is a text
> repr
Hello,
What steps do I need to take to get SQLite to appear in the list of Data
Providers in Visual Studio 2010? I've installed the latest
System.Data.SQLite (1007200), and when I select a Data Source the only
options for a data provider are
.NET Framework Data Provider for Microsoft SQL Server
On Mon, May 23, 2011 at 3:58 PM, Dev_lex wrote:
> int i =0;
> for(i=0;i<=3;i++)
> {
>sqlite3_step(Stmt);
>callback;
> }
> ...
> I've only one line in my table, ans 4 columns, that's why I've done i=0 to
> 3.
>
The number of columns has NOTHING to do with how many times you need to ca
Hum.. I'm sorry but I've followed your explanations, but I can't use it as I
want..
The code is really simple :
int i =0;
for(i=0;i<=3;i++)
{
sqlite3_step(Stmt);
callback;
}
sqlite3_reset(Stmt); (And after, _finalize, when I don't need it anymore).
Is there an error in it?
I
Well that's good, I understand the concept.
I'm going to write a small code for this then !
Thanks a lot for your help !
Simon Slavin-3 wrote:
>
>
> On 23 May 2011, at 2:05pm, Dev_lex wrote:
>
>> Well I know that _step is not a callback, but I have a callback to call..
>> With _exec I can
Dev_lex wrote:
> Hello everyone !
> I've got a new question :
>
> I would like to do this :
>
> sqlite3_exec(query_handle.db,"SELECT * FROM DHSS", callback, 0, NULL);
>
> But I need to prepare the statement.. So I can prepare the statement :
> "SELECT * FROM DHSS" , but how can I call the call
On 23 May 2011, at 2:05pm, Dev_lex wrote:
> Well I know that _step is not a callback, but I have a callback to call..
> With _exec I can call it without any problem, because I can pass it in the
> third argument.. But with the _prepare and _step method, I don't know how to
> bind my callback with
"BareFeetWare", on Saturday, May 21, 2011 9:15 PM wrote...
> Hi Jose,
>
>> I would like to get a bunch of records of IDs that I already know. For
>> example, this table called Jobs,
>> rec,...,data,...
>> 1,...,aaa,...
>> 2,...,zzz,...
>> ...
>> ...
>> 99,...,azz,...
>
> In addition to the pure
Simon Slavin-3 wrote:
>
>
> On 23 May 2011, at 1:50pm, Dev_lex wrote:
>
>> I would like to do this :
>>
>> sqlite3_exec(query_handle.db,"SELECT * FROM DHSS", callback, 0, NULL);
>>
>> But I need to prepare the statement.. So I can prepare the statement :
>> "SELECT * FROM DHSS" , but how
On 23 May 2011, at 1:50pm, Dev_lex wrote:
> I would like to do this :
>
> sqlite3_exec(query_handle.db,"SELECT * FROM DHSS", callback, 0, NULL);
>
> But I need to prepare the statement.. So I can prepare the statement :
> "SELECT * FROM DHSS" , but how can I call the callback with sqlite3_ste
Hello everyone !
I've got a new question :
I would like to do this :
sqlite3_exec(query_handle.db,"SELECT * FROM DHSS", callback, 0, NULL);
But I need to prepare the statement.. So I can prepare the statement :
"SELECT * FROM DHSS" , but how can I call the callback with sqlite3_step?
I hope
Hi,
Sorry if this isn't the right place for this query - not sure where else
though,
I'm trying to use system.date,sqlite in my project but am having
difficulty making it build.
I've tried at least these ways:
- installing from the precompiled installer for 1.0.72; the library
wasn't visible
Johannes Klarenbeek wrote:
> Dear sqlite users and developers,
>
> my question is why doesn't sqlite support recursive selects yet... is there
> a practical reason behind it perhaps?
>
> Many projects that I dealt with have a sort of parent child relationship in
> some of their tables. There is
Dear sqlite users and developers,
my question is why doesn't sqlite support recursive selects yet... is there
a practical reason behind it perhaps?
Many projects that I dealt with have a sort of parent child relationship in
some of their tables. There is a lot of overhead in resolving these paren
>I have problems with column aliasing using AS when I select
>rows with the same string:
>
>.headers ON
>CREATE TABLE TEST1 (name TEXT,value TEXT);
>INSERT INTO TEST1 VALUES ("name1","value1");
>SELECT value AS name1 FROM TEST1 WHERE name="name1"; // gives no result
>SELECT value AS name1_ FROM T
Hello everybody,
I have problems with column aliasing using AS when I select
rows with the same string:
.headers ON
CREATE TABLE TEST1 (name TEXT,value TEXT);
INSERT INTO TEST1 VALUES ("name1","value1");
SELECT value AS name1 FROM TEST1 WHERE name="name1"; // gives no result
SELECT value AS name
There's always the SQLite manager for FireFox add-on:
http://code.google.com/p/sqlite-manager/. I use it quite a lot to
quickly check the data inside my own sqlite databases. Has a pretty
intuitive GUI.
Nick.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-
22 matches
Mail list logo
