Hello dmitry,
what function can I take instead of the isc_expand_dpb?
Thank you.
Mit freundlichen Grüßen / with best regards
Olaf Kluge
S A T R O N Sachsen
Steuerungstechnik GmbH
Johann-Gottlob-Pfaff Straße 7
D-09405 Zschopau
Tel: +49 (0) 3725 / 3506-31
Fax: +49 (0) 3725 / 3506
> Hello,
>
> at the moment, I’m in struggle with a CTE:
>
> for with recursive ok as
> (select a.pos, b.kennzeichen, b.price, b.id from t_l_prkom_grp a inner
> join t_l_prkom_grp_pos b on a.id = b.id_kom_grp where a.id_kom =
> :id_kom union all select c.pos, d.kennzeichen, d.price, d.id from
>
I have found, that in this case the first statement before union gets in the
case of three layers the same result than the second statement after this
(check with select 1 and select 2 for the first/second statement). How can I
realize, that this recursion bring me the same records just one time?
Hello,
at the moment, Im in struggle with a CTE:
for with recursive ok as
(select a.pos, b.kennzeichen, b.price, b.id from t_l_prkom_grp a inner join
t_l_prkom_grp_pos b on a.id = b.id_kom_grp where a.id_kom = :id_kom
union all
select c.pos, d.kennzeichen, d.price, d.id from t_l_prkom_grp c
= 8) then
begin
suspend;
teilenr = left(teilenr,char_length(teilenr)-(2*(8-:idid+1)));
end
teilenr = teilenr || k;
tmp_pos1 = idid;
end
*/
End
How can I optimize this?
Thank you.
Mit freundlichen Grüßen / with best regards
Olaf Kluge
S A T R O N Sachsen
Steuerungstechnik GmbH
Johann-Gottlob-P
;
tmp_pos1 = idid;
end
*/
End
How can I optimize this?
Thank you.
Mit freundlichen Grüßen / with best regards
Olaf Kluge
S A T R O N Sachsen
Steuerungstechnik GmbH
Johann-Gottlob-Pfaff Straße 7
D-09405 Zschopau
Tel: +49 (0) 3725 / 3506-31
Fax: +49 (0) 3725 / 3506-12
Mobil: +49 (0
/*
if(tmp_pos1 = 8) then
begin
suspend;
teilenr = left(teilenr,char_length(teilenr)-(2*(8-:idid+1)));
end
teilenr = teilenr || k;
tmp_pos1 = idid;
end
*/
End
How can I optimize this?
Thank you.
Mit freundlichen Grüßen / with best regards
Olaf Kluge
S A T R O N Sachsen
-Without Lamp-40 Watt
Red-Without Lamp-50 Watt
Blue-With Lamp-30 Watt.. and so on
How can I realize with firebird?
Thank you.
Best regards
Olaf
Mit freundlichen Grüßen / with best regards
Olaf Kluge
S A T R O N Sachsen
Steuerungstechnik GmbH
Hello,
in advance, many thanks!
I would like to combine all properties like this:
Property1 Property2 Property3
Property4..
IP54 Yellow With lamp 30W
IP20 Blue Without lamp
Hello,
in advance, many thanks!
I would like to combine all properties like this:
Property1 Property2 Property3
Property4..
IP54 Yellow With lamp 30W
IP20 Blue
Any ideas?
Thank you
Am 12. Dezember 2014 15:15:40 MEZ, schrieb 'checkmail' check_m...@satron.de
[firebird-support] firebird-support@yahoogroups.com:
Hello @ll,
I would like to group my records by day or month. The date is saved as
timestamp. If I do the following,
SELECT
Hello everybody,
we plan a web-Application with a firebird database. Now I have two options
to prepare the data for the web-client (HTML.).
Option A - a view - returns Data from all Users and the client selects
itself
Option B - a stored procedure with input parameters, the client gets
Hello everybody,
we plan a web-Application with a firebird database. Now I have two
options to prepare the data for the web-client (HTML.).
Option A - a view - returns Data from all Users and the client selects
itself
Option B - a stored procedure with input parameters, the client
Hello,
in a view, the following expression is possible :
.(a.eingangsdatum+coalesce(c.zahldauer,0)) as FAE,.
But how can I take the current date in relation? For example:
cast((current_date - (a.eingangsdatum+coalesce(c.zahldauer,0))) as integer)
as FIN
I would like to calculate when the
Hello Markus,
Thank you, exactly what I'm looking for!
Best regards.
Olaf
**
Hello,
in a view, the following expression is possible :
.(a.eingangsdatum+coalesce(c.zahldauer,0)) as FAE,.
But how can I take the current date in relation? For example:
cast((current_date -
Hello @ll,
The connection from IBExpert is set to ISO8859_1, I don't know the
configuration of jaybird (Application is not mine and can only READ this
data). A external company writes us data in our import tables (exactly same
ISO-charset) and a Trigger import this into the main table. But why
The character ² is integrated in ISO8859_1.
http://de.wikipedia.org/wiki/ISO_8859-1
Oh Sorry, I just realized that I set the character set from ibexpert of my
database to iso 8859_2 and there is the character missing. My mistake.
Best regards.
---
Hello @ll,
The connection from
Hello.
In a Table-Field with character set ISO8859_1 there is a record with invalid
content. If I select all records, then I get the following Error Message
with IBExpert:
Cannot transliterate character between character sets.
How can I find simply the wrong record?
Thanks in advance.
Hello Tomasz,
I have created a stroed procedure to find the records. There are some with
the mm² (²) (pow) and I get the error messeage with ibexpert. But I was
wondering, our Java (jaybird) application displays me all records, also the
problematic. The charset is in every case ISO8859_1. What
Hello,
for example there are two variables.
Var1 = 0
Now I would like to negate the Var1 to Var2. If var1 = 0, then should Var2 =
1 and in the other direction.
Ist it possible Var2 = invert(var1)??
Thank you.
Best regards.
Olaf
[Non-text portions of this message
Hello Mark,
great, exactly what I was looking for. Only 1 and 0 is possible.
Thank you.
Olaf
On Thu, 4 Jul 2013 10:34:21 +0200, Olaf Kluge
mailto:olaf.kluge%40satron.de olaf.kl...@satron.de
wrote:
for example there are two variables.
Var1 = 0
Now I would like to negate
Thank you Set :o)
One dataset includes a date + time to switch on and a date + time to switch
off. I would like to get the timestamp next time on and next time off. In
the simplest case both times from one dataset are in the future. Now it can
be, that the next time to switch on listed in
Hello,
thanks @ all.
I just have one question.
One dataset includes a date + time to switch on and a date + time to switch
off. I would like to get the timestamp next time on and next time off. In
the simplest case both times from one dataset are in the future. Now it can
be, that the
Hello Kukiejko.
You mean that you can only update a dataset with time is not null? First,
you should not use a column-name like time. In this case you mean ID 233
is possible and ID 234 not? If you use a trigger, you'll never can update
the time-column because it is never possible if the old
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
Thank you Ann.
On Fri, May 31, 2013 at 2:50 AM, Olaf Kluge olaf.kl...@satron.de
mailto:olaf.kluge%40satron.de wrote:
in a table A there is a primary key, one column named ID. The second table
B
uses a single Field named ID_TableA, it references to the Table A (foreign
key
Hello,
in a table A there is a primary key, one column named ID. The second table B
uses a single Field named ID_TableA, it references to the Table A (foreign
key) and this field is the primary key too. (1 to 1 relation). Now I have
two indexes for one Table-Column. Is this an problem?
Hi Set.
I think the 2nd Way ist the better. In the first, I must integrate each new
table.
The solution with views is great. Hitherto I wanted to implement this on the
table-level for a better clarity.
Thanks for your great thought for thought :o)
Have a nice weekend.
Best
Hello Ann,
On Wed, May 8, 2013 at 10:31 AM, Olaf Kluge
mailto:olaf.kluge%40satron.de olaf.kl...@satron.de wrote:
I would like to assign a element-group to an table. For example group
valve
- table t_valve. Now I can realize this with an statement, but perhaps I
can
assign the table
Hello,
I would like to assign a element-group to an table. For example group valve
- table t_valve. Now I can realize this with an statement, but perhaps I can
assign the table not by its name, rather with its table ID? Maybe I can
select the ID and. select * from TABLEID where xxx?
It is
Hello,
with this code I get an sql error, but it works until today perfect :o(
with wgetnextprio as (select prio, count(*) as kount from tfachzuordnung
where le is null and gesperrt = 0
and elementtyp = 1 and paltyp = :paltyp_anfrage group by prio)
select first 1 prio from
Hello everybody,
I would check a input string and change some character.
For example: a or A = A
Ä = [
Now I have create a table with all possible characters and the exchange
character.
Is there an simpler way than this?
While count strlength
Character = substring(input from
Hello Sean
Thanks a lot!
Unfortunately the gemini interbase odbc driver works not with this union
query. Even not if I create 3 single queries and call this in a union query.
Is there an easy way to put them into a stored procedure without duplicates?
Then I can get the return values by
Hello again,
now I have test it with a pass through query and it works!
Thanks!
Hello Sean
Thanks a lot!
Unfortunately the gemini interbase odbc driver works not with this union
query. Even not if I create 3 single queries and call this in a union query.
Is there an easy way to put
Hi,
..
Hello all,
I had previously posted about ODBC drivers, but I didn't understand how to
solve the problem, so trying it again.
I have Windows 7 64 bit, MS Office 32 bit version installed on 64 bit
machine. I want to data from a database with extension .gdb into to MS
Access.
I am
Hello,
fb 2.1 cs is running
Now I have four tables:
Persons:
ID
Name
EMAIL
ORDER:
ProjectID
PERSON_WHO_GET (references ID from Persons)
STATUS
Projects:
ProjectID
Manager (references ID from Persons)
ProjectSEND:
ProjectID
PERSON_WHO_GET_INFO (references ID from
it on the Firebird webpage
2. use the Odbcad32.exe to make a System-DSN entry for your firebird
database
3. in Access you can then connect to this database
best regards
Gerhard
Am 11.02.2013 12:46, schrieb Olaf Kluge:
Hi,
..
Hello all,
I had previously posted about ODBC drivers, but I
Hi
I am the first and only firbird user with this issue? What can I do?
Thanks.
I think no. ;-)
In example:
http://sourceforge.net/mailarchive/message.php?msg_id=23092682
Gabor
Thank you!
Hello,
Hi,
View the following:
http://paulbeachsblog.blogspot.com.ar/2011/07/firebird-v21-error-value-exce
eds-range.html
http://paulbeachsblog.blogspot.com.ar/2011/07/firebird-v21-error-value-excee
ds-range.html
Regards.
-Christian-
Thank you!
[Non-text portions of this message have
Perhaps I can get a little help in this group, the odbc devel does not
insert my question at the time. I get no response.
Hello,
I use firebird 2.1 32 Bit cs on Server 2008.
On my pc (Win 7 64 Bit) I have installed Access 2010 32 Bit and the Firebird
ODBC Driver 32 Bit. The Firebird
Hello,
I have trouble. If I restore a fb 2.1 database-backup, I get the following
error:
gbak: error: value exceeds the range for valid timestamps
gbak: error: gds_$send failed
fbak: Exiting before completion due to errors
The same Problem I had with a other database.
How can I
Is there anything I can do?
Thanks
Olaf Kluge olaf.kl...@satron.de schrieb:
Hello,
I have trouble. If I restore a fb 2.1 database-backup, I get the
following
error:
gbak: error: value exceeds the range for valid timestamps
gbak: error: gds_$send failed
fbak: Exiting before
In Firebird 2.1 I can restore this backup successfully. What has changed in
2.5 that the timestamp cannot be restored?
Thanks.
Olaf Kluge mailto:olaf.kluge%40satron.de olaf.kl...@satron.de schrieb:
Hello,
I have trouble. If I restore a fb 2.1 database-backup, I get the
following
Hello,
today I have created some records in a table. Everything works fine. Now, I
have open the table again and now I get some error messages while open the
records. Timestamps until 2007xxx works fine, bit values after works not.
The same error I get with gbak.
Now I have deleted the
Hi Sean,
Olaf,
today I have created some records in a table. Everything works fine. Now,
I
have open the table again and now I get some error messages while open
the records. Timestamps until 2007xxx works fine, bit values after works
not.
Have you recently altered the datatype of the
Hello everybody,
today perhaps I have a simple question.
In a table there are the following fields:
Partnumber; quantity; price
ABC; 1; 115€
ABC; 10; 100€
ABC; 20; 80€
Now I would like one sql-query-result, the price for the greatest quantity.
I have the following:
Hello,
thank you! It can be/it is so simple.
Best regards
Olaf
Am 18.10.2012 12:57, schrieb Olaf Kluge:
Sorry,
where teilenr = a.teilenr of course…
Hello everybody,
today perhaps I have a simple question.
In a table there are the following fields:
Partnumber
Hello,
is the following scenario possible (without a statement)?
If inputvariable A is null then
For select b, c, d from table a
Else
For select b, c, d from table b (same fields like table a but different
informations (data))
Begin
End
The Block begin-and have the same code. I
Hello Thomas.
If I create a stored procedure with autonomous transaction, it works fine!
But if I call these stored procedure in a table-trigger, it works not. The
trigger probably uses only one transaction. But the trigger isn't the right
place for the stored procedure-code.
Is there a
I create a stored procedure with autonomous transaction, it works fine!
But if I call these stored procedure in a table-trigger, it works not. The
trigger probably uses only one transaction. But the trigger isn't the
right
place for the stored procedure-code.
Is there a possibility to use the
Hello,
Hello,
I would like to save the old records in a separate table every year.
On the
end of the year I would Copy the empty main-table to an new table
named like Backup and the old year for example. The new backup table
needs no triggers.
How can I realize this?
What's
Hi Thomas,
Hello,
I would like to save the old records in a separate table every year.
On the
end of the year I would Copy the empty main-table to an new table
named like Backup and the old year for example. The new backup table
needs no triggers.
How can I realize this?
What's the
Hello Mark,
If it is just for backup, why not just create a single backup table and
move all records into that table at year end. Then there is no need to
create a table per year (and it is easier to provide a unified view on
’archived' records).
Mark
my apprehension is that the queries
.
Best regards.
Olaf
Mit freundlichen Grüßen / with best regards
Olaf Kluge
S A T R O N Sachsen
Steuerungstechnik GmbH
Johann-Gottlob-Pfaff Straße 7
D-09405 Zschopau
Tel: +49 (0) 3725 / 3506-31
Fax:+49 (0) 3725 / 3506-12
Mobil: +49 (0) 170 / 9292375
E-Mail: blocked
Hello Helen,
Unfortunately, I have no success.
and RDB$FIELD_NAME = ' || '' || fname || '';
string: NAME = COLUMNNAME '
result: Invalid token. Dynamic SQL Error. SQL error code = -104. Unexpected
end of command - line 4, column 22.
and RDB$FIELD_NAME = ' || || fname || ;
Hello,
I have test it now.
stmtxt = 'select 1 from rdb$database where exists(SELECT * FROM
RDB$RELATION_FIELDS
WHERE RDB$RELATION_NAME = T_DT
and RDB$FIELD_NAME = ' || fname || '';
execute statement stmtxt into :idexists;
The stmtxt is '..._Name = '''COLUMNAME and
Hello,
Is there no option to use internal variables (composite) in a statement?
Thank your.
-
Hello,
In a stored procedure there are 6 Input Parameters F1 to F6. This varchar
variables contains table-field-names and I verify this.
Now I thought I can use a statement
Hello Helen,
...
declare variable fname varchar(31);
...
i = 1;
while (i 7) do
begin
fname = 'F' || cast (i as char);
idexists = 0;
stmtxt = 'select 1 from rdb$database where exists(SELECT * FROM
RDB$RELATION_FIELDS
WHERE RDB$RELATION_NAME = T_DT
and RDB$FIELD_NAME = ' || fname;
execute
Hello,
In a stored procedure there are 6 Input Parameters F1 to F6. This varchar
variables contains table-field-names and I verify this.
Now I thought I can use a statement like this:
i = 0;
while (i 7) do
begin
idexists = 0;
stmtxt = 'select 1 from
Hello dear people,
in a Table I'm looking for the right 5 records for each workplace on a
conveyor track (max-id of the records - offset for the workplace) but
ascending sorted.
For example, the max ID is 200 (last record). The Offset is 10. If I select
first 5 skip 10 fields from table
Hello,
I need the last ID from a table. Now I can get this with select max(id) from
table into :maxlnr. I thought, it is a better way to read the last
generator-id with maxlnr = gen_id(gen_t_dt_id,0); This results a not indexed
read of my table.
Now I have read the following in firebird
Hello Martijn
Hello Olaf,
I need the last ID from a table. Now I can get this with select max(id)
from
table into :maxlnr. I thought, it is a better way to read the last
generator-id with maxlnr = gen_id(gen_t_dt_id,0); This results a not
indexed
read of my table.
Now I have read
Hello Mark,
Could you look into the way your mailprogram is quoting lines? It is very
confusing the have my own text not quoted in your emailmessage.
Checkout the manual for ROWS:
http://www.firebirdsql.org/refdocs/langrefupd25-select.html#langrefupd25-select-rows
In other words: ROWS 5 TO 10 if
Hello dear helper,
I should convert an existing mssql stored procedure into firebird. Perhaps
anybody can help me. The database was not created by me.
The structure of the procedure is slightly different. Select. into . from. I
don't understand about the union with identical queries, this
Hi Mark,
thank you. I will try the first solution.
Best regards.
Olaf
Your second solution would amount to you creating a database in a
database. It also means that on every request Firebird will have to
retrieve the string as is, and then split that every time. I assume that
using
Hello,
I have read this in this group, but I max have it misunderstood.
Thanks for your help.
On 11-4-2012 14:48, Olaf Kluge wrote:
Hello again,
we have some workstations. Every ws need to show some fields of an table.
Now I thought, I can configure that with the numbers
Hello set,
Thank you very much! I will test it this week.
Best regards.
Olaf
WITH TMP(FieldName, FieldPos) AS
(SELECT RDB$FIELD_NAME, RDB$FIELD_POSITION+1
FROM RDB$RELATION_FIELDS
WHERE RDB$RELATION_NAME = :MyTableName
ORDER BY RDB$FIELD_POSITION)
SELECT 'SELECT ' ||
Hello,
it is possible to select the column by column-number? For example:
Column1=ID, column2 = name, column3 = address. And now: select column(2),
column(3) from table. Orderby column-number is already possible.
Thank you.
Best regards.
Olaf
[Non-text portions of this
Hello again,
we have some workstations. Every ws need to show some fields of an table.
Now I thought, I can configure that with the numbers of the column. I also
could write down the column-Names in a configuration table, but sql
statements should be slower.
Thanks for helping.
Hello Set,
the picture-path can be the status 1 (inserted), status 5 (storage-time has
expired and picture can be deleted) and status 6 (release to delete). A
NIO-Ray-image will be deleted after 2 month, a IO-ray-image after 72 hours.
If all pictures are deleted, I can delete the entire folder
Hello again,
for all users with the same problem:
I have created an update-trigger:
AS
begin
if(new.status = 5) then
begin
if (not exists (select 1 from t_pictures where status 5 and kd_id =
new.kd_id
and li_id = new.li_id)) then
update t_pictures set status = 6
Hello,
at this time I have create an statement:
select first 1 a.pfad
from t_pictures a where status 6 and
(select count(*) from t_pictures where status 5 and kd_id = a.kd_id and
li_id = a.li_id) = 0
into :pfad;
pfad = path for an file
Now we have thousands of records
in the
set as you have no order by)
Nick Upson
On 21 March 2012 15:07, Olaf Kluge olaf.kl...@satron.de wrote:
**
Hello,
at this time I have create an statement:
select first 1 a.pfad
from t_pictures a where status 6 and
(select count(*) from t_pictures where status 5 and kd_id
Hallo,
we have some problems by inserting data into an table. In our case, the
customer inserts characters in a field varchar(XX) with special character
°. This little ° with character set iso8859_1 and collation de_de by
inserting generates a gds-exception error: 335544321 arithmetic
Hello,
we have some problems by inserting data into an table. In our case, the
customer inserts characters in a field varchar(XX) with special character
°. This little ° with character set iso8859_1 and collation de_de by
inserting generates a gds-exception error: 335544321
Hello everybody,
one of our customer has no confidence in the Copyright Law of the
firebird-database. Is there a certificate for confirmation? We need to confirm
all copyright claims to take over!
Thank your for your help!
Best regards
Olaf
On Wed, 14 Dec 2011 19:32:39 +0100, olaf.kl...@satron.de wrote:
Hello everybody,
one of our customer has no confidence in the Copyright Law of the
firebird-database. Is there a certificate for confirmation? We need to
confirm all copyright claims to take over!
Thank your for your help!
Hello,
one qestion. How can I save pictures into the firebird database? It is
possible to create a windows-file (*.jpg) with a stored procedure into the
filesystem?
Thank you very much.
Best regards.
Olaf
[Non-text portions of this message have been removed]
Thank you.
Afternoon Olaf,
one qestion. How can I save pictures into the firebird database? It is
possible to create a windows-file (*.jpg) with a stored procedure into the
filesystem?
This link might help a little, maybe. http://www.firebirdfaq.org/faq122/
Cheers,
Norm.
--
Norman
Hello,
we are using firebird 2.5 classic server 64 bit on windows server 2008
standard 64 bit.
My first question. Is the last line possible? (iif(select condition =
true,'where field = value','where field = value2)
select first (1) a.fachnr, a.le
from
Hello
Em 13/9/2011 02:19, Olaf Kluge escreveu:
Hi,
I need to check the connectivity to our plc. A little tool is between
database an plc. If the plc is down or the tool, I cannot see the
connectivity.
The visualization is also connected to our database, but not to the plc.
Now
I would
Hello,
I would like to send all 30 seconds an event to the connected client to
confirm the connection. How can I realize that? There are different clients
connected, for each I need this function.
Thank you.
Best regards.
Olaf
[Non-text portions of this message have been
Hi,
I need to check the connectivity to our plc. A little tool is between
database an plc. If the plc is down or the tool, I cannot see the
connectivity.
The visualization is also connected to our database, but not to the plc. Now
I would show the connectivity in the visualization to our
Hello Thomas,
again thanks a lot for your help!
Best regards and a nice weekend.
Olaf
If I select some fields from mytable with ,where field = XX' or ,where
field
XX', the indexed fields were read indexed (displayed from IBExpert). But
If I select some fileds from mytable with
84 matches
Mail list logo