[firebird-support] It a CTE possible here?

Hello, the following stored Procedure calls a second one and I get for each product some parts where included. Now, I group this at all, but some products uses the same parts and I would group it in this function, without calling with another one which groups it. It is possible? create or

AW: [firebird-support] SQL Error 303

The name of the function is isc_expand_dpb Von: firebird-support@yahoogroups.com Gesendet: Mittwoch, 27. Mai 2020 12:39 An: firebird-support@yahoogroups.com Betreff: AW: [firebird-support] SQL Error 303 Sorry, one thing. The firebird.dll from version 2 is working, the from fb3 not.

AW: [firebird-support] SQL Error 303

Sorry, one thing. The firebird.dll from version 2 is working, the from fb3 not. Can anyone tell me what is different in this case from 2 to 3? Von: firebird-support@yahoogroups.com Gesendet: Mittwoch, 27. Mai 2020 11:56 An: firebird-support@yahoogroups.com Betreff: [firebird-support] SQL

[firebird-support] SQL Error 303

Hello, we have some problems since migration VC++ 2005 to VC++ 2016. The same code, the same fbclient.dll but now we get the error after connect: Dynamic SQL Error SQL error code = -303 Implementation of text subtype 205 not located. What could it be? The charset is ISO8859_1,

AW: [firebird-support] Re: Round the Time

Thank you -Ursprüngliche Nachricht- Von: firebird-support@yahoogroups.com Gesendet: Donnerstag, 5. Dezember 2019 18:34 An: firebird-support@yahoogroups.com Betreff: [firebird-support] Re: Round the Time 'Check_Mail' check_m...@satron.de [firebird-support] a écrit : > Date

[firebird-support] Round the Time

Hello, is there a simply function available to round the time to entire minutes? 18:15:45 can be 18:15:00 to calculate full minutes between begin and end. Dateadd is an option or extract the complete time in hours and minutes, but can I do this more simple? Thank you. Regards

AW: AW: [firebird-support] CTE difficult question

Hello Karol, thank you, that was the one piece I was looking for, the right position for the listing. Best thanks. Regards. Olaf Von: firebird-support@yahoogroups.com Gesendet: Mittwoch, 13. November 2019 09:51 An: firebird-support@yahoogroups.com Betreff: Re: AW:

AW: [firebird-support] CTE difficult question

Sorry, I don't want to annoy, but can I do this with a separate list-function or is it possible to realize it with new functions in firebird 4? TA TB A B B is a part from A A C C is a part from A A D D is a part from A D X X is a part

AW: [firebird-support] CTE difficult question

Ist it possible somehow? I would get each Part and the complete Path for it. If the Part is a material, I would get it and the complete list with all parts from the first til the material itself. Thanks. Hello, I have the following situation: There are some parts

[firebird-support] CTE difficult question

Hello, I have the following situation: There are some parts with parts inside Part A has Part B inside Part A has Part C inside Part B has BA inside Part B has BB inside Part BA has BAA inside Part BA has also BAB inside Part BB has BBA inside Part C has CA inside A

[firebird-support] Linked Table and double precision

Hello, I use Microsoft Access as frontend, firebird 3 superserver as backand. Now, there a many linked tables in access over firebird odbc, some of the colums are in double precision format. Now, I don't know why, in a Report I calculate the VAT, in my case: 279.578,50 * 0,19 If I

AW: [firebird-support] 32 Bit and 64 Bit

' check_m...@satron.de [firebird-support] wrote: > Can I use the 64 Bit Client-Installation of Firebird for the clients > or should I take the 32-Bit firebird installer to install the minimum client installation? Applications cannot use libraries of different bitness. If you use 3

[firebird-support] 32 Bit and 64 Bit

Hello, I would like to install a 64 Bit Server OS with 64 Bit Firebird Superserver. We are using 32 Bit Office Access with 32 Bit Firebird ODBC. Can I use the 64 Bit Client-Installation of Firebird for the clients or should I take the 32-Bit firebird installer to install the minimum

AW: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage

] CpuAffinityMask on firebird 3.X and firebird memory leakage 03.09.2019 13:12, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > How can I understand this gap? The biggest probability is a memory leak in your UDFs. -- WBR,

