Ah, there is a way to write it so that you can have at most one of
those constraints where only one makes sense, and not require a
specific order of constraints, but it'd require listing all the
possible orderings, which would be impractical.
So if one wanted to enforce that there's at most one
Simon Slavin-3 wrote:
On 19 May 2011, at 9:35am, Dev_lex wrote:
I need to prepare the statement before to know the name of the table, but
I'll find an other way..
I would like to do this :
const char *zSql = INSERT INTO ?(ID, MyData) VALUES('1',?);
Instead of using a
Forget my last post..
The error was that I didn't initialize pzTail to NULL...
That's ok :)
Dev_lex wrote:
Simon Slavin-3 wrote:
On 19 May 2011, at 9:35am, Dev_lex wrote:
I need to prepare the statement before to know the name of the table,
but
I'll find an other way..
I
Hi, I have a question about SQLite Encryption Extension (SEE) add-on.
I am using for develop a Visual Basic .NET v2010 with ADO.NET 2.0 and
*System.Data.SQLite
1.0.72.0* for work with DB.
If I adquire SEE add-on, it works correctly with *System.Data.SQLite
1.0.72.0*.
Thanks for all!
--
On 5/19/11 10:26 AM, Richard Hipp d...@sqlite.org wrote:
On Wed, May 18, 2011 at 6:52 PM, Chris Dillman
chris.dill...@zenimaxonline.com wrote:
Im having a lot of trouble getting a working build up and running.
You are building from the canonical source code, consisting of about 100
On 19 May 2011, at 4:32pm, Chris Dillman wrote:
On 5/19/11 10:26 AM, Richard Hipp d...@sqlite.org wrote:
The SQLite amalgamation would probably better
serve your purpose. It's just two files: sqlite3.c and sqlite3.h. There
is no configure script or makefile. No parameters to set.
On 19 mai 2011, at 17:32, Chris Dillman wrote:
On 5/19/11 10:26 AM, Richard Hipp d...@sqlite.org wrote:
On Wed, May 18, 2011 at 6:52 PM, Chris Dillman
chris.dill...@zenimaxonline.com wrote:
Im having a lot of trouble getting a working build up and running.
You are building from
Greetings.
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,...
I know I can do this call,
begin;
select * from Jobs where rec=1;
select * from Jobs where rec=2;
end;
and
Hi,
you want this:
select * from Jobs where rec in (1, 2)
Martin
Am 20.05.2011 15:00, schrieb jose isaias cabrera:
Greetings.
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,...
...
...
Martin Engelschalk, on Friday, May 20, 2011 9:04 AM wrote...
Hi,
you want this:
select * from Jobs where rec in (1, 2)
Martin
Darn it! Thanks. And that is easier... :-)
Am 20.05.2011 15:00, schrieb jose isaias cabrera:
Greetings.
I would like to get a bunch of records of IDs
jose isaias cabrera cabrera@... writes:
Greetings.
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,...
[...]
What about
SELECT *
FROM table
WHERE id BETWEEN
Oliver Peters on Friday, May 20, 2011 9:47 AM wrote...
jose isaias cabrera cabrera@... writes:
Greetings.
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,...
Hi,
to order, you have to use order by. In that case, however, it gets
complicated.
SELECT * FROM Jobs WHERE rec IN (87, 33, 27,2, 1)
order by case rec when 87 then 1
when 33 then 2
when 37 then 3
when 2 then 4
when 1
Martin Engelschalk on Friday, May 20, 2011 10:21 AM wrote...
Hi,
to order, you have to use order by. In that case, however, it gets
complicated.
SELECT * FROM Jobs WHERE rec IN (87, 33, 27,2, 1)
order by case rec when 87 then 1
when 33 then 2
when 37
If you just need them in descending order, i.e. not an arbitrary order,
then order by rec desc will work.
On 5/20/2011 7:23 AM, jose isaias cabrera wrote:
Martin Engelschalk on Friday, May 20, 2011 10:21 AM wrote...
Hi,
to order, you have to use order by. In that case, however, it gets
The setup packages available from here:
http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
are suppose to check if the MSVC runtimes are installed or not and install
them. It's the main reason the packages are as large as they are.
How did you install the SDS DLLs?
Thanks.
Switching to a single format greatly simplified things from an
administrative point of view - giving us a consistent single packaging
format across all platforms (Windows, Mono, Compact, ARM, etc.) - a support
customer even specifically pointed out this made things much easier for them
as well.
On Fri, May 20, 2011 at 12:10 AM, Michael Yeaney
michael.yea...@gmail.comwrote:
For the 1.0.72.0 (3.7.6+) package (x64), is there a stand-alone (mixed
mode) DLL offered anymore that does not require the interop library
(much like the 1.0.66.0 version?
Not currently, as Shane mentions (and
Meanwhile, perhaps, if you rephrase your goal and post again here on the
list, someone with experience in your environment (I'm NOT one of
those) will respond. I'm _guessing_ that you _don't_ mean to ask for the
xcopy command syntax itself:
Correct - what I'm looking for is the ability to
I've a patch that has only one bug that I'm aware of left: in
autocommit mode, a PRAGMA connect_triggers=1; will fire any connect
triggers and any before commit triggers, but not any after begin
triggers -- mildly annoying, but tolerable.
Writing tests, however, I discovered something subtle and
Answering myself...
It may be feasible to [with little code] catch schema changes that
would invalidate DB triggers before committing them. I'm not yet sure
how to do that without re-entrance, but that may be OK too (hey,
OP_ParseSchema does it). At least I've an idea that might be worth
I have two tables (msglog and msgtbl) I want do join together. On both table, I
have the following common fields:
iDeviceId Integer
iGroupId Integer
iCodeIdInteger
tMsgText
When I enter the following command, the table joins together but there is a lot
of fields in msgtbl that I
On 5/20/2011 8:36 PM, Yves Plasse wrote:
I have two tables (msglog and msgtbl) I want do join together. On both table,
I have the following common fields:
iDeviceId Integer
iGroupId Integer
iCodeIdInteger
tMsgText
When I enter the following command, the table joins
23 matches
Mail list logo