Hello
I don't know anything about .Net, and I'd like to build a quick app
with Visual Studio 2005 or 2008 to check how well it performs with
SQLite. If performance and deployment prove to be good enough, we'll
use VB.Net for new projects and finally dump VB6.
AFAIK, the default option is
From reading the documentation I see that sqlite seems to have a very
smart locking mechanism going on under the hood, regulating concurrent
access by multiple applications. Unfortunately, the designers of
another application with which I share a database have decided to
cache data intern
"Adam Megacz" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> I have an application that absolutely must not return from a certain
> call until the results of an update are safely committed to disk. The
> situation above would be considered "not safe". How can I perform an
> update
>From http://www.sqlite.org/lockingv3.html
If multiple commands are being executed against the same SQLite
database connection at the same time, the autocommit is deferred
until the very last command completes. For example, if a SELECT
statement is being executed, the execution of the com
On Sat, 01 Mar 2008 18:50:56 +0100, Gilles Ganault
<[EMAIL PROTECTED]> wrote:
>This doesn't work as intended, because it returns all the rows,
>effectively ignoring the WHERE part:
Thanks everyone for the help. Problem solved:
$dbh = new PDO("sqlite:test.sqlite");
$sql = "SELECT
On Sat, 1 Mar 2008 18:23:43 -0500, "Stephen Oberholtzer"
<[EMAIL PROTECTED]> wrote:
>I have to ask: Why is it that you expected a condition applying to one
>column on one table, to also apply to a differently named column in a
>differently named table?
Because I'm not clear about how joins work :-
On Sat, Mar 1, 2008 at 6:13 PM, Gilles Ganault <[EMAIL PROTECTED]> wrote:
> On Sat, 1 Mar 2008 18:04:12 -0500, "Stephen Oberholtzer"
> <[EMAIL PROTECTED]> wrote:
> >> INSERT INTO Table2 VALUES (NULL,"Some text in Table2");
> >> INSERT INTO Table2 VALUES (NULL,"Some other text in Table2");
> >
On Sat, 1 Mar 2008 18:04:12 -0500, "Stephen Oberholtzer"
<[EMAIL PROTECTED]> wrote:
>> INSERT INTO Table2 VALUES (NULL,"Some text in Table2");
>> INSERT INTO Table2 VALUES (NULL,"Some other text in Table2");
>> =
>> INSERT INTO Table1 VALUES (NULL,"John Doe",1);
>> INSERT INTO Table1 VALUE
On Fri, Feb 29, 2008 at 11:01 PM, <[EMAIL PROTECTED]> wrote:
>
>
> I've downloaded and built the sources for the standard Intel Linux
> platform but I want to run this on Linux on a Coldfire (MCF5484) platform.
> How do I modify the compiler the build uses (short of just modifying the
> Makefi
On Sat, 1 Mar 2008 15:35:01 -0500, "P Kishor"
<[EMAIL PROTECTED]> wrote:
>SELECT table1.*, table2.col1
>FROM table1 JOIN table2 ON table1.field10 = table2.field1
Thanks for the tip, but...
1. I want to SELECT all the columns from Table1 and one column from
Table2, but only rows WHERE table1.field
> =
> CREATE TABLE Table1 (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT,
> table2id INTEGER);
> CREATE TABLE Table2 (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT);
> =
> INSERT INTO Table2 VALUES (NULL,"Some text in Table2");
> INSERT INTO Table2 VALUES (NULL,"Some other text i
On Sat, 1 Mar 2008 15:27:19 -0500, "Igor Tandetnik"
<[EMAIL PROTECTED]> wrote:
>What do you mean, all the rows? Are you saying the resultset contains
>some rows where table1_field10 is not equal to table2_field1? With all
>due respect, I find it very hard to believe.
That's what happens, though.
Hey all,
Over at Mozilla we've been seeing a large amount of crashes in
sqlite3_enable_shared_cache. The stack frames don't make a whole lot
of sense to me, so I thought I'd inform you and hope that you might
have a better idea as to what is going on. If you have any questions,
feel free to ask.
On 3/1/08, Gilles Ganault <[EMAIL PROTECTED]> wrote:
> Hello
>
> I have two tables: Table1 has about 10 columns, Table2 has 2. I need
> to get all the columns of Table1 and only one column in Table2 where
> some field in Table1 is equal to field1 in Table2.
>
> This doesn't work as inten
"Gilles Ganault" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> I have two tables: Table1 has about 10 columns, Table2 has 2. I need
> to get all the columns of Table1 and only one column in Table2 where
> some field in Table1 is equal to field1 in Table2.
>
> This doesn't work as in
Thanks Igor and Teg, I think I know were I was going wrong now.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
"Toby Roworth" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> Looking at the API reference. it would apear you can send an extra
> "custom" argument to the callback fro sqlite3_exec, using the 4th
> parameter - how does this work, and inperticular, could I pass an
> object through to
Hello Toby,
You can pass in anything you want, a pointer, a number. As long as it
fits in the native size of the parameter. You can pass the ADDRESS of
an object as long as it doesn't go out of scope between the call and
when the processing finishes. I tend to pass the "this" pointer to the
class
Hello
I have two tables: Table1 has about 10 columns, Table2 has 2. I need
to get all the columns of Table1 and only one column in Table2 where
some field in Table1 is equal to field1 in Table2.
This doesn't work as intended, because it returns all the rows,
effectively ignoring the WHERE
Hi Michael,
> I have a table with two columns, the first with a string and the
> second with
> an integer.
> Given a set of input strings, I want to perform this operation
> 50,000+ times
So maybe something like:
create table InputTable
(
InputString text collate nocase
)
;
with
"Mahalakshmi.m"
<[EMAIL PROTECTED]> wrote
in message
news:[EMAIL PROTECTED]
> Can I bind the unsigned short value [ie., like 0x0065 for English and
> 0x3045
> for Japanese] to its corresponding string value.is it possible.
>
> Unsigned short temp;
> For eg,
> If temp = 0x0065 then its corresponding
Hello all
Looking at the API reference. it would apear you can send an extra
"custom" argument to the callback fro sqlite3_exec, using the 4th
parameter - how does this work, and inperticular, could I pass an object
through to the call back, and if so, how?
Thanks
Toby
Hello all
Looking at the API reference. it would apear you can send an extra
"custom" argument to the callback fro sqlite3_exec, using the 4th
parameter - how does this work, and inperticular, could I pass an object
through to the call back, and if so, how?
Thanks
Toby
_
Well I'm very new to SQLite but shouldn't:
UPDATE table SET Value=12.3 WHERE Address=7 and Port=1
be:
UPDATE table SET Value='12.3' WHERE Address='7' and Port='1';
sqlite3_vmprintf() is the recommended method to build SQL with
parameters.
Saturday, March 1, 2008, 6:31:50 PM, you wrote:
tti>
Hello all
Looking at the API reference. it would apear you can send an extra
"custom" argument to the callback fro sqlite3_exec, using the 4th
parameter - how does this work, and inperticular, could I pass an object
through to the call back, and if so, how?
Thanks
Toby
__
Hello all
Looking at the API reference. it would apear you can send an extra
"custom" argument to the callback fro sqlite3_exec, using the 4th
parameter - how does this work, and inperticular, could I pass an object
through to the call back, and if so, how?
Thanks
Toby
Hi,
> I am trying to compile sqlite in a /custom/directory and keep the ability
> to use arrows to get previously entered commands in the sqlite3
> executable. I read the wiki about that topic
> http://www.sqlite.org/cvstrac/wiki?p=ReadLine
> but I am still failing. It is advised to find the vari
[EMAIL PROTECTED] wrote:
>
> Hi,
> Is there a way to export/dump SQLite data into INSERT statements which
> also have column names?
>
> As of now, a sqlite dump looks like this
>
> INSERT INTO "ric_tb_language" VALUES('ENG','English');
> INSERT INTO "ric_tb_language" VALUES('SPN','Spanish');
> I
The code is very long, I'll try to put here the core of my application.
I'm using a C++ Class where one function is "sqlraw" that I use to
execute a SQL statement:
CLASS DEFINITION
sqlite3 *db;
int expander::
open_db(char * pDbName)
{
int rc;
rc = sqlite3_open(pDbName,
If my Table is as follows:
create table Music ( id integer not null primary key,
classificationCode integer, input text) <<
Table:
id classificationCode input
-- -- -
1 1 aaa
2 0 1345
3 1
Hi Kalyani,
There is a column named ROWID which gives you the internal row number.
Saturday, March 1, 2008, 9:32:44 AM, you wrote:
KP> In SQL Server2005, Row_number() function is used to retrieve the
KP> sequential number of a row within a partition of a result set, starting
KP> at 1 for the fir
I've downloaded and built the sources for the standard Intel Linux
platform but I want to run this on Linux on a Coldfire (MCF5484) platform.
How do I modify the compiler the build uses (short of just modifying the
Makefile)? I've looked at the Makefile.in but there's nothing obvious
about how to
32 matches
Mail list logo