09.10.2019 17:24, Kjell Rilbe kjell.ri...@marknadsinformation.se
[firebird-support] wrote:
> Anyway, would it be possible to write some kind of plugin to FB 3 to
> allow it to select from or insert into either CSV or Excel files or
> both? I would code the actual plugin myself, of course. I'm just
14.10.2019 11:47, ma_go...@yahoo.com [firebird-support] wrote:
> In the subselect p.proj_id should not be accepted - group does not contains
> it, and has no
> aggregate on it. What value the engine choose when it runs, and why?
Current one. The subquery is executed for each record of master
14.10.2019 13:10, ma_go...@yahoo.com [firebird-support] wrote:
> So HAVING condition is evaluated for EACH ROW instead of just on the group?
No. But value of parameter for aggregate function (in your example MAX) is
evaluated
for each row.
--
WBR, SD.
-
22.10.2019 22:17, Daniel Miller dmil...@amfes.com [firebird-support] wrote:
> I'm curious...why not use Sourceforge mailing lists?
mailman has awful search capabilities.
--
WBR, SD.
+
25.10.2019 17:22, emou...@yahoo.fr [firebird-support] wrote:
> The only tool I can use to create a *.fdb, is FlameRobin (an "abandonware");
> Firebird
> being used by the Delphi Lazarus developer community, the fact that it was
> written in
> C\C++ instead of Pascal can, perhaps, partly explain
26.10.2019 22:46, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> Would you simply store it in a field defined with the BLOB type or use the
> ARRAY type if
> one knew the length of the array?
(VAR)BINARY or BLOB depending on length estimation.
--
WBR, SD.
30.10.2019 11:58, 'Check_Mail' check_m...@satron.de [firebird-support] wrote:
> in a Report I calculate the VAT
For VAT rounding you must follow your local tax laws and do not rely on
computer
rounding functions.
--
WBR, SD.
--
31.10.2019 15:15, Daniel Miller dmil...@amfes.com [firebird-support] wrote:
> My question - is this intended behavior?
For "generated *by default*" it is intended behavior. Your trigger obviously
emulated
identity with "generated always" option.
--
WBR, SD.
---
07.11.2019 22:05, mohamed hamza medh...@hotmail.com [firebird-support] wrote:
> How to downgrade from firebird 3 to Firebird 2.5.8
Create a new database from script, pump data.
> I am having problem mapping numeric (x,y) field . even if y>0 the host
> language map it
> to an integer.
08.11.2019 10:35, mohamed hamza medh...@hotmail.com [firebird-support] wrote:
> In FB 2.5 I have it as ftBcd and ftinteger in FB3.
It is a problem in your application and used components.
--
WBR, SD.
12.11.2019 18:38, cte...@gmail.com [firebird-support] wrote:
> I know that VARCHAR consumes less space.
It doesn't. CHAR has no advantages over VARCHAR in most usages. Only very
little cases
need fixed length data (and usually it is binary data).
--
WBR, SD.
---
12.11.2019 23:06, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote:
> As I understand, the FbConnection.CreateDatabase max pageSize for VARCHAR is
> 8191. Does
> the page size change to less than 8191 if the VARCHAR is less?
Database page size has no relation with any data type size
13.11.2019 11:59, kragh.tho...@yahoo.com [firebird-support] wrote:
> Its not that I see high traffic to /tmp as a problem, I was just worried that
> it was
> becoming a bottleneck in our system.
In this case you can use for it tempfs backed up with auto-expanded swap
files.
--
WBR, SD.
13.11.2019 01:14, 'Andrew Zenz' and...@aimsoftware.com.au [firebird-support]
wrote:
> I recently installed Firebird Client (2.5.8) and Firebird ODBC drivers
> (2.0.5) on a
> clients RDS server and was told I had broken a previously installed app that
> appears to
> use FB Embedded.
>
> The er
13.11.2019 12:41, Alexey Kovyazin a...@ib-aid.com [firebird-support] wrote:
> we also started with Page Buffers = 25% RAM and increased it step by step
> (and still
> continue to work with fine tuning).
Isn't it better to use cache hit ratio to make the decision about its growth?
--
WB
13.11.2019 15:07, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote:
> Assume I have two fields => "stFixed CHAR(10)" and "stVar VARCHAR(8191)
> CHARACTER SET
> UTF8" --- what is the optimum pageSize?
As big as possible for your Firebird version.
--
WBR, SD.
--
13.11.2019 15:51, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> However, internally, the CHAR field definition is more efficient as the
> database does not
> have to perform any field size calculations at the moment that data is being
> updated to a
> VARCHAR field.
No such ca
13.11.2019 16:09, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> If a VARCHAR field is defined for 1000 characters and it is stored in the
> table at a 1000
> character length than there is no purpose to an actual VARCHAR field
> definition.
There is. I addition to 1000 characte
13.11.2019 16:45, dco...@sympatico.ca [firebird-support] wrote:
> Whether I used a mapped drive letter, or a UNC path, if I try to restore a
> backup from a
> network drive it fails, with a message like "Cannot open file".
Don't you by chance try it using Services API or "-se" switch of gbak?
13.11.2019 17:37, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> Your statement is suggesting a null length (until the field is updated) with
> two bytes for
> an actual length, which is how VARCHAR fields work in all other databases to
> my
> knowledge. Otherwise, to follow the p
13.11.2019 18:53, dco...@sympatico.ca [firebird-support] wrote:
> We're actually already doing the backups and restores with the Services API.
Usually account used to run Firebird server has no access to network at all.
Thus the
error you see.
--
WBR, SD.
-
13.11.2019 18:42, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> So my understanding of how the VARCHAR field works is correct and what I have
> stated earlier.
Your understanding is wrong and either IB Expert site is wrong as well or
you misread it.
Yest remember: CHAR - for
13.11.2019 21:06, kragh.tho...@yahoo.com [firebird-support] wrote:
> Just to clarify, one could make a RAM drive with tmpfs, eg /ramdrive, and
> then specify
> this path in firebird.config under "TempDirectories"?
Not quite.
> If correctly understood, does this provide any benefits over just
14.11.2019 03:40, Richard Damon rich...@damon-family.org [firebird-support]
wrote:
> By the SQL standard, there are some noticeable effects. CHAR is defined
> as a fixed width, so data is padded with blanks to reach that width, and
> then the blanks are removed on retrieval.
>
> Firebird might no
14.11.2019 12:43, kragh.tho...@yahoo.com [firebird-support] wrote:
> Just to be sure, /tmp should be mounted with tmpfs, like in this archicle?
Yes and add some automatic swap management like here:
https://unix.stackexchange.com/questions/134258/dynamically-growing-swap-file-on-debian
--
14.11.2019 13:41, cte...@gmail.com [firebird-support] wrote:
> Assume I have two fields => "stFixed CHAR(10)" and "stVar VARCHAR(8191)
> CHARACTER SET
> UTF8" --- what is the optimum pageSize?
Optimum page size doesn't depend on data but on application usage.
I can repeat once again: make
14.11.2019 15:06, 'Harald Wolf' firebir...@online.de [firebird-support] wrote:
> i use the ibpp.org c++ lib. How can i get the firebird sql error in my c++
> code?
This is a Firebird support list. Your question belongs to IBPP support.
--
WBR, SD.
-
14.11.2019 17:06, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> What do you mean I am wrong? I have merely re-iterated how all database
> engines I have
> worked operate.
How "all database engines operate" is irrelevant here. You are wrong in your
assumption
how Firebird engi
14.11.2019 17:08, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> The links provided to me had the information on the IB-Experts web site...
I didn't see who provided you any link, but here is right one:
https://firebirdsql.org/en/reference-manuals/
At the bottom of this page y
14.11.2019 18:01, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> However, the PDF language manual I have for version 2.5 does in fact state
> the following...
>
>
> "A fixed-length character data type. When its data is displayed, trailing
> spaces are added
> to the string up to t
14.11.2019 20:29, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:
> Actually Dimitry, Steve was quoting from the Firebird 2.5 Language
> Reference:
> https://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-datatypes.html#fblangref25-dtyp-tbl-dt
14.11.2019 20:29, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:
> And that part of the documentation is unfortunately wrong (although I'm
> not sure why the language reference even cares to describe such an
> implementation detail).
This documentation is actively corrected and i
14.11.2019 23:19, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote:
> The previous comments indicate that Firebird is Litle Endian.
It doesn't matter because Firebird client deliver length of VARCHAR in
native endiannes
and for the rest there are API functions to convert implementati
14.11.2019 23:30, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote:
> What is the max page size for Firebird 3?
16 kilobytes.
> Also, could you clarify a page?
Quoting
https://docs.microsoft.com/en-us/sql/relational-databases/pages-and-extents-architecture-guide?view=sql-server-ver1
14.11.2019 23:47, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> Doesn't the page size definition as per a database depend on one designs
> their database
> tables and how such tables will be used?
Cases when pages of smaller size have a speed advantage are very special and
most
15.11.2019 11:58, jerz...@o2.pl [firebird-support] wrote:
> What is the max record size in FB3 (in bytes)?
> I search for this information without success.
https://firebirdsql.org/en/firebird-technical-specifications/
--
WBR, SD.
---
15.11.2019 12:45, 'Harald Wolf' firebir...@online.de [firebird-support] wrote:
> Any suggestions?
Dig into IBPP sources and find out the reason.
Use debugger.
--
WBR, SD.
+
15.11.2019 12:56, Tommi Prami tommi.pr...@suonentieto.fi [firebird-support]
wrote:
> Does any database/standard have such mechanism in DB-Engine level that
> application could
> get some kind of notifications of updates.
Firebird has events (read Language Reference about POST_EVENT), Oracle
15.11.2019 10:56, fbianch...@yahoo.com [firebird-support] wrote:
> any hint?
https://groups.google.com/forum/#!forumsearch/firebird-net-provider;context-place=overview
--
WBR, SD.
++
15.11.2019 22:09, jerz...@o2.pl [firebird-support] wrote:
> But only for FB 2.5, not for FB3!
> My question was about FB3. Where is info about new versions?
In Release Notes for these versions.
Maximum size of record was not changed.
--
WBR, SD.
16.11.2019 09:33, jerz...@o2.pl [firebird-support] wrote:
> a few larger char fields with multibyte coding and we get an exception.
An entity with several large text attributes is unusual. Can you provide an
example?
--
WBR, SD.
---
17.11.2019 12:22, jerz...@o2.pl [firebird-support] wrote:
> > Because it is hard to do. A lot of internals in Firebird and its clients
> > rely on this maximum size (hint: the number itself fits in a 2-byte
> > unsigned integer). It is not like you just need to update a MAX_ROW_SIZE
> > constan
18.11.2019 19:40, Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support] wrote:
> Do you have an idea of what I have to do ?
Remove Interbase client and use Firebird client to connect to Firebird.
--
WBR, SD.
+++
18.11.2019 20:38, Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support] wrote:
> I havent' Interbase installed on this computer, only Firebird...
Look better. Use Process Explorer to see versions and locations of DLLs
loaded into
your application.
--
WBR, SD.
-
18.11.2019 21:12, fbianch...@yahoo.com [firebird-support] wrote:
> what's this error now?
Now you are trying to open Interbase database using Firebird server. This is
no-go.
--
WBR, SD.
19.11.2019 13:27, kok...@yahoo.com [firebird-support] wrote:
> i tried to downgrade it using this way
It cannot work. The only way to downgrade in your case is creating database
from
scratch and pumping the data.
--
WBR, SD.
--
20.11.2019 09:19, Oliver Garbe oliver.ga...@ttc-informatik.de
[firebird-support] wrote:
> Any idea why this happens?
http://tracker.firebirdsql.org/browse/CORE-6090
https://github.com/FirebirdSQL/firebird/commit/27ae5889208eb93cdf090d79ee02fe22b96e6530
--
WBR, SD.
28.11.2019 17:30, cte...@gmail.com [firebird-support] wrote:
> What do I modify so it finds only "Rich"?
Use SIMILAR TO.
--
WBR, SD.
++
Visit http
01.12.2019 04:56, dmil...@amfes.com [firebird-support] wrote:
> As I said - I can do this via stored procedures - but is there a way to do it
> without?
If you want to insert records to two tables with single query - you cannot.
If you don't want to use a stored procedure then the closest a
02.12.2019 16:35, Kjell Rilbe kjell.ri...@marknadsinformation.se
[firebird-support] wrote:
> Any ideas?
In short: give up. Just give up.
In long: both client side and server side ANSI code pages must support these
letter.
--
WBR, SD.
--
02.12.2019 18:28, 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]
wrote:
> IB DataPump from Clevercomponents has problems with FB 3, but now it
> is open source. It is made in Delphi. If someone interested and with
> some free time can fix the problem and even update the application:
>
02.12.2019 19:19, 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]
wrote:
> If you have a compiled version with the fix, I think a lot of people
> would enjoy if you can share the executable ;-)
I'm sorry, I'm not sure if I'm allowed to share it.
--
WBR, SD.
03.12.2019 00:18, Tony Christiansen t...@adegroup.com.au [firebird-support]
wrote:
> What would cause this and what remedy would be possible.
It looks like your Firebird run out of system resources.
Make sure that:
1) It is 64 bits.
2) Configured as superserver
3) Hardware and OS provide e
03.12.2019 22:28, nvat...@yahoo.com [firebird-support] wrote:
> I see that NoNagle can be Enabled on the server by setting True in the
> Firebird Server Config file.
On contrary, it can be Disabled because by default it is enabled.
> However, I do not see anywhere to adjust TCP No Delay on th
04.12.2019 04:16, Ferry Sumendap ferry_new2...@yahoo.com [firebird-support]
wrote:
> Is there any step installation I missed ?
Installing and running xinetd.
> How execute firebird server to run manually ?
There is no way for Firebird Classic Server 2.5.
--
WBR, SD.
---
04.12.2019 05:22, nvat...@yahoo.com [firebird-support] wrote:
> Am I missing something here or what is slowing down these firebird
> communications???
Firebird uses protocol with full acknowledgment. In combination with badly
designed
application the result is predictable.
--
WBR, SD.
04.12.2019 12:11, kga...@dgcs.pl [firebird-support] wrote:
> Is there any other way to change the database owner in Firebird 3?
Backup-restore.
Could you provide an example of practical purpose for this action?
--
WBR, SD.
--
10.12.2019 08:58, ehmmm.fireb...@seznam.cz [firebird-support] wrote:
> Please, what is the best way?
Try "gbak -se inet://server/serice_mgr security.db d:\backup\security.bak
-user sysdba
-pass masterkey".
--
WBR, SD.
--
10.12.2019 12:30, ehmmm.fireb...@seznam.cz [firebird-support] wrote:
> Not good: :)
In this case nbackup is your only way.
--
WBR, SD.
++
Visit h
10.12.2019 16:40, Norbert Saint Georges n...@tetrasys.eu [firebird-support]
wrote:
> what do you recommend for conversion?
Numeric and FB 4.
--
WBR, SD.
+
10.12.2019 17:26, Steve Naidamast blackfalconsoftw...@outlook.com
[firebird-support] wrote:
> As to what I was trying to respond to, you note in your message below that
> you would
> recommend FB 4.0. However, that is not available yet in any version, other
> than beta, correct?
Yes but any
16.12.2019 22:00, David Wurdeman david.wurde...@mvpmt.com [firebird-support]
wrote:
> We have an application that uses Firebird to open .FDB databases, that are
> stored on a shared directory on a server.
Don't do that. Ever.
> I’m assuming this message is coming from the Firebird server.
18.12.2019 16:30, Steve Naidamast blackfalconsoftw...@outlook.com
[firebird-support] wrote:
> Is there any way to secure the FDB file from unauthorized access (other than
> compression
> and encryption, which I am starting to implement in my project)
No. Firebird is an open source project, t
19.12.2019 15:41, SOFTDZ m_brahi...@yahoo.fr [firebird-support] wrote:
> My application is executed fine but when I try to execute an SP I get
> that message above
> the SP do some works to clean the db at app first installation
> before it worked fine for two years and did not make changes the cod
26.12.2019 11:53, ertan.kucuko...@1nar.com.tr [firebird-support] wrote:
> I need to identify columns in a table created as "computed by"
These columns have DRB$FIELDS.RDB$COMPUTED_BLR not NULL.
--
WBR, SD.
+
26.12.2019 13:11, ertan.kucuko...@1nar.com.tr [firebird-support] wrote:
> left join
Left join here can unnecessary kill performance. There cannot be fields
without
corresponding table.
--
WBR, SD.
26.12.2019 15:12, ertan.kucuko...@1nar.com.tr [firebird-support] wrote:
> I did not
> understand how I should be re-writing my sample SQL.
Just remove "left".
--
WBR, SD.
27.12.2019 20:49, Hugo Eyng hugoe...@msn.com [firebird-support] wrote:
> Any help will be apreciated.
http://www.ibphoenix.com/services/repair
https://ib-aid.com/en/firebird-interbase-recovery-service/
--
WBR, SD.
30.12.2019 17:57, Germán Balbi bal...@yahoo.com [firebird-support] wrote:
> How can I specify the right plan?
Your strange query cannot work at all. Natural scan is unavoidable with it.
--
WBR, SD.
01.01.2020 20:23, Kevin Stanton kevin.stan...@rdb-solutions.com
[firebird-support] wrote:
> I’m hoping someone can help me out here. FB 1.56 (upgrading soon), trying to
> perform a
> remote backup.
https://firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gbak.html
--
04.01.2020 23:04, John M buff...@gmail.com [firebird-support] wrote:
> Will the win 10
> upgrade break during this upgrade? If so, what is the best way to avoid
> this issue?
The best way is not to upgrade old server but to install a brand new one.
This way if
something go wrong you always c
06.01.2020 14:48, Eric Guéguiniat eric.gueguin...@gmail.com [firebird-support]
wrote:
> I can't use Stored procedure to do this, because index are not used with it
Index cannot be used with ES either, so there is no difference and no need
in a view.
--
WBR, SD.
06.01.2020 16:52, Eric Guéguiniat eric.gueguin...@gmail.com [firebird-support]
wrote:
> That why I need to select directly an external table in a view, instead a
> stored procedure
You cannot. Firebird doesn't support that.
--
WBR, SD.
10.01.2020 09:58, Marco Andreolli dra...@gmail.com [firebird-support] wrote:
> What is the best way to recompile a stored procedure that has no dependence
> on any another
> and without making changes?
Issue ALTER PROCEDURE statement in WAIT transaction.
--
WBR, SD.
--
10.01.2020 13:34, Marco Andreolli dra...@gmail.com [firebird-support] wrote:
> I had in mind something with system table but table RDB$PROCEDURES the field
> RDB$PROCEDURE_SOURCE don't contain the entire procedure but only the body
> without the
> parameter.
> I wouldn't make a more complex quer
10.01.2020 14:07, Hugo Eyng hugoe...@msn.com [firebird-support] wrote:
> Restarting FB server worked. Some users in others foruns reported the same
> bug and the
> same "solution", but do you know if this bug is restricted to what FB version
> and if there
> is something we can do to avoid this
10.01.2020 15:20, Marco Andreolli dra...@gmail.com [firebird-support] wrote:
> Yes, I have the source of all the stored procedures. But I wanted to
> understand if it was
> possible recompile without external resources.
No.
> Sometimes I must recompile because other software made a change on
11.01.2020 08:23, Kjell Rilbe kjell.ri...@marknadsinformation.se
[firebird-support] wrote:
> Is it safe to clean out the contents of the C:\ProgramData\firebird
> folder, i.e. wipe it, when the Firebird service (superserver) is not
> running?
Yes. Only temporary files are there.
--
WBR,
21.01.2020 14:18, Scott Morgan bl...@blueyonder.co.uk [firebird-support] wrote:
> But how easy is it to write queries that ask for items
> that are, for example, 24 months old?
It can be easy but slow. It can be fast but complex.
If I were you I would keep in an integer field number of mont
23.01.2020 08:32, Kjell Rilbe kjell.ri...@marknadsinformation.se
[firebird-support] wrote:
> Can anyone explain in which situations this happens, and in particular
> how I can make sure it does NOT happen?
If it is version 3 - do not use embedded mode.
--
WBR, SD.
-
23.01.2020 11:59, Kjell Rilbe kjell.ri...@marknadsinformation.se
[firebird-support] wrote:
> So is it correct that I avoid embedded mode by specifying
> "localhost/3050:AliasName" instead of just "AliasName"?
Yes.
--
WBR, SD.
--
24.01.2020 09:08, Kjell Rilbe kjell.ri...@marknadsinformation.se
[firebird-support] wrote:
> I assume this is caused by forced writes off and the fact that Windows
> may delay some writes for an arbitrary amount of time. In other words, I
> assume that the Firebird engine does in fact not write to
24.01.2020 09:48, Kjell Rilbe kjell.ri...@marknadsinformation.se
[firebird-support] wrote:
>
> If yes, will the changed write mode take effect immediately, or does it
> require a restart of the superserver process, all connections to be
> closed, or what? I.o.w. when does the changed write mode a
24.01.2020 14:29, Matthias Winkler spmm...@gmail.com [firebird-support] wrote:
> I see the very same issue with firebird 3.0.4. Any ideas?
You made nested loop on 18000*18000 records with sorting on each itaretion.
It cannot
be fast.
--
WBR, SD.
-
24.01.2020 14:49, Matthias Winkler spmm...@gmail.com [firebird-support] wrote:
> The result are just 8 entries. Sorting those 3 entries should then take no
> time at all, right?
Wrong. Sorting happens before result set limit apply.
> Any ideas?
Rule number one: never use "not in".
Lea
24.01.2020 15:01, Matthias Winkler spmm...@gmail.com [firebird-support] wrote:
> Is there a way to force limiting the result set before sorting it?
No. It is also meaningless because you in fact will get several
pseudo-random records.
Such result hardly have a practical purpose.
--
WBR,
24.01.2020 15:19, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:
> It sounds to me like this is should be optimized by executing the
> uncorrelated sub-queries only once.
Yes, but Firebird optimizer cannot do it.
--
WBR, SD.
-
25.01.2020 07:59, Matthias Winkler spmm...@gmail.com [firebird-support] wrote:
> The major problem is, that with firebird 2.1.3 the query also completes
> within 3 seconds.
> Something seems to have changed with the optimizer, execution plan or
> whatever (~ sorry I
> dont know the terms here)
>
29.01.2020 12:01, Matthias Winkler spmm...@gmail.com [firebird-support] wrote:
> Any ideas?
You have no read-write right to database file or libengineXX.so is missing.
strace can help you in investigation.
--
WBR, SD.
---
29.01.2020 12:24, Matthias Winkler spmm...@gmail.com [firebird-support] wrote:
> Its firebird 2.1.7
It must be Classic Server, not Super Server.
--
WBR, SD.
++
30.01.2020 12:48, Matthias Winkler spmm...@gmail.com [firebird-support] wrote:
> Do I need to do anything else to improve performance fo the table?
Analyse queries' plan and stats. Simple delete is not a solution.
--
WBR, SD.
---
27.01.2020 19:23, Daniel Wenzel danielwenz...@hotmail.com [firebird-support]
wrote:
> So my question is, there's a way of modifying SQLLEN of Firebird ODBC driver
> to match
> unixODBC configuration?
I would suggest to build it from sources in your environment. It looks like
distributed
bi
31.01.2020 14:06, Daniel Wenzel danielwenz...@hotmail.com [firebird-support]
wrote:
> I downloaded the source code (OdbcJdbc-src-2.0.5.156.tar.gz), from Firebird
> ODBC page
You'd better get it from github:
https://github.com/FirebirdSQL/firebird-odbc-driver
> I run install script
You m
31.01.2020 14:42, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
wrote:
> You must build it first:
>
> cd Builds/Gcc.lin
> make -f makefile.linux
And "make -f makefile.linux install"
04.02.2020 12:36, Matthias Winkler spmm...@gmail.com [firebird-support] wrote:
> The PRIMKEY is ASC and unique.
For this query it must be DESC.
> Is the another way to achieve the same?
What's the purpose of it? Unique id generation used to be handled by
generators.
--
WBR, SD.
---
04.02.2020 12:42, Matthias Winkler spmm...@gmail.com [firebird-support] wrote:
> The last entry is considered the "current" entry and should be updated
> when the programm encounters e.g. a error.
> (Then the field error_count of the "current" entry is then incremented)
That's a bad design. The
04.02.2020 12:47, Matthias Winkler spmm...@gmail.com [firebird-support] wrote:
> But I need to deal with a heap of old code and re-designing
> it, is not a real option :-)
Still you can use "update or insert ... matching gen_id(..., 0)" instead.
--
WBR, SD.
-
Hello, All.
In the description of OO API I failed to find if objects (classes) are
depended or not.
I.e. I would like to know if order of releasing of them matters. Can I
release
IProvider before IAttachment and IAttachment before IStatement or it is
required to
release acquired inte
12.02.2020 18:22, Roberto Vieweg jjw.roberto.fireb...@gmail.com
[firebird-support] wrote:
> How can I set the locale of firebird process in linux?
> I'm using Firebird 2.5 classic.
Use (x)inetd configuration file to set the environment variable.
--
WBR, SD.
13.02.2020 14:42, Roberto Vieweg jjw.roberto.fireb...@gmail.com
[firebird-support] wrote:
> Can you provide an example?
env += LANG=ru_RU.UTF-8
--
WBR, SD.
+
601 - 700 of 736 matches
Mail list logo