Great Alan,
I tried this
update mngrnt
set rfrnc=
case
when aqno = '50001' then 155
when aqno = '50002' then 166
when aqno = '50003' then 1331
end
I got SQL error
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 4, char 1.
when.
'when' is identified(in bold
Hello,
With IBExpert Server Properties/Log option is possible to see the number of
connections and the number and name of the database currently open. I installed
a new Linux virtualized server and in the section Database Info of Server
properties/Log don't show this information (I attach the
What is aqno? An integer or character field?
If its an integer try without ' '
Is it in the same table as rfrnc?
Otherwise there is nothing wrong with the code.
Alan
Alan J Davies
Aldis
On 02/07/2012 07:40, mahdoom_a wrote:
Great Alan,
I tried this
update mngrnt
set rfrnc=
case
when
Hello there!
I use FB 2.5. Is there any known problem with having the database file
in an external USB drive conected to the server?
Just in case (don't know if it matters!) I always use superserver mode.
thanks!!
-sergio
[Non-text portions of this message have been removed]
Hello,
currently I have a database with ISO8859_1 as character set. This character set
applies to most fields, but some have a different one, so that a table looks
like this:
CREATE TABLE MY_TABLE
(
...,
DESCRIPTION1 BLOB SUB_TYPE 1
If there's a typo you are just not setting, then you could also try the other
case format:
update mngrnt set rfrnc = case aqno
when '50001' then '155'
when '50002' then '166'
etc
end
I tried this
update mngrnt
set rfrnc=
case
when aqno = '50001' then 155
when aqno =
Hi
I have 2 (and more) tables with identical structure:
Simplified structure and data:
CODE VARCHAR(15)
QUAN INTEGER
Table A
Item1, 50
Item1, 40
Item2, 70
Table B
Item1, 50
Item2, 100
Item2, 30
I need to get the sum(QUAN) for all the rows in all the tables group by CODE
Item1, 140
Item2, 200
I have 2 (and more) tables with identical structure:
Simplified structure and data:
CODE VARCHAR(15)
QUAN INTEGER
Table A
Item1, 50
Item1, 40
Item2, 70
Table B
Item1, 50
Item2, 100
Item2, 30
I need to get the sum(QUAN) for all the rows in all the tables group by CODE
Item1, 140
Item2, 200
Is
Hi mahdoom_a, I've just created this table MNGRNT (like yours)
RFRNC AQNO
50001
50002
50003
I then ran this code:
update mngrnt
set rfrnc=
case
when aqno = 50001 then '155'
when aqno = 50002 then '166'
when aqno = 50003 then '1331'
end
This is the message -
I have a customer database that is returning internal gds software consistency
check (applied differences will not fit in record (177)) whenever I access a
particular table.
I've run gbak with -g switch and it fails on the one particular table
I've run it with and without running gfix -v -full
I have 2 (and more) tables with identical structure:
Simplified structure and data:
CODE VARCHAR(15)
QUAN INTEGER
Table A
Item1, 50
Item1, 40
Item2, 70
Table B
Item1, 50
Item2, 100
Item2, 30
I need to get the sum(QUAN) for all the rows in all the tables group
by CODE
On 2-7-2012 20:07, Cornie van Schoor wrote:
Set thanks for the reply, I just have one problem, the union removes
duplicates. So if both tables have
Item1, 50
the result is
Item1, 50 and not
Item1, 100 as I require.
Use UNION ALL instead of UNION.
Mark
--
Mark Rotteveel
I use FB 2.01 in external USB drive connected to the server for about 3-4
years. No problem at all, I think FB 2.5 won't be a problem too.
Currently, using FB 2.5 on a RAM Disk (in server) for a better speed.
incendio.
--- In firebird-support@yahoogroups.com, Sergio H. Gonzalez
13 matches
Mail list logo