AW: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage

@yahoogroups.com Gesendet: Dienstag, 3. September 2019 12:28 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage 03.09.2019 12:10, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > if we use the default firebird.c

[firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage

Hello, if we use the default firebird.conf with #CpuAffinityMask = 0, does firebird use all cpus/cores? Or should I set it to 15 for 4 cores? I have found some information for the 2.5 only. We have some memory-problems on firebird 3.0.1 32 Bit Superserver on server 2008 32 Bit, the one

AW: AW: [firebird-support] Converting with parameters stored in variables?

Helle Karol, thank you, now it works and it is more easier. I have modified this: SELECT lpad(cast(TRUNC(x.a) as integer), :i_anz, '0') || '.' || lpad((X.A-TRUNC(X.A))*X.B, 3, '0') FROM (SELECT cast(:z_str as double precision) AS A, POWER(10,:i_anz2) AS B FROM RDB$DATABASE) X

AW: [firebird-support] Array datatype?

Oh, Alan, I’m using the extract-function. What do you use? select extract(weekday from current_date) from rdb$database – result is 5. Von: firebird-support@yahoogroups.com Gesendet: Freitag, 30. August 2019 09:01 An: firebird-support@yahoogroups.com Betreff: RE: [firebird-support]

AW: AW: [firebird-support] Converting with parameters stored in variables?

Hallo Karol, we have a rfc interface with a high bay storage an the telegram defines the different datatypes. If I would create a new material, I must set different parameters #name#weight…#111.111# and so on. Trunc instead of pow? Regards Olaf Von:

AW: [firebird-support] Converting with parameters stored in variables?

Hello Karol, yes, I know padding. In my case I would like to set the numeric parameters with two variables first. * Take the R11.3 into two variables f1 and f2 (f1 = 11, f2 = 3) * Set the numeric(:f1,:f2) without execute statements Now I have it realized as following:

AW: [firebird-support] Array datatype?

Hello Alan, Im using now the extract function an there is 0 = Sunday, 1 = Monday I think. Von: firebird-support@yahoogroups.com Gesendet: Donnerstag, 29. August 2019 09:23 An: firebird-support@yahoogroups.com Betreff: RE: [firebird-support] Array datatype? Hello Kjell,

AW: [firebird-support] Re: Array datatype?

Hello Vlad, thank you, I will revise my concept. Von: firebird-support@yahoogroups.com Gesendet: Donnerstag, 29. August 2019 09:26 An: firebird-support@yahoogroups.com Betreff: [firebird-support] Re: Array datatype? Use CASE: azeit = azeit + CASE EXTRACT(WEEKDAY

[firebird-support] Converting with parameters stored in variables?

Hello, I get from a application the following 100 R10.3 Or 22.22 R10.3 Now I should take it into: 000100.000 And 22.220 I think, I cannot simply (cast :input as :vartype) (vartype = 'decimal(10.3)' Also it will fortunately not work: cast(input as

AW: [firebird-support] Array datatype?

Hello Kjell, then I have to do the mapping between Monday = 1, Tuesday = 2, Sunday = 0. But I can only select the value with an execute statement. I will test it, thank you.  Von: firebird-support@yahoogroups.com Gesendet: Donnerstag, 29. August 2019 07:46 An:

AW: AW: [firebird-support] memory bug?

Hello Mark, actually, we use the superserver with this settings. In the past, we had the classic server, because only it could access to some more cpu cores. I thought, when we go back to the classic server, the problem with the 2gb RAM overflow is historical, because each of the

AW: [firebird-support] Array datatype?

Thank you, Dimitry! -Ursprüngliche Nachricht- Von: firebird-support@yahoogroups.com Gesendet: Mittwoch, 28. August 2019 17:31 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] Array datatype? 28.08.2019 16:18, 'Check_Mail' check_m...@satron.de [firebird-support] wrot

AW: [firebird-support] Array datatype?

...statement does not works, local variables does the statement not found.. create or alter procedure P_ARBZEIT ( BEGINN date, ENDE date, F1 float, F2 float, F3 float, F4 float, F5 float, F6 float, F0 float) returns ( AZEIT float) AS declare

AW: [firebird-support] Array datatype?

Hello Dimitry, is there no way? I know the thing with the execute statement, but it is not the best solution. I would like to add a value, if the weekday is 1 (Monday), then I would like to take the variable t1 and add the value from t1 to the sum.. Von: firebird-support@yahoogroups.com

AW: [firebird-support] Array datatype?

In my case, I would like to do this: create procedure P_ARBZEIT( beginn date, ende date, f1 float, f2 float, f3 float, f4 float, f5 float, f6 float, f0 float) returns ( azeit double precision) as declare variable wt integer; declare variable akttag date; begin azeit = 0;

[firebird-support] Array datatype?

Hello, I have test something like this: Declare vat integer[7] or {7}. How can I define an array datatype and use it in some functions? (vat[1]/vat[countervail]) Thank you.

AW: AW: [firebird-support] memory bug?

Hello Karol, first, thank your for your effort. There are zwo databases running on our system, the second one has no open transactions, another transactions-model and only just one software were connect tot he server. Can the update to the last firebird-version solve this? We had two

AW: [firebird-support] memory bug?

Hello Carol and Mark, in our production environment I cannot simply install every update, it is an 24-hour-running system, I dont like to "touch" i fit is not absolutely necessary. Okay, I will update the server and all clients soon. The defaultdbcachepagesize I have not set in this case,

[firebird-support] memory bug?

Hello, we are using firebird 3.0.1 Superserver 32 Bit on a Windows Server 2008 32 Bit. Currently we have all 60 days the problem, that our Applications works not well, the firebird-process uses almost 2GB of RAM and this is seemingly the limit of an 32 Bit process. In this case, I cannot

AW: [firebird-support] CTE Spaces between every day

Hello Set, okay, I will test and check it, if I can take it for my situation. Serie can be daily, weekly, monthly, half of a year or a quarter of a year, all this with reminder (days before). So it can be the situation, that I have 5 records for one day (daily and montly entries for

AW: [firebird-support] CTE Spaces between every day

record and the new one. I thought, there is a simplier way. Thank you. Von: firebird-support@yahoogroups.com Gesendet: Montag, 12. August 2019 12:17 An: firebird-support@yahoogroups.com; 'Check_Mail' check_m...@satron.de [firebird-support] Betreff: Re: [firebird-support] CTE Spaces between

[firebird-support] CTE Spaces between every day

Hello, I have created a CTE in a stored prodedure which gives me all terms of the next days, for example: 01.10.2019 Meeting with.. 01.10.2019 Exkursion 02.10.2019 Termin 04.10.2019 Termin XX Now I would set between every day a blank record, a kind of space. 01.10.2019

AW: [firebird-support] CTE, tricky request

...perhaps a solution? union all select cast(a.t || b.str as timestamp) as ts, a.bez from tkal_main a, sub_datum(:vorschau) as b where a.serie = 2 create procedure SUB_DATUM ( days integer) returns ( str varchar(8)) as declare variable c_date timestamp; declare variable t_date

[firebird-support] CTE, tricky request

Hello, I would like to generate a list with appointments. In a table tkal_main I set the day (field "t") of the meeting, every month I would like to get an entry. The description of the appointment is "bez". I helps me with a separate table (tmonate, id 1 = January and so on).

AW: [firebird-support] Firebird 64 Bit Superserver

Hallo Karol, This dll contains many functions to calculate some results (working hour etc.) and the week of year. Last I can get with the extract function, but I don’t know if this is also the correct calculation (with ISO..). Is it better to update to 64Bit or to install classic server?

[firebird-support] Firebird 64 Bit Superserver

Hello, we are using the firebird 32 Bit Superserver on Server 2008 32 Bit with approximately 64 Connections. Last week we had the problem, that the one process increases to 2 GB in the RAM and some of the clients (Microsoft Access with Firebird ODBC, both 32 Bit) works not without problems and

AW: [firebird-support] user manager?

groups.com Gesendet: Freitag, 12. April 2019 17:14 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] user manager? 12.04.2019 15:50, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > ..if I use the fbclient.dll, I can connect with every password, why? Because you use

AW: [firebird-support] user manager?

groups.com Gesendet: Freitag, 12. April 2019 17:14 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] user manager? 12.04.2019 15:50, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > ..if I use the fbclient.dll, I can connect with every password, why? Because you use

AW: AW: [firebird-support] user manager?

Thank you, have a nice weekend. Von: firebird-support@yahoogroups.com Gesendet: Freitag, 12. April 2019 15:17 An: firebird-support@yahoogroups.com Betreff: Re: AW: [firebird-support] user manager? On 12-4-2019 07:27, 'Check_Mail' check_m...@satron.de

AW: [firebird-support] user manager?

...if I use the fbclient.dll, I can connect with every password, why? Von: firebird-support@yahoogroups.com Gesendet: Freitag, 12. April 2019 12:06 An: firebird-support@yahoogroups.com Betreff: AW: [firebird-support] user manager? Hello Dimitry, now, I have installed firebird

AW: [firebird-support] user manager?

...if I use the fbclient.dll, I can connect with every password, why? Von: firebird-support@yahoogroups.com Gesendet: Freitag, 12. April 2019 12:06 An: firebird-support@yahoogroups.com Betreff: AW: [firebird-support] user manager? Hello Dimitry, now, I have installed firebird

AW: [firebird-support] user manager?

-Ursprüngliche Nachricht- Von: firebird-support@yahoogroups.com Gesendet: Freitag, 12. April 2019 11:15 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] user manager? 12.04.2019 7:27, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > how can I change both sy

AW: [firebird-support] user manager?

-Ursprüngliche Nachricht- Von: firebird-support@yahoogroups.com Gesendet: Freitag, 12. April 2019 11:15 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] user manager? 12.04.2019 7:27, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > how can I change both sy

