05.01.2017 8:51, Nico Speleers - Carfac BVBA nico.spele...@carfac.com
[firebird-support]
wrote:
> If I execute Create table MyTable(aField integer) then the tablename is saved
> as MYTABLE.
Why do you care how it is saved? Just don't look into system tables when
writing your
queries.
--
Based on table- and columnnames in camelcase our programmers can automatic
create their objects and classes. Therefore we need to create our table- and
columnnames in camelcase. Another reason is readability. We found camelcase
more readable then UPPERCASE.
Have you got a solution for my proble
05.01.2017 10:36, Nico Speleers - Carfac BVBA nico.spele...@carfac.com
[firebird-support]
wrote:
> Have you got a solution for my problem ?
There is no solution for your problem.
--
WBR, SD.
++
Hello Nico,
>I want to create a tablename in camelcase without using quotes.
>
>If I execute Create table MyTable(aField integer) then the tablename is
>saved as MYTABLE. And yes then you can use camelcase >without quotes.
>
>Can you find a solution ?
The only solution to preserving case, is to
Hi all,
Any idea what this error code means?
RECREATE PACKAGE BODY PCK_TEST failed
unknown ISC error 336068898
while executing:
RECREATE PACKAGE BODY PCK_TEST AS
begin
... code
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Or
05.01.2017 12:17, 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com
[firebird-support] wrote:
> Any idea what this error code means?
"Default values for parameters are allowed only in declaration of packaged
function @1.@2"
Make sure that you use fbclient.dll and firebird.msg of
This "Problem" is listed in the tracker:
http://tracker.firebirdsql.org/browse/CORE-1645
I don't understand who ever though of supporting case-behaviour, why the
hell should i want a table named "ATable" and "atable" and both different
tables.
Anyway this is something what is inherited from the
Good day everybody,
I have the following query
select
D.NAME as NAME,
(case (extract (Weekday from P.plandate )) when 1 then (P.PLANSTATUS)
else '' end) as Monday,
(case (ext
We have another tables that contain definition of each relation and each
field.
Data for this tables are automatically generated from case tool like this:
EXECUTE BLOCK AS BEGIN
--definition fields for entity: USERFUNCTIONS
IF (EXISTS(SELECT 1 FROM rdb$relations where rdb$relation_name =
'USERF
Hello,
We've got different firebird servers for our customers but connection time is
different depending on which server we are connecting to. Server's software
configuration should be the same (Firebird 2.5.5 64bits Classic server on
Centos 7.3), hardware configuration are slightly different
05.01.2017 14:40, Marianne Castel - Titelive caste...@titelive.be
[firebird-support] wrote:
> Has somebody an idea, where is the sytem loosing time ?
Most often (x)inetd waste time trying to identify client by ident protocol
or reverse
DNS to get host name.
--
WBR, SD.
--
Hello Dimitry,
>05.01.2017 12:17, 'Martijn Tonies (Upscene Productions)'
>m.ton...@upscene.com
>[firebird-support] wrote:
>> Any idea what this error code means?
>
> "Default values for parameters are allowed only in declaration of
> packaged function @1.@2"
Thanks.
> Make sure that you us
05.01.2017 15:35, 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com
[firebird-support] wrote:
>> Make sure that you use fbclient.dll and firebird.msg of version 3.
> I didn't the '@', that I usually see when mismatching fbclient/firebird.msg
> ;)
You get it when use firebird.msg ve
Hi,
when you migrate something and this is reserved word you name it with quotes,
and also if it contain space
but i prefer in that migration to change the name instead using double quotes.
But another place where it is vital to have double quotes supported is
select field as "some name for fiel
Hi,
"case" is function and operate on row data.
If you have 7 rows then you got 7 rows after case
To reduce rows you need to "group by"
regards,
Karol Bieniaszewki
W dniu 2017-01-05 13:12:10 użytkownik 'Stef' s...@autotech.co.za
[firebird-support] napisał:
Good day everybody,
I
On Wed, Jan 4, 2017 at 9:41 AM, Nico Speleers - Carfac BVBA
nico.spele...@carfac.com [firebird-support] <
firebird-support@yahoogroups.com> wrote:
We want to create table- and fieldnames (Firebird 3) in camelcase. If we
> want to write a select statement we have to use quotes around a tablename.
>
Hi Karol
Thank you for the feedback, I understand what you mean, but how would I go
about adding or changing to get the “group by”?
This is the result I get
NAME
MONDAY
TUESDAY
WEDNESDAY
THURSDAY
FRIDAY
SATURDAY
SUNDAY
JOHN DOE
hi-
I have tried so hard to get firebird 2.5 up and running. I cannot anywhere
find the command to start and restart the server on fedora for firebird-classic.
It seems like that command has vanished from the internet!
I also cant telnet like this:
telnet localhost 3050
and get the error lik
hi -
I changed the service to gds_db. not sure if that will help.
Also, here is more complete information on telnet:
[turbolinux@localhost firebird]$ telnet localhost 3050
Trying ::1...
telnet: connect to address ::1: Connection refused
Trying 127.0.0.1...
telnet: connect to address 127.0.0.1: C
HI-
i needed to do fb_inet_server -m
I wish I could find help on that command.
also my telnet didn't work.
on fedora you need a file on this path: cd /usr/lib/systemd/system
and this file goes in that directory: telnet.socket
i was missing telnet-server package in fedora.
Any help on where
Hello all,
As you know, on a single connection, Firebird's cpu utilization calculate by
100% / no of cores.
On my 6 cores cpus, its only utilized 100% / 6 = 16%.
During database maintenance & testing (backup, restore, testing, etc) ,
sometimes, i feel it was to slow.
I want to change cpu uti
Hello all,
As you know, on a single connection, Firebird's cpu utilization calculate by
100% / no of cores.
On my 6 cores cpus, its only utilized 100% / 6 = 16%.
During database maintenance & testing (backup, restore, testing, etc) ,
sometimes, i feel it was to slow.
I want to change cpu uti
Hi-
I thought I could use some services to shut down firebird with classic. I get
this error message.
I didn't know if it is safe or the preferred way to shut down classic by just
ctrl-c when
i used # ./fb_inet_server -m. The way I tried is like systemctl enable
firebird-classic.socket
HI-
I kind of solved the problem but not really. I just used super-classic.
now i can stop and start the server at will.
To help someone else out if they come across this in fedora24 I do:
[root@localhost system]# systemctl start firebird-superclassic.service
[root@localhost system]# top -b -n
24 matches
Mail list logo