Thanks zeljko for all the fixes. I'm updating my Lazarus now to try it out
at work.
Regards,
- Graeme -
--
___
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
Hi,
It's a little off-topic, because it's not about Pascal or Lazarus, but
it will be used in a Lazarus application, so I dare to ask here ;-).
I have a table with data, using Firebird. I want to have some statistics
so I use this query :
select a.TYPE, COUNT(*)
from Table a
WHERE a.date between
2010/2/5 Flávio Etrusco flavio.etru...@gmail.com:
So there you go. The parameter is passed as 'var', which implies
knowing the variable address. I doubt there's a valid reason for this,
so the fix would be to remove the 'var' modifier.
Thanks, that fixed it.
Roberto
[]s
On Fri, Feb 5,
If you really want three columns with counts for the two hardcoded
years, you could use subqueries:
with distinct_types (
type
)
as (
select distinct type from table
)
select
dt.type,
(
select
count(*) count_2008
from table
where (type = dt.type) and (extract(year from
Hi,
First, apologies for creating a new thread. I have to reply after
reading the archive. I didn't get any messages via mail from the list.
I'll have to check my filters, but I very much doubt the messages are
discarded.
Anyway, thanks, Ondrej, for your reply.
Are you sure the first query
Graeme Geldenhuys wrote:
Michael Van Canneyt wrote:
? OnGuard from turbopower does this. It is Object Pascal, so I don't see what
the problem with that could be ?
That is a sore point. We only found that after we did our implementation. :-(
Is the FPC+Lazarus port usable? Project status on
On 8 February 2010 12:29, Koenraad Lelong
laza...@brouwerij.homelinux.net wrote:
[snip]
Are you sure the first query runs on Firebird 2.0 ?
No, AFAIK, Firebird only supports common table expressions since 2.1.
Here's the SQL statement without the CTE:
select
a.type,
(
select
count(*)
On 08/02/2010 13:12, Ondrej wrote:
Here's the SQL statement without the CTE:
select
a.type,
(
select
count(*) count_2008
from table
where (type = a.type) and (extract(year from date) = 2008)
),
(
select
count(*) count_2009
from table
where (type =
Hi all,
I made a similar post on Delphi newsgroups but I it will be fpc lazarus
compatible since I need to use it with both envrionments.
I have started a Rich Internet Application framework which I'll eventually put
on google code under LGPL or similar license. I am using Adobe Flex as
http://yro.slashdot.org/story/10/02/08/1620238/SourceForge-Removes-Blanket-Blocking?art_pos=8
--
___
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
Hello,
maybe it's a bit late to bring this issue (for the current releases),
but is there a reason there was no announcements for the later FPC
releases and no Lazarus announcements ever?
I think LWN is an important channel to divulging OSS projects.
Best regards,
Flávio
--
Flávio Etrusco schreef:
Hello,
maybe it's a bit late to bring this issue (for the current releases),
but is there a reason there was no announcements for the later FPC
releases and no Lazarus announcements ever?
I think LWN is an important channel to divulging OSS projects.
What is LWN?
A little good news in the whole blanket blocking discussion:
SourceForge seem to have changed the policy regarding the block -
perhaps the Free Pascal project and Lazarus should look into these changes:
http://sourceforge.net/blog/some-good-news-sourceforge-removes-blanket-blocking/
Kind
Hi Lee (and anybody else),
In you flash demo, I saw something interesting in Delphi (sorry, not
related to Flex/RIA) - the code navigation highlighted in the attached
screenshot.
Is that something standard with Delphi or is it a add-on package? I've been
wanting to implement something like that
On Thu, Jan 21, 2010 at 11:22:22AM +0200, Graeme Geldenhuys wrote:
Besides the deployment issues, another thing that discourages me from
writing software for Linux is the virtual non existence of anti-cracking
software.
I know what you mean. We flew 1200km to the biggest Security
15 matches
Mail list logo