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
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
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
pursing
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 o
> 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 t
On Fri, May 20, 2011 at 12:10 AM, Michael Yeaney
wrote:
> 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 as quoted from under Bu
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 we
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.
-Sha
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, howeve
"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
>
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
"Oliver Peters" on Friday, May 20, 2011 9:47 AM wrote...
> jose isaias 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
jose isaias 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 BETWEE
"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 rec
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,...
> ...
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 tha
On 19 mai 2011, at 17:32, Chris Dillman wrote:
>
>
> On 5/19/11 10:26 AM, "Richard Hipp" 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 build
On 19 May 2011, at 4:32pm, Chris Dillman wrote:
> On 5/19/11 10:26 AM, "Richard Hipp" 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. Nothing to
On 5/19/11 10:26 AM, "Richard Hipp" 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
>separate
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!
--
*Daniel
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 o
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',?)
22 matches
Mail list logo