Am Freitag, den 09.01.2015, 21:04 -0500 schrieb Richard Hipp:
> On 1/9/15, Paul Menzel wrote:
> > Am Dienstag, den 30.12.2014, 16:15 +0100 schrieb Paul Menzel:
> >
> > With still around 1.3 GB free on the partition mounted to `/var/`,
> > Evolution crashed with the f received the following
Hi
I have application compiled under Visual Studio 2012 on a Window 7 64 bit
machine. I am trying to use the sqllite dll .90.
My application calls a DLL that uses the sqllite dll to open a database.
However, when I am debugging I get the BADImageFormatException error "An
attempt was made
On 1/9/15, RSmith wrote:
> The pre-compiled and supplied DLL (sqlite3.dll) seem to be missing an entry
> point for "sqlite3_enable_load_extension" - I do not see
> any mention in the update text about altering or removing this feature so I
> am assuming this might be a
Taylor, Jill (RBI-US) wrote:
>
> My application calls a DLL that uses the sqllite dll to open a database.
However,
> when I am debugging I get the BADImageFormatException error "An attempt
was made
> to load a program with an incorrect format error"
>
These are typically caused by a 32-bit
The documentation for aggregate functions states that "In any aggregate
function that takes a single argument, that argument can be preceded by the
keyword DISTINCT". My questions are: Why is DISTINCT only allowed with a
single argument in a function like GROUP_CONCAT? Can that limitation be
On 1/10/15, Staffan Tylen wrote:
> I'm in the situation where I need to use GROUP_CONCAT and filter out
> duplicates at the same time. And the default comma separator in
> GROUP_CONCAT needs to be replaced by a space. I've tried to use function
> REPLACE to get rid of the
Thanks Richard but unfortunately I cannot use DISTINCT in that way, since
it affects all the selected columns and they are MANY.
Staffan
On Sun, Jan 11, 2015 at 12:43 AM, Richard Hipp wrote:
> On 1/10/15, Staffan Tylen wrote:
> > I'm in the situation
Hmm, maybe I'm wrong there, it would remove duplicates of the entire
collection combined, wouldn't it? Yes, it might work.
Staffan
On Sun, Jan 11, 2015 at 12:56 AM, Staffan Tylen
wrote:
> Thanks Richard but unfortunately I cannot use DISTINCT in that way, since
> it
On Sat, Jan 10, 2015 at 5:56 PM, Staffan Tylen
wrote:
> Thanks Richard but unfortunately I cannot use DISTINCT in that way, since
> it affects all the selected columns and they are MANY.
>
> Staffan
>
I am having trouble visualizing what your actual SELECT is. Would
Well, the SELECT is actually over 400 lines long so 'visualizing' it
wouldn't be very easy :) But it's along these lines:
SELECT X FROM
(SELECT 'ABC'||
IFNULL(' PARM('||GROUP_CONCAT(COL1,' ')||')'),' ')||
etc
FROM T1
LEFT JOIN T2
LEFT JOIN T3
etc etc (lots of joins)
UNION
SELECT 'DEF'||
etc
Just to add: my questions were - why this limitation with DISTINCT, and can
it be changed at least for GROUP_CONCAT?
On Sun, Jan 11, 2015 at 1:23 AM, Staffan Tylen
wrote:
> Well, the SELECT is actually over 400 lines long so 'visualizing' it
> wouldn't be very easy :)
11 matches
Mail list logo