I think this behaviour is consistent with the ANSI standard. The double
quotes are necessary (if my memory serves me correctly) if there are
characters in the user name that are not letters numbers and underscores.
Maybe hyphens/minus are allowed also. But it's the dot that is annoying the
The firebird-support Yahoo Group has moved to Google Groups at
https://groups.google.com/d/forum/firebird-support. Please subscribe and
post your question there.
Mark
On 2020-07-28 15:23, hamacker sirhamac...@gmail.com [firebird-support]
wrote:
> If I try in FB3 (latest version):CREATE
>
28.07.2020 15:23, hamacker sirhamac...@gmail.com [firebird-support] wrote:
> I think that double quotes are used only if you want case sensitive
They are required for any SQL identifier that contains non-allowed
characters.
--
WBR, SD.
If I try in FB3 (latest version):
CREATE
USER 'ROBOT.CUSTOS' -- wont run
PASSWORD 'password'
FIRSTNAME 'ROBOT'
MIDDLENAME 'DE'
LASTNAME 'CUSTOS' ;
Not run! but If I try:
CREATE
USER "ROBOT.CUSTOS" -- it´s run
PASSWORD 'password'
FIRSTNAME 'ROBOT'
MIDDLENAME 'DE'
LASTNAME
On 8/19/19 4:46 AM, m.djo...@gmail.com [firebird-support] wrote:
>
>
> The following query shows that ROUND function does not give similar
> results for similar values:
>
>
> select
> round(cast(0.725 as double precision), 2),
> round(cast(1.725 as double precision), 2),
>
The following query shows that ROUND function does not give similar results for
similar values:
select
round(cast(0.725 as double precision), 2),
round(cast(1.725 as double precision), 2),
round(cast(2.725 as double precision), 2),
round(cast(3.725 as double precision), 2),
A warning would be enough.
If after the INTO clause there are 2 or 3 variables, no problem, it will be
very easy to detect the mistake. But sometimes that is not the case because
there are 20+ variables and if variable 3 is called "lcName" and variable
24 is called "lcName" too, the programmer
Doug,
> Delphi's latest compiler provides a hint in these cases:
>
> var
> x: Int32;
> begin
> try
> x := 0;
> x := 1;
> writeln(x);
> end.
>
> [dcc32 Hint] Project1.dpr(14): H2077 Value assigned to 'x' never used
> (Line 14 is the one assigning zero.)
In hindsight my post
Some times,
I need to create a query where there is a 'where (0=0)' .
it´s not logic for anyone.
But to me, it´s significant because I need to certify that WHERE clausule
always exists when populate my query with dinamic filters controlled by my
application.
In your example, I can espaculate that
Interesting. (I haven't used Delphi for decades, certainly not this
century.)
On 09/02/2017 13:17, DougC d...@moosemail.net [firebird-support] wrote:
Delphi's latest compiler provides a hint in these cases:
var
x: Int32;
begin
try
x := 0;
x := 1;
writeln(x);
end.
[dcc32 Hint]
Delphi's latest compiler provides a hint in these cases:
var
x: Int32;
begin
try
x := 0;
x := 1;
writeln(x);
end.
[dcc32 Hint] Project1.dpr(14): H2077 Value assigned to 'x' never used
(Line 14 is the one assigning zero.)
On Thu, 09 Feb 2017 04:30:06 -0500 Tim
Hmm - Delphi and Free Pascal do exactly that - they emit a warning, that
the first assigned value never gets used.
Am 09.02.2017 um 10:30 schrieb Tim Ward t...@telensa.com [firebird-support]:
>
>
> It' the equivalent in a conventional programming language of saying:
>
> x = a;
> x = b;
>
>
It' the equivalent in a conventional programming language of saying:
x = a;
x = b;
where the compiler is expected to know that neither a not the first
assignment have any side effects other than the assignment (and where
the expression b doesn't depend on the value of x)(and where x isn't
The error is of the programmer, I agree with you, but to repeat the name of
a variable without the Firebird showing any message of error is, at least
for me, a bug.
To have 2 or more variables with the same name after the INTO clause is
useless. The compiler can be smart enough to detect such
> Yes, but I can not know the value of the column X.ALU_NOMBRE
>
> And the idea, of course, is know that value, that's why it appears in the FOR
> SELECT. If not, I can do nothing with X.ALU_NOMBRE
You are asking for the system to evaluate the *intent* of logic.
That is completely outside the
Yes, but I can not know the value of the column X.ALU_NOMBRE
And the idea, of course, is know that value, that's why it appears in the
FOR SELECT. If not, I can do nothing with X.ALU_NOMBRE
Greetings.
Walter.
On Wed, Feb 8, 2017 at 12:02 PM, Dimitry Sibiryakov s...@ibphoenix.com
CREATE PROCEDURE TEST
RETURNS(
lcName VARCHAR(40))
AS
BEGIN
FOR SELECT
ALU_NOMBRE,
ALU_APELLD
FROM
ALUMNOS
INTO
:lcName,
:lcName
DO
SUSPEND;
END;
In the above stored procedure there are 2 columns in the FOR SELECT but
just 1 variable name.
It
Den 29.10.2015 19:22, skrev hamacker sirhamac...@gmail.com
[firebird-support]:
Hi everybody.
When I try:
select (2183.48/(1-(37.25/100))) as valor from rdb$database
As result Firebird: 3465,8412
But other databases(MSSQL) and spreadshets(Excel and Calc) the correct
result is 3479,6494023904
Hi everybody.
When I try:
select (2183.48/(1-(37.25/100))) as valor from rdb$database
As result Firebird: 3465,8412
But other databases(MSSQL) and spreadshets(Excel and Calc) the correct
result is 3479,6494023904
If I change (37.25/100) to 0.3725 as follow:
select (2183.48/(1-0.3725)) as
Thanks.
One more question, It´s a firebird way or it´s a math general consensus?
I try a lot of programs, and only firebird return wrong value.
2015-10-29 16:30 GMT-02:00 setysvar setys...@gmail.com [firebird-support] <
firebird-support@yahoogroups.com>:
>
>
> Den 29.10.2015 19:22, skrev
On 29-10-2015 19:22, hamacker sirhamac...@gmail.com [firebird-support]
wrote:
> When I try:
> select (2183.48/(1-(37.25/100))) as valor from rdb$database
>
> As result Firebird: 3465,8412
> But other databases(MSSQL) and spreadshets(Excel and Calc) the correct
> result is 3479,6494023904
>
> If
W dniu 2015-06-23 10:38:25 użytkownik brucedickin...@wp.pl [firebird-support]
firebird-support@yahoogroups.com napisał:
Hello guys,
today I've stumbled on some strange (in my opinion) behaviour.
Firstly, create these two structures:
CREATE GLOBAL TEMPORARY TABLE GLB_CS_TEMP
(
Hello guys,
today I've stumbled on some strange (in my opinion) behaviour.
Firstly, create these two structures:
CREATE GLOBAL TEMPORARY TABLE GLB_CS_TEMP
(
ID_MON_OBJECT INTEGER NOT NULL,
ID_PARAM INTEGER NOT NULL,
MEASUREMENT_DATE TIMESTAMP,
PARAM_VALUE VARCHAR(64) DEFAULT '',
20.09.2013 13:36, Kjell Rilbe wrote:
Strangely enough I SET's reply hasen't shown up in my inbox, and yes I
did check the spam/garbage folder. Anyway, I know separate subplans are
enumerated without comma, but it seems odd, then, that it doesn't prefix
*all* subplans with PLAN.
IIRC, unions
Kjell,
Rows that are returned when there's a WHERE clause, but not if there's
no WHERE clause doesn't make sense at all. What you could try, is to
locate the error. If you do a backup restore, do you observe the
same behaviour on the restored copy? If not, that indicates that there
is an
Den 2013-01-21 10:03 skrev Svein Erling Tysvær såhär:
Rows that are returned when there's a WHERE clause, but not if there's
no WHERE clause doesn't make sense at all. What you could try, is to
locate the error. If you do a backup restore, do you observe the
same behaviour on the restored
On 1/21/2013 10:36 AM, Kjell Rilbe wrote:
Den 2013-01-21 09:23 skrev Gary Benade såhär:
On 1/20/2013 10:31 PM, Kjell Rilbe wrote:
Den 2013-01-19 08:27 skrev Gary Benade såhär:
On 1/18/2013 2:48 PM, Kjell Rilbe wrote:
Den 2013-01-18 13:30 skrev Gary Benade såhär:
On 1/18/2013 2:02 PM, Kjell
Den 2013-01-21 11:24 skrev Gary Benade såhär:
One last try, what does this give you?
select B.*
from Branschkod B
inner join Branschkod B2 on B2.Namn = B.Namn and B.ECO_ID
B2.ECO_ID
Same 2533 records as usual. :-)
Kjell
--
--
Kjell Rilbe
DataDIA AB
Den 2013-01-19 08:27 skrev Gary Benade såhär:
On 1/18/2013 2:48 PM, Kjell Rilbe wrote:
Den 2013-01-18 13:30 skrev Gary Benade såhär:
On 1/18/2013 2:02 PM, Kjell Rilbe wrote:
Den 2013-01-18 12:56 skrev Kjell Rilbe såhär:
Hi,
This SQL returns 2533 records, none of which contain B.Kod
Hi,
This SQL returns 2533 records, none of which contain B.Kod starting
with 1711 or 2111 (checked thoroughly):
select B.*
from Branschkod B
inner join Branschkod B2 on B2.Namn = B.Namn
where B.ECO_ID B2.ECO_ID
Now, I add a line to the WHERE:
select B.*
from Branschkod B
inner join Branschkod
Den 2013-01-18 12:56 skrev Kjell Rilbe såhär:
Hi,
This SQL returns 2533 records, none of which contain B.Kod starting
with 1711 or 2111 (checked thoroughly):
select B.*
from Branschkod B
inner join Branschkod B2 on B2.Namn = B.Namn
where B.ECO_ID B2.ECO_ID
Now, I add a line to the
On 1/18/2013 2:02 PM, Kjell Rilbe wrote:
Den 2013-01-18 12:56 skrev Kjell Rilbe såhär:
Hi,
This SQL returns 2533 records, none of which contain B.Kod starting
with 1711 or 2111 (checked thoroughly):
select B.*
from Branschkod B
inner join Branschkod B2 on B2.Namn = B.Namn
where B.ECO_ID
Hi,
This SQL returns 2533 records, none of which contain B.Kod starting
with 1711 or 2111 (checked thoroughly):
select B.*
from Branschkod B
inner join Branschkod B2 on B2.Namn = B.Namn
where B.ECO_ID B2.ECO_ID
Now, I add a line to the WHERE:
select B.*
from Branschkod B
inner join
Den 2013-01-18 13:30 skrev Gary Benade såhär:
On 1/18/2013 2:02 PM, Kjell Rilbe wrote:
Den 2013-01-18 12:56 skrev Kjell Rilbe såhär:
Hi,
This SQL returns 2533 records, none of which contain B.Kod starting
with 1711 or 2111 (checked thoroughly):
select B.*
from Branschkod B
inner join
Den 2013-01-18 13:31 skrev Svein Erling Tysvær såhär:
Hi,
This SQL returns 2533 records, none of which contain B.Kod starting
with 1711 or 2111 (checked thoroughly):
select B.*
from Branschkod B
inner join Branschkod B2 on B2.Namn = B.Namn
where B.ECO_ID B2.ECO_ID
Now, I add
On 1/18/2013 2:48 PM, Kjell Rilbe wrote:
Den 2013-01-18 13:30 skrev Gary Benade såhär:
On 1/18/2013 2:02 PM, Kjell Rilbe wrote:
Den 2013-01-18 12:56 skrev Kjell Rilbe såhär:
Hi,
This SQL returns 2533 records, none of which contain B.Kod starting
with 1711 or 2111 (checked thoroughly):
plainly said, an impossible thing is happening with a few simple stored
procedures in FB 2.1 .
I asked for paid help at
http://www.vworker.com/RentACoder/misc/BidRequests/ShowBidRequest.asp?lngBidRequestId=1824928
If you want to help for free, you can download db and explanations from this
I have a table with a timestamp column in Firebird 2.5. The format for
timestamps in Firebird is dd-MM- hh:mm:ss:f (microseconds).
However, when the .net data provider is returning the column data, it doesn't
send the microseconds.
example:
using(FbDataReader reader =
On Thu, 08 Dec 2011 13:53:43 -, firebirdsql firebird...@yahoo.com
wrote:
I have a table with a timestamp column in Firebird 2.5. The format for
timestamps in Firebird is dd-MM- hh:mm:ss:f (microseconds).
However, when the .net data provider is returning the column data, it
41 matches
Mail list logo