To all who replied, thanks for all the help.
Naming the columns in not a problem. It's easy enough to get the column names
and build the appropriate select statement.
Thanks again,
--
Bill Drago
Staff Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / William.Drago at
On 11 May 2016, at 11:26am, William Drago wrote:
> Is there a simple way to find a row in a table where none of columns contain
> a null value? For example:
>
> SELECT * FROM AnyTable WHERE (all columns IS NOT NULL) LIMIT 1;
The coalesce(a,b,c, ...) function returns the first of its
To get this effect you need to have 2 (shareable) images, each with their own
and very private copy of sqlite, loaded into the same process.
With the mentioned #defines that make all sqlite3 symbols become static, it is
quite easy to compile sometool.c and sqlite3.c into a single sometool.so
On Wed, 11 May 2016 06:26:23 -0400, William Drago
wrote:
> All,
>
> Is there a simple way to find a row in a table where none of
> columns contain a null value? For example:
>
> SELECT * FROM AnyTable WHERE (all columns IS NOT NULL) LIMIT 1;
>
> Or do I have to do this manually in my
Le 12:26 11/05/2016, vous avez ?crit:
>All,
>
>Is there a simple way to find a row in a table where none of columns contain a
>null value? For example:
>
>SELECT * FROM AnyTable WHERE (all columns IS NOT NULL) LIMIT 1;
select * from AnyTable col1||col2||...||coln is not nul limit 1;
Fine for
I also cannot think of a way to do this without naming columns. If this is
something you have to do frequently from multiple locations, it might be
worth creating a view that does the hard work in one place.
On Wed, May 11, 2016 at 10:29 AM, Simon Slavin wrote:
>
> On 11 May 2016, at 11:26am,
> bounces at mailinglists.sqlite.org] On Behalf Of Simon Slavin
> It's only a certain kind of Windows user who wants DLLs for everything.
If
> that's what you need you are going to have to make sure you get the right
> DLL. But the fact that most SQLite programmers don't use a DLL is why
you're
I?m currently implementing a custom FTS5 tokenizer which I?d like to
automatically register for each db connection.
So I tried to register an extension hook with sqlite3_auto_extension but when
my code is called the FTS_* modules have not been initialized, because
sqlite3Fts5Init() is called
On 5/11/16, Steve Schow wrote:
>
> Typically concurrency happens when two different users execute their program
> that has sqlite compiled into it;?.. concurrently.
The problem only comes up with two different copies of SQLite are
running within the same process. The same program being run
On Tue, 10 May 2016, at 17:17, Simon Slavin wrote:
>
> On 10 May 2016, at 4:56pm, Jeremy Nicoll
> wrote:
>
> > That suggests to me that sqldiff & sqlite3 only use a small fraction of
> > the code present in
> > a DLL, and the link only includes those functions in the resulting .exe.
>
>
> bounces at mailinglists.sqlite.org] On Behalf Of Simon Slavin
>
>> It's only a certain kind of Windows user who wants DLLs for everything. If
>> that's what you need you are going to have to make sure you get the right
>> DLL. But the fact that most SQLite programmers don't use a DLL is why
Ok?starting to sound safer. :-)
at a minimum this problem only occurs when multi-threading is being used to
access a sqlite DB file. but I think its probably even more specific then that?
When you say ?two copies of sqlite in the same address space?, this is the part
I am getting confused
-- next part --
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 181 bytes
Desc: OpenPGP digital signature
URL:
<http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20160511/002364b4/attachment.pgp>
On Wed, May 11, 2016 at 4:16 AM, Roger Binns wrote:
> On 10/05/16 10:42, Andrey Gorbachev wrote:
>> I am a bit worried that the initialisation of 2 different versions of SQLite
>> would interfere with one another. Any advice?
>
> There is a way to do it, [...] create a .c file that near the top
On May 11, 2016, at 8:22 AM, Steve Schow wrote:
>
> Oh that actually makes more sense?but also even more concerning in a way,
> unless I?m still misunderstanding the conundrum.
Just thinking out loud?.is this problem related to specifically when people try
to compile sqlite into a shared
On May 10, 2016, at 4:15 PM, Richard Hipp wrote:
> On Tue, 10 May 2016 22:47 +0100, Tim Streater wrote:
>>
>> I read it as two different *copies*. It doesn't sound to me as if the
>> versions have anything to do with it.
>>
>
> Correct. Two different *copies*of the library. They can both
All,
Is there a simple way to find a row in a table where none of
columns contain a null value? For example:
SELECT * FROM AnyTable WHERE (all columns IS NOT NULL) LIMIT 1;
Or do I have to do this manually in my application scanning
every column in every row until I find a row with no nulls?
2016-05-10 23:27 GMT+02:00 R Smith :
>
>
> On 2016/05/10 11:05 PM, Cecil Westerhof wrote:
>
>> 2016-05-10 22:06 GMT+02:00 Darren Duncan :
>>
>> On 2016-05-10 12:03 AM, Cecil Westerhof wrote:
>>>
>>> But it looks like that the following is also acceptable:
?
CAST(ROUND(100.0 * rank
On 10 May 2016, at 10:29pm, Steve Schow wrote:
> are you saying that on UNIX, if two different versions of the sqlite3 binary
> attempt to access a DB file at the same time?then the globals that are used
> in the sqlite3 binaries related to locking may be different in the two
> different
On 2016/05/10 11:05 PM, Cecil Westerhof wrote:
> 2016-05-10 22:06 GMT+02:00 Darren Duncan :
>
>> On 2016-05-10 12:03 AM, Cecil Westerhof wrote:
>>
>>> But it looks like that the following is also acceptable:
>>> ?
>>> CAST(ROUND(100.0 * rank / outOf + 0.499) AS int) AS percentage
>>>
2016-05-10 22:06 GMT+02:00 Darren Duncan :
> On 2016-05-10 12:03 AM, Cecil Westerhof wrote:
>
>> But it looks like that the following is also acceptable:
>> ?
>> CAST(ROUND(100.0 * rank / outOf + 0.499) AS int) AS percentage
>> and it is a lot simpler. So probably I will go for this.
>>
>
21 matches
Mail list logo