Alexandre Benson Smith wrote:
Em 31/7/2013 21:38, Iwan Cahyadi Sugeng escreveu:
I plan to check the historical table on system start and update the
metadata. I'm using n-tier solution, so my server application will do the
metadata update
I don't know your logic and perhaps this comment
Nevertheless, troubles arise if you have to query the historic
table, making joins with look up tables wich reside in the main
database.
A valid point of course, but not a problem in my case.
I don't have that many lookup tables I'd need to be duplicated.
Often enough I even don't need a
On 1 Aug 2013 13:47, Lester Caine les...@lsces.co.uk wrote:
I'd second that ...
Managing metadata should ALWAYS be detached from anything to do with
data. In
fact the only metadata changes to our historic data over the years has
been the
addition of a few extra fields.
And Aldo's comment
Dear All
select count(*) from customer ( returns 235384 )
select count(*) from customer where substring(upper(fname) from 1 for 1 ) in
('A','B','C',
'D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z')
( returns 187671 )
so there are 47.713 records
how about
select ascii_val(substring(upper(fname) from 1 for 1 )), count(*) from
customer group by 1
to get a list of the first ascii value and the number of records that have
that value
On 1 August 2013 11:41, Andy Samuel as...@yahoo.com wrote:
**
Dear All
select count(*) from customer
Thanks for all your replys.
My best guess has been/still is some networking issue, but we are unable to
find the cause of thís. As of right now I have this error when I would like to
restart a shutdown database on this server (a copy I made last week). I do this
with DB Workbench. I can open
Hi,
Thanks for that. Yes, that seemed to be the cause. I added an index on the join
and clause columns and now the query returns in under a second.
I didn't realise combining the indexes would be so expensive. Something to
remember!
Cheers,
From: Leyne,
Thanks Helen.
--- In firebird-support@yahoogroups.com, Helen Borrie helebor@... wrote:
At 06:48 a.m. 1/08/2013, GregB wrote:
[... describes .NET Provider problem...]
I originally posted about this issue back in September 2009 and because of
other priorities put it to bed for a
Dear All
select count(*) from customer ( returns 235384 )
select count(*) from customer where substring(upper(fname) from 1 for 1 ) in
('A','B','C',
'D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z')
( returns 187671 )
so there are 47.713 records
Hi Nick
Thank you very much for your reply.
It seems NULL is the answer, it has 9516 records.
But why is
select count(*) from customer where ascii_val(substring(upper(fname) from 1 for
1 ))=NULL ( returns 0 ) ?
Best regards
Andy
--- In firebird-support@yahoogroups.com, Nick Upson nu@...
sorry, double post, kind of new to post here. :)
--- In firebird-support@yahoogroups.com, ASOrg asorg@... wrote:
Dear All
select count(*) from customer ( returns 235384 )
select count(*) from customer where substring(upper(fname) from 1 for 1 ) in
('A','B','C',
Try this
select count(*) from customer
where substr(fname,1,1) not between upper('A') and upper('Z')
gives you the count
select fname from customer
where substr(fname,1,1) not between upper('A') and upper('Z')
order by fname
gives you the records
Alan
Alan J Davies
Aldis
On 01/08/2013 15:20,
Hi,
becuase you cannot do xx=NULL, you would need xx is null
select count(*) from customer where ascii_val(substring(upper(fname) from 1
for 1 )) is NULL
I expect would work, or
select count(*) from customer where fname is NULL ;
On 1 August 2013 15:30, ASOrg as...@yahoo.com wrote:
**
it works !
Thank you very much Nick for the enlightment :)
Best regards
Andy
--- In firebird-support@yahoogroups.com, Nick Upson nu@... wrote:
Hi,
becuase you cannot do xx=NULL, you would need xx is null
select count(*) from customer where ascii_val(substring(upper(fname) from 1
for 1
Hi Alan
Thank you for your reply
It returns 38212.
It is resolved now with the help from Nick ( I posted with different and wrong
subject )
Thank you very much and best regards
Andy
--- In firebird-support@yahoogroups.com, Alan J Davies Alan.Davies@... wrote:
Try this
select count(*) from
Hi *,
did I missed something in release notes about this:
SQL show version;
ISQL Version: WI-V2.1.5.18496 Firebird 2.1
Server version:
Firebird/x86-64/Windows NT (access method), version WI-V2.1.5.18496
Firebird 2.1
Firebird/x86-64/Windows NT (remote server), version WI-V2.1.5.18496
Firebird
--- In firebird-support@yahoogroups.com, lem_ita_78 wrote:
...
Is it possible to set something (a registry key, a config file, some other
trick) to tell windows where to look for this dll?
Yes, use instreg utility
Is it possible to move this dll to an other folder removing it from
17 matches
Mail list logo