Microsoft SQL seems to use the column names from the
first select. So that would be "a, b" in your example.
Rob
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Sqlite-users"
Sent: Saturday, March 25, 2006 3:45 PM
Subject: [sqlite] Column names in a UNION
Who can tell me what th
Hi Ralf,
If I remember correctly you cannot use a SQLite database handle
across threads. Each thread will need to open (and close) the
database itself.
Cheers,
Rob
- Original Message -
From: "Ralf Junker" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, March 21, 2006 12:02 PM
Subject: [sqlit
Hi,
According to that ticket it is fixed in the latest
download on the website. So there should be
no need to recompile yourself unless it is an
older version?
Cheers,
Rob
- Original Message -
From: "Clinco, Michele" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, March 21, 2006 9:37 AM
Subj
Hi,
I suspect "your network" (solution) is to blame. The client
probably needs to (re)connect to your server or (re-)
authenticate etc.
This can easily be tested by running the application and
database on the same system. Is the first query does not
take 2 seconds you have your answer.
Keep in
If I'm not mistaken you still need to close the transaction.
Are you doing an "end transaction" even if a statement
fails (ie, a rollback is done)?
- Original Message -
From: "nbiggs" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, March 01, 2006 10:24 PM
Subject: [sqlite] Failing Transaction
That information was given (in an email) when you subscribed:
To remove your address from the list, just send a message to
the address in the ``List-Unsubscribe'' header of any list
message. If you haven't changed addresses since subscribing,
you can also send a message to:
<[EMAIL PROTECTED]>
It seems we are both right :)
sqlite> create table test (filename varchar(1000) primary key);
sqlite> insert into test (filename) values ('test');
sqlite> select * from test where filename='test';
test
sqlite> select * from test where filename='tesT';
sqlite> select * from test where filename lik
Keep in mind that string should be surrounded by
single quotes instead of double quotes:
exact match:
select * from test where filename = 'file';
partial match:
select * from test where filename like '%file%';
Also keep in mind that such a search is CASE SENSITIVE.
There are two solutions to
Hi Niels,
The sqlite3.dll is not a .NET assembly or a COM component,
so you can't add it to your project or regsvr32 it. You add the
SQLite.NET wrapper as an assembly to your project. This
wrapper will then load sqlite3.dll for you.
I don't know this wrapper so I can't tell you where it will loo
How can you be sure? It appears from that ticket that
there is something wrong with the default binary for
Windows (I've verified the relocation problem myself).
I can imagine that the more tight security on win2k3
(sp1) simply doesn't want to load the DLL when it is
not 100% "ok"? It sounds prett
I like your concept and agree with your design choices, so much in fact
that I independently implemented a very similar system. In my case I
packaged the responses in XML,
Difficult isn't it, XML or no XML :-) I had also considered XML, if
nothing else it is the 'in thing'. But the other side
Isn't it so that sqlite3 can't open certain
old sqlite2 database because of a format
change? At least I seem to remember
something like that. I would try opening
it with version 2.
Rob
- Original Message -
From: "Manuel Enache" <[EMAIL PROTECTED]>
To:
Sent: Monday, November 07, 2005 3
You don't need to insert the primary key at all, so
don't insert a NULL. See the test below:
D:\SQLite>sqlite3 mltest.db
SQLite version 3.2.1
Enter ".help" for instructions
sqlite> CREATE TABLE projects(project_id INTEGER PRIMARY KEY, cip_number);
sqlite> INSERT INTO projects (cip_number) VALUES
The authorizer is used to protect against SQL injection attaches
when the SQL text originates from user input. Typically an
application will turn the authorizer on when preparing user-supplied
SQL then turn it right back off again so that its own internal
SQL can run unfiltered. Example:
sql
Another proposal: Suppose that when creating an
sqlite3_stmt using sqlite3_prepare, the original SQL
text was stored in the sqlite3_stmt. Then when a
schema change occurred, the statement was automatically
recompiled and rebound. There would no more SQLITE_SCHEMA
errors. But sqlite3_stmts woul
A quick test here on MSSQL & Oracle:
Microsoft SQL 2000 & SQL 2005 (beta):
create table MATHTEST (
CINT int null,
CDEC decimal null,
CDPREC double precision null,
CFLOAT floatnul
edge to fix it himself
and no if there are any consequences or not.
us all, and won't come off as such an irritating whiner.
This is just completely rude and uncalled for. If you don't
want to "waste your time" discussing a genuine concern,
then why bother replying at al
I assume the wrapper has wrapped this particular function. I'm
currently writing my own wrapper and it has wrapped it as well.
This is my definition (in case your wrapper doesn't have it):
///
/// Returns the lengh of data in a single column of the current result row
of a query
///
/// Statem
Isn't this what you are looking for?
http://www.sqlite.org/capi3ref.html#sqlite3_column_bytes
" If the result is a BLOB then the sqlite3_column_bytes() routine returns
the number of bytes in that BLOB. "
Or do you really need it inside an SQL statement?
Rob
- Original Message -
Fro
Sorry, I forgot to add: sqlite3_column_name(16). Currently I
let MS .NET free memory from that as well.
Thanks,
Rob
- Original Message -
From: "Rob Lohman" <[EMAIL PROTECTED]>
To:
Sent: Friday, October 21, 2005 7:05 PM
Subject: [sqlite] who is responsible for memor
atly appreciated.
Thanks!
Best,
Rob Lohman
21 matches
Mail list logo
