Andrew Rondeau wrote:
>
> Hmmm, part of the point of Mono is that a pure CLR .dll or .exe can work
on
> any platform without recompilation.
>
The standard build of System.Data.SQLite looks for a native assembly (DLL)
named
"SQLite.Interop.dll" and this has always been the case. It is possible
Hmmm, part of the point of Mono is that a pure CLR .dll or .exe can work on
any platform without recompilation.
How can I have a System.Data.SQLite that will work on Windows x86, x64, and
the various Unixes without recompiling System.Data.SQLite? PHX's older
version of System.Data.SQLite does this
On 3/13/2012 10:38 PM, FengTao DING wrote:
Hi all,
I wrote a piece of code, that open two sqlite3 connections, use connection1
to do a SELECT query, while stepping in this query,
when some condition matches, it uses connection2 to do a INSERT query;
when another condition matches, it uses conne
Use one connection. Attach the other DBs to this one connection, then
use INSERT OR REPLACE INTO table SELECT ...;. See the recent thread
about INSERT OR REPLACE.
Nico
--
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-
Hi all,
I wrote a piece of code, that open two sqlite3 connections, use connection1
to do a SELECT query, while stepping in this query,
when some condition matches, it uses connection2 to do a INSERT query;
when another condition matches, it uses connection2 to do a UPDATE query.
As common resul
On Tue, Mar 13, 2012 at 7:06 PM, Rob Richardson wrote:
> Thank you very much for your quick reply, Dr. Hipp, and I will fix my
> code. Probably I was trying to execute a statement before opening the
> database.
>
> But the question remains: Should sqlite_exec() always generate an error
> message
Thank you very much for your quick reply, Dr. Hipp, and I will fix my code.
Probably I was trying to execute a statement before opening the database.
But the question remains: Should sqlite_exec() always generate an error
message, or should I be prepared to handle the case in which it does n
On Tue, Mar 13, 2012 at 6:43 PM, Rob Richardson wrote:
> Hello!
>
> I am sending a badly formed query string to sqlite_exec(). It is giving
> me error 21 (misuse of library), but it is not giving me an error message.
> The value of the pointer sent as the fifth argument of sqlite_exec() is
> not
Hello!
I am sending a badly formed query string to sqlite_exec(). It is giving me
error 21 (misuse of library), but it is not giving me an error message. The
value of the pointer sent as the fifth argument of sqlite_exec() is not
changed. Is this expected behavior? Is there something I have
On Mar 13, 2012, at 11:05 PM, Udi Karni wrote:
> Is there a way to increase the number of attached databases beyond the
> default of 10 - from the command shell - by issueing a command / pragma?
Not from the shell, but check SQLITE_MAX_ATTACHED:
http://sqlite.org/limits.html
___
Hello,
Is there a way to increase the number of attached databases beyond the
default of 10 - from the command shell - by issueing a command / pragma?
I have 50+/- large tables (50GB - 100GB) and maintenance / transfer of them
is much easier if each one is in its own SQLite DB file.
I need to ru
On Tue, 13 Mar 2012 02:28:38 +, YAN HONG YE
wrote:
>here my code,where is wrong?
>char mma[250];
>strcpy(mma,"sqlite3 foods.db \" .separator ',' \" \".import dzhhkmysql.txt
>dzh\"");
>system(mma);
dot-commands for the sqlite3 command line tool have to be on separate
lines.
Do the equivalen
On 3/13/2012 11:41 AM, Marco Bambini wrote:
I have a table defined like:
foo (id INTEGER, pid INTEGER, oid INTEGER)
id is an unique identification number
pid is parent_id
oid is order_id
and with some data like:
id pid oid
74 1 1
42
Hello,
I have a table defined like:
foo (id INTEGER, pid INTEGER, oid INTEGER)
id is an unique identification number
pid is parent_id
oid is order_id
and with some data like:
id pid oid
74 1 1
42 1 2
28 0
Thank you,
pragma is perfect!
Alessio Forconi
Il 12/03/12 22:47, Roger Binns ha scritto:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/03/12 14:42, Alessio Forconi wrote:
I am a novice with SQLite and I wonder if there is a select that
returns the names of the fields in the table?
Y
On Tue, Mar 13, 2012 at 3:16 PM, Jean-Christophe Deschamps wrote:
> Why do you register the function with -1 in the first place?
> Register both 2- and 3-parms functions (if you have those two variations),
> both pointing to the same function code: argc is valid and let you decide
> what to do wi
On 13 March 2012 10:59, Max Vlasov wrote:
> Hi,
>
> Is there a way to know the number of parameters passed for user function
> with undefined argument count (nArg = -1 in the Sqlite3_create_function
> call).
>
> I could not find a function specific to this task and thought that I at
> least can ch
Hi Max,
Is there a way to know the number of parameters passed for user function
with undefined argument count (nArg = -1 in the Sqlite3_create_function
call).
I could not find a function specific to this task and thought that I at
least can check sqlite3_values array members for zero for my
i
Hi,
Is there a way to know the number of parameters passed for user function
with undefined argument count (nArg = -1 in the Sqlite3_create_function
call).
I could not find a function specific to this task and thought that I at
least can check sqlite3_values array members for zero for my implemen
19 matches
Mail list logo