AW: [firebird-support] user manager?

Hello Mark, okay, but how can I change both sysdba-passwords? The one from srp and the other from legacy auth? I don’t have change any settings, first, some processes works not normally, after restarting the pc, I could not connect to the server with the new user. Best regards.

[firebird-support] user manager?

Hello, I’ had a difficult problem. A few month before, we are using firebird 2.1. For 6 weeks, I have installed the firebird 3 superserver and add a new user and changed the sysdba-password. All works fine, till yesterday. Some applications could not connect to the firebird database. We

AW: AW: Re[2]: [firebird-support] Link system tables to trigger

Hello Karol, perfekt, thank you!  Von: firebird-support@yahoogroups.com Gesendet: Dienstag, 12. März 2019 14:43 An: firebird-support@yahoogroups.com Betreff: Re: AW: Re[2]: [firebird-support] Link system tables to trigger Hi, you can do this by: Select * from

AW: Re[2]: [firebird-support] Link system tables to trigger

Hello, I thought similar, would call a stored procedure in my application and set the current user. But there was a little bit hope, that I can get it by using monitor tables, the attachment-table includes all informations and perhaps there is a reference to the statements or

AW: [firebird-support] Link system tables to trigger

Hello Set, all users connecting over odbc with the same user, so I cannot separate the user, which changed the record. It is possible to get it over the transactions-table? Von: firebird-support@yahoogroups.com Gesendet: Dienstag, 12. März 2019 09:52 An:

