Hello,
I did the following:
select first 1 cast(d_ein || ' ' || z_ein as timestamp) as tmp from
t_zeitschaltuhr order by tmp into :tmp_next_e;
select first 1 cast(d_aus || ' ' || z_aus as timestamp) as tmp from
t_zeitschaltuhr order by tmp into :tmp_next_a;
d_ein is a date, z_ein a
wher tmp cast('now' as timestamp) ?
Am 21.06.2013, 13:45 Uhr, schrieb Olaf Kluge olaf.kl...@satron.de:
Hello,
I did the following:
select first 1 cast(d_ein || ' ' || z_ein as timestamp) as tmp from
t_zeitschaltuhr order by tmp into :tmp_next_e;
select first 1 cast(d_aus || ' ' ||
I did the following:
select first 1 cast(d_ein || ' ' || z_ein as timestamp) as tmp from
t_zeitschaltuhr order by tmp into :tmp_next_e;
select first 1 cast(d_aus || ' ' || z_aus as timestamp) as tmp from
t_zeitschaltuhr order by tmp into :tmp_next_a;
d_ein is a date, z_ein a time, I would
On Fri, 21 Jun 2013 13:45:51 +0200, Olaf Kluge olaf.kl...@satron.de
wrote:
I did the following:
select first 1 cast(d_ein || ' ' || z_ein as timestamp) as tmp from
t_zeitschaltuhr order by tmp into :tmp_next_e;
select first 1 cast(d_aus || ' ' || z_aus as timestamp) as tmp from
Hello.
I could use some help with understanding why my query returns a partial record
set and a conversion error from string 102.
SQL Message: -413
Engine code: 335544334
FlameRobin tells me myRecursive_VW has the following columns:
- ID Bigint
- PAR_ID Bigint
- NAME varchar(255)
I am using
Hello.
One update. I have casted the ID and PAR_ID columns to varchar(5).
FlameRobin tells me myRecursive_VW has the following columns:
- ID varchar(5)
- PAR_ID varchar(5)
- NAME varchar(255)
However when I execute the recursive query below I get the following error.
Not sure what else to
I am using FB 2.5 to query information from three tables, and calculate the
number of days from a previous date held in a column and today. Can you
provide an example?
This code does not work :(
select
w_containers.container_id,
w_shipments.begin_fill_date,
Where do you declare today?
This is an example:
select datediff( day, (select current_date from rdb$database), (select
current_date-10 from rdb$database))
from rdb$database
gives an answer of -10
so if you substitute this code:
datediff(day, (select current_date from rdb$database),
Hi Walter,
C:\Archivos de programa\Firebird\Firebird_2_5\bin\Gbak -c -v -t -rep -p 8192
-user
SYSDBA -password masterkey D:\RestaurarBASES\BDRestaurada\BASE.GBK
127.0.0.1:D:\RestaurarBASES\BDRestaurada\BASE.FDB -FIX_FSS_D ISO8859_1
-FIX_FSS_MISO8859_1
This is the answer why database
I know this question has been asked before but I can't get it to work with the
solutions provided.
here is the scenario.
I have a windows xp box running firebird 2.0
it is called hantscho and its ip is 168.9.100.24
the path the database is located in is:
\\168.9.100.24\c$\Documents and
At 10:35 a.m. 22/06/2013, Craig Cox wrote:
I am using FB 2.5 to query information from three tables, and calculate the
number of days from a previous date held in a column and today. Can you
provide an example?
This code does not work :(
It's always a good idea to state HOW it doesn't work
11 matches
Mail list logo