[firebird-support] Link system tables to trigger

Hello, I would like to log some changes in tables, in germany we must save this for dsgvo (customer data). Now, I can do this with trigger, but can I link this changing with the system tables, that I could get the user? The mon$attachment shows me all active attachments with the user and the

[firebird-support] Formatting currency

Hello, how can I format a value to Euro with decimal pointers like 123.456,44 Euro ? If I do this: select cast(1112223.444 as decimal(18,2)) from rdb$database - I get 1.112.223,44, but if I select this and store it in a varchar-variable, I get 1112223.44, with the point, not comma.

AW: [firebird-support] long condition faster?

Thank you, Andreas. -Ursprüngliche Nachricht- Von: firebird-support@yahoogroups.com Gesendet: Donnerstag, 3. Januar 2019 14:42 An: firebird-support@yahoogroups.com Betreff: RE: [firebird-support] long condition faster? Hi Olaf! select bon.* from (select case when t.price > 100 then

[firebird-support] long condition faster?

Hello, if I select a value: ..a.standort, case when(a.fertigstellung <= :fstichtag) then 4 when ((fertigstellung >= :fstichtag or fertigstellung is null) and abnahme <= :fstichtag) then 3 end from . and I would check this in the where-condition, should I write the entire text

AW: [firebird-support] exponential, string to double precision

Hello András, so simple, thank you very much  -Ursprüngliche Nachricht- Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Mittwoch, 28. Februar 2018 07:50 An: firebird-support@yahoogroups.com Betreff: RE: [firebird-support] exponential, string

[firebird-support] exponential, string to double precision

Hello, is there a simple function to convert a string "+0.200E+01" to a number, double precision, in this case to 2.0? Thank you Best regards Olaf

[firebird-support] In() Question

Hello @ll, I have a configuration table with stations, who can be only one order active and stations, where it isn't so. The list contains all stations, who only one order can be active. For example, if there an order in station 2, the user cannot start an order on station 1, 2 and 3. On

AW: [firebird-support] crosstab pivot query

Hello Set, Thank you, exactly, what I’m looking for. Completet and with changed the d1 to tx: with tmpPerson(manr, name) as (select distinct a.manr, b.name from tplanung a left join tsachbearbeiter b on a.manr = b.sbnr where jahr = 2017 and monat = 9 order by b.name), tmpDays(tag,

[firebird-support] crosstab pivot query

Hello, I'm looking for an opportunity to create a crosstab (pivot) query, but I can't get many examples from google. For example: Table A Year, month, day, person, sign 2017 9 1 1A 2017 9 2 1B 2017 9 3 1B 2017 9

AW: [firebird-support] increment

Thanks a lot  Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Donnerstag, 15. Juni 2017 15:42 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] increment It is possible to do this with a complex, but straight UPDATE statement.

[firebird-support] increment

Hello, How can I increment consisting records like this: Year month order pos 2010 2 1null 2010 2 1null 2010 2 1null 2010 3 2 null Pos should be auto increment for all 2010

[firebird-support] increment

Hello, How can I increment consisting records like this: Year  month   order     pos 2010  2 1    null 2010  2 1    null 2010  2 1    null 2010  3 2   null Pos should be auto increment for all 2010 2 records,

[firebird-support] complicated recursion or other option?

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

[firebird-support] complicated recursion or other option?

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

AW: [firebird-support] join question

Helle SET, perfect, many thannks  Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Dienstag, 11. April 2017 13:24 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] join question Sorry, answered slightly to quickly:

[firebird-support] simply CTE

Hello, at the moment I get all material of a product with a recoursion, but in some case, I get it manyfold and not grouped. (it gets all Material of the material in each level) How can I create a CTE (grouped)? create or alter procedure P_GETMATERIALTEST ( TEILENR varchar(16), ANZAHLT

AW: [firebird-support] Sequence

.. and can I order all active records completly? (without a loop) Update table set prio = 1 to n where prio is not null order by prio? Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Freitag, 2. Dezember 2016 10:44 An:

AW: [firebird-support] Sequence

Okay, I would simply change the prio new in steps of 10. Also I can do the following: Priority in steps of 1 ID 10 Prio 1 ID 20 Prio 2 ID 23 Prio 3 ID 11 Prio 4 Now the user can Set the ID 23 to Prio 2, how can I realize this without a loop? Update table set prio =

[firebird-support] Sequence

Hello @ll, in a table there a many records with prioritys 1, 4, .. Now the user can set one record to 5 and after this, I would set all other records before in steps of 10 and after this again: For Example: Before Record 1 prio 3 Record 2 prio 10 Record 3 prio 18 Record 4 prio

[firebird-support] CTE

Hello everybody, actually I have a stored procedure where I get the needet material for each product, some of them I get many times. Now I would like to create A CTE and gets the amount of each material. In my case I call a stored procedure and those calls itself. Here the example: