Re: [firebird-support] UPDATE OR INSERT in Firebird 3

2020-11-25 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
te a value, but when using an identity column, then you either have to leave out the column so it is generated, or you need to specify a non-null value. Mark -- Mark Rotteveel

Re: [firebird-support] Support native JSON datatype for columns as MySQL / PostgreeSql

2020-10-13 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
the tracker: http://tracker.firebirdsql.org/browse/CORE-5148 But it is not planned for any version so far. Mark -- Mark Rotteveel

Re: [firebird-support] is it a bug?

2020-07-28 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
The firebird-support Yahoo Group has moved to Google Groups at https://groups.google.com/d/forum/firebird-support. Please subscribe and post your question there. Mark On 2020-07-28 15:23, hamacker sirhamac...@gmail.com [firebird-support] wrote: > If I try in FB3 (latest version):CREATE >

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

2020-06-27 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
birdsql.org/file/documentation/reference_manuals/user_manuals/html/qsg3-databases.html#qsg3-databases-creating-nonsysdba -- Mark Rotteveel

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

2020-06-26 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
tation/release_notes/html/en/3_0/rnfb30-access-sql.html#rnfb30-security-metadataprivs PS. Please move this discussion to the new firebird-support list on Googlegroups. -- Mark Rotteveel

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

2020-06-25 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
You have sent your email to the old list, please post to the new list at firebird-supp...@googlegroups.com (or https://groups.google.com/d/forum/firebird-support). If you're not subscribed yet, you can do it on above link, or by sending an email to firebird-support+subscr...@googlegroups.com

Re: [firebird-support] SQL Error 303

2020-05-27 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
The Firebird-support mailing list has moved from Yahoo Groups to Google Groups, https://groups.google.com/d/forum/firebird-support (or subscribe by emailing to firebird-support+subscr...@googlegroups.com and confirm by replying to the confirmation request). Could you please subscribe to the

Re: [firebird-support] Re: IMPORTANT MESSGAGE: This group is moving

2020-05-05 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
ht) > My global settings under "Add/Invite settings" the option "Allow group managers to invite me to their groups" is disabled. Mark -- Mark Rotteveel

Re: [firebird-support] Next attachment ID

2020-05-04 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-05-04 10:34, Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] wrote: > Hi > > How can i read Next Attachement ID? > > I know that i can read it by gstat -h but how to read it from > connection? > > Is there something simple like for OAT – read from MON$DATABASE or >

Re: ODP: [firebird-support] IMPORTANT MESSGAGE: This group is moving

2020-05-03 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
have google accout to login. > > How to change it? You cannot change it if you have subscribed with an email address that is not associated with a Google account. And as far as I'm aware, it will use the display name of your email address when actually posting a message. Mark -- Mark Rotteveel

Re: [firebird-support] IMPORTANT MESSGAGE: This group is moving

2020-05-02 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
ums, find the group, click **Edit** after your name, and change "Email used for membership" to your preferred address. Mark -- Mark Rotteveel

Re: [firebird-support] new Google groups

2020-05-01 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-05-01 02:20, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: > The firebirdsql.org site lists new Google groups to replace the yahoo > firebird-support and firebird-general lists, but the links don't work - > I get permission denied errors trying to visit them. > > Are

Re: [firebird-support] FB1 to FB3

2020-04-30 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-04-30 17:42, Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support] wrote: > I always tend to do back / restores not only in this migration but on > a regular basis. I’m maybe a little on the paranoid side. :) > I have noticed some extra lines in the restore log for FB3 (this

Re: [firebird-support] Re: Technical IT specialist Firebird corruption

2020-04-17 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
; > This page I used  for the restore string > http://www.destructor.de/firebird/gbak.htm. But Like I said Errors where > produced with restoring, like size error Please be explicit with what you tried and the exact errors you get. Mark -- Mark Rotteveel

Re: [firebird-support] Technical IT specialist Firebird corruption

2020-04-17 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
rd itself that would result in an error like "invalid request - is not defined - module name or entrypoint could not be found" error. Unless of course the application in question is hiding that error and returning unclear errors. Mark -- Mark Rotteveel

Re: [firebird-support] Technical IT specialist Firebird corruption

2020-04-17 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
estore resent backups. which it didn't give any errors. > But it does want to be registered and the Defin support person says it > corrupted!!! Then possibly this might be a problem with the application and not so much with the database. You would need to contact support of your application fo

Re: [firebird-support] List Users after CREATE/DROP USER without commit

2020-04-11 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
eation of the user happens in a different database, and changes in that database aren't visible until the commit happens (at which time the commit in the security database happens as well). Mark -- Mark Rotteveel

Re: [firebird-support] Forgot sysdba password

2020-04-09 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-04-09 18:05, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > On 2020-04-09 09:53, liviuslivius liviusliv...@poczta.onet.pl > [firebird-support] wrote: >> Hi >> >> Simply replace security3.fdb by ine from the zip install and >> initialize sy

Re: [firebird-support] Forgot sysdba password

2020-04-09 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-04-09 09:53, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > Hi > > Simply replace security3.fdb by ine from the zip install and > initialize sysdba Doing that will lose all other users in the security database, so that is not a good idea. Instead, stop Firebird

Re: [firebird-support] error during the registratione of data on 2.5 FB database

2020-04-04 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
ISQL to reproduce the problem. Very likely while doing that, you will already find the problem yourself. Mark -- Mark Rotteveel

Re: [firebird-support] error during the registratione of data on 2.5 FB database

2020-04-04 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
ght mean that the error is not on the line that you think it is. Try executing a single statement instead of a script. I'd recommend trying to reproduce it in ISQL, and if possible provide us with a minimum reproducible example Mark -- Mark Rotteveel

Re: [firebird-support] Firebird vs Intebase

2020-03-26 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
o archives. Which archives? Mark -- Mark Rotteveel

Re: [firebird-support] Firebird 4.0.0-1436 beta 1

2020-03-25 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-03-25 13:24, Gregor Kobler gregorkob...@yahoo.com [firebird-support] wrote: > Hello Mark > > Yes I am aware of that, but I have no experience with the snapshots. > How do I make the current snapshot work. I run the file > "Install_service.bat". The Firebird service is running, but when I

Re: [firebird-support] Firebird 4.0.0-1436 beta 1

2020-03-25 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-03-24 10:47, Gregor Kobler gregorkob...@yahoo.com [firebird-support] wrote: > Hello > > I try a little bit with the FB4 beta 1 > > two errors i got > 1. When i try to connect with my 64Bit program and using the > fbclient.dll (64Bit) my program crashes! when i use the 64bit dll from >

Re: [firebird-support] Firebird and Sam Broadcaster

2020-03-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
r message as text, or link to the image hosted elsewhere. Mark -- Mark Rotteveel

Re: [firebird-support] problemtic User management on firebird 3

2020-03-15 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
Firebird login. > SQL> > > I give up. any idea what I'm doing wrong here? for now I'm going to use > one of the free gui admin tools in embedded mode but if the user > management and stored proc thingy doesn't get better any time soon I'll > drop firebird altogether. > > thank you for your time. Your efforts are greatly appreciated regardless > of outcome. -- Mark Rotteveel

Re: [firebird-support] Ubuntu 3.0.5 version

2020-03-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
ds and a lot of changes and fixes. Also, build 33100 is from February 2, 2019[1], not from October 2019, so it is a lot older than you think. Mark [1]: https://github.com/FirebirdSQL/firebird/commit/51e28472f78e109fc1475799a3c12f5d2f900f69 -- Mark Rotteveel

Re: [firebird-support] mapping destroyed by backup / restore

2020-03-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
; gbak:    0.237  0.002  0 10 fixing views dbkey length > > gbak:    0.238  0.001  0  0 updating ownership of packages, > procedures and tables > > gbak:    0.240  0.001  0  0 adding missing privileges > > gbak:    0.242  0.001  0  0 adjusting system generators > > gbak:    0.247  0.005  0  3 finishing, closing, and going home > > gbak:    0.249  0.001  0    724 total statistics > > gbak:adjusting the ONLINE and FORCED WRITES flags > > _8. Confirm mapping not present in restored database___ > > PS C:\Users\PGMRSD1> c:\apps\firebird\isql.exe > C:\temp\mapping-backup-restore\BAZ.FDB > > Database: C:\temp\mapping-backup-restore\BAZ.FDB, User: PGMRSD1 > > SQL> show users; > > Users in the database > >   1 #PGMRSD1 > > SQL> show roles; > >    FOO > > SQL> show mapping; > > *** Global mapping *** > > TRUSTED_AUTH USING PLUGIN WIN_SSPI FROM ANY USER TO USER > > SQL> exit; -- Mark Rotteveel

Re: [firebird-support] Re: Cannot delete Firebird database file as it is in use by the application..

2020-03-11 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-03-10 22:04, Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support] wrote: > Hello... > > I am developing a security extension, which is used as a loaded > assembly to my main application, all of which use the Firebird > Embedded Edition 2.59 for my application's database. >

Re: [firebird-support] Firebird client connection timeout

2020-03-11 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-03-10 20:14, Andrei Luís compuvale.softw...@gmail.com [firebird-support] wrote: > Hummm, I think Dimitry is right. I made some tests here on client > side: > > server IP: 10.0.2.2 > path: d:\database.fdb > > Using connection string: 10.0.2.2:d:\database.fdb Correct IP and > correct

Re: [firebird-support] Firebird client connection timeout

2020-03-10 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 10-03-2020 17:44, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 10.03.2020 15:57, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] > wrote: >> On 10-03-2020 15:46, Andrei Luís compuvale.softw...@gmail.com >> [firebird-support] wrote: >> >

Re: [firebird-support] Firebird client connection timeout

2020-03-10 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
etting is not prefixed with a #, which would make it a comment. And a final check question: is your application actually using fbclient.dll (and not for example Jaybird or the Firebird ADO.net provider, or some other connection library that doesn't use fbclient.dll). Mark -- Mark Rotteveel

Re: [firebird-support] Firebird client connection timeout

2020-03-10 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 10-03-2020 15:40, Andrei Luís compuvale.softw...@gmail.com [firebird-support] wrote: > Just did that. Still the same. Check if your client application has its own fbclient.dll, and put a firebird.conf in the same directory as that fbclient.dll. Mark -- Mark Rotteveel

Re: [firebird-support] Firebird client connection timeout

2020-03-10 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
client.dll in your Firebird install, but instead will use the fbclient.dll in C:\Windows\System32, and so the firebird.conf file needs to be in that location. Mark -- Mark Rotteveel

Re: [firebird-support] Firebird client connection timeout

2020-03-10 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
timeout is working fine. But > inside the virtual machine, the timeout is not working as I set. It is > taking about 45 secs to timeout. > > Is there something I'm doing wrong? Thanks for your time. Where is your libfbclient.so (or fbclient.dll), and where is the firebird.conf file? Mark -- Mark Rotteveel

Re: [firebird-support] Firebird client connection timeout

2020-03-10 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
wever, for those settings to apply to the client, they must be in a firebird.conf that is actually read by the client, which usually is not the firebird.conf of the server. Mark -- Mark Rotteveel

Re: [firebird-support] RE: How can I use/map Active Directory Groups within my Firebird in Trusted Authentication mode?

2020-03-06 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-03-06 04:46, FSPAPA INCA Team i...@foodstuffs-si.co.nz [firebird-support] wrote: > Aha, you've got a typo! > > In your create mapping statement (and verified by the output of show > mapping), you have "WINSSPI" instead of "WIN_SSPI". > I encountered the same issue when I accidentally

Re: [firebird-support] AW: How can I use/map Active Directory Groups within my Firebird in Trusted Authentication mode?

2020-03-05 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-03-05 13:38, 'Mathias Pannier (unitel)' pann...@ubsysteme.de [firebird-support] wrote: > I can’t get it to work… > > The user “MYDOMAIN\ADMINISTRATOR” is a member of the AD group > “MYDOMAIN\MY_GROUP” > > ROLE_TEST was created using this statement: CREATE ROLE ROLE_TEST; > > The

Re: [firebird-support] How to "remap" the count datatype from BIGINT to INTEGER in firebird 3

2020-03-03 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
e headers, it was sent only once to Yahoo, but servers inside Yahoo are repeatedly sending that email. Mark -- Mark Rotteveel

Re: [firebird-support] Can we please be able to install *_without_* being the root or firebird user?

2020-03-02 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
ird would probably be more on-topic on the firebird-devel mailing list than on firebird-support. However, have you considered using docker to run Firebird (eg using https://hub.docker.com/r/jacobalberty/firebird) instead of trying to compile/install from sources yourself? Mark -- Mark Rotteveel

Re: AW: [firebird-support] Scalability of connection numbers of client-server solution with Firebird 3.0?

2020-03-02 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
and 2.5.3 it was raised to 2048 connections, see http://tracker.firebirdsql.org/browse/CORE-4439. Mark -- Mark Rotteveel

Re: [firebird-support] RE: How can I use/map Active Directory Groups within my Firebird in Trusted Authentication mode?

2020-03-02 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
without the domain > prefix, but no luck. > > Any clues… is this sort of mapping supported? According to the documentation in doc\sql.extensions\README.mapping.html it should be supported. However, I have never used it, and I don't have a domain to experiment on. Maybe Alex Peshkoff knows more, an

Re: [firebird-support] How to "remap" the count datatype from BIGINT to INTEGER in firebird 3

2020-03-02 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
n written in Delphi 7, with a lot > of TSQLQuery with hardcoded count queries mapped to TIntegerField. So > is impossible to do a migration right now. I need other options You could use casts, though I'm surprised that there is no automatic coercion within Delphi. Mark -- Mark Rotteveel

Re: [firebird-support] How to "remap" the count datatype from BIGINT to INTEGER in firebird 3

2020-03-01 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
in Firebird 3, because it is new in Firebird 4. Mark -- Mark Rotteveel

Re: [firebird-support] double precision remove last 2 numbers

2020-02-27 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-02-26 19:41, hamacker sirhamac...@gmail.com [firebird-support] wrote: > When I started my test, I turn off my app. > > And do update(and select) using only ISQL tool (IBExpert) and > dbweaver. > in both I had to configure select to show float using mask > (0.##..), so the number can

Re: [firebird-support] double precision remove last 2 numbers

2020-02-26 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-02-26 19:07, hamacker sirhamac...@gmail.com [firebird-support] wrote: > Hi All, > > I do this update: > UPDATE CV SET > perc_lucro=42.503064336972848 > WHERE (id_cv=57528) > > Then I do a select and 'perc_lucro' was change to 42,5030643369728 > after updated, two last numbers

Re: [firebird-support] (When to) recalculate statistics ?

2020-02-26 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-02-26 06:22, Matthias Winkler spmm...@gmail.com [firebird-support] wrote: > Hello Firebird-Group, > > With our device we recalculate statistics ALWAYS when booting up the > system. Now the DB grows bigger this can now take more than 10 minutes > and delays > the time until we can really

Re: [firebird-support] How to set the locale of firebird process in linux

2020-02-13 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
subscr...@yahoogroups.com See the footer of the emails from this list for more information. Mark -- Mark Rotteveel

Re: [firebird-support] ODBC driver with SQLLEN equal to 8

2020-01-30 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-01-30 16:02, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 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? > >

Re: [firebird-support] Statement freezes firebird

2020-01-24 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-01-24 14:39, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 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

Re: [firebird-support] Statement freezes firebird

2020-01-24 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-01-24 13:29, Matthias Winkler spmm...@gmail.com [firebird-support] wrote: > Hello, > > With Firebird 2.1.7 this statement freezes my firebird server > completely. Firebird will > take 100% CPU. > >> select first(8) ID from TBL_TEST >> where ID not in (select first(2) ID from TBL_TEST

Re: [firebird-support] coding for services: invalid clumplet error

2020-01-13 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-01-14 00:40, 'Andrew Zenz' and...@aimsoftware.com.au [firebird-support] wrote: > I have tried various iterations of it, as a BYTE and as Pablo Sanchez > suggests in a later response, a CSTRING, eg: > > spb_buffer BYTE,DIM(128) > > or > > spb_buffer CSTRING(128) > > As

Re: [firebird-support] Is it safe to risk multiple Firebird nbackup -L?

2020-01-13 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
TER DATABASE END BACKUP[1], which will also work with SuperServer mode (as the nbackup tool needs direct file access, while SuperServer uses an exclusive lock on the file). [1]: https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl-db.html#fblangref25-ddl-db-alter -- Mark Rotteveel

Re: [firebird-support] Database server Clock Incorrect

2020-01-10 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-01-09 23:42, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Hello. > > Win10 64 and Win7 32 > > FB 2.5 32bits > > When I execute "select current_time from RDB$Database" FB returns 1 > (one) hour more then the current time. > > Did somebody faced this troble? Sounds like the

Re: [firebird-support] SEC$DESCRIPTION, how to change it?

2020-01-07 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-01-07 19:49, hamacker sirhamac...@gmail.com [firebird-support] wrote: > There is a SEC$DESCRIPTION field on security users table, but > CREATE/ALTER USER command does not any parameter to change it, is it > correct? Since Firebird 3, you can use: COMMENT ON USER IS '' This

Re: [firebird-support] Need help upgrading win 7 to win 10

2020-01-06 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
se version will not provide sufficient information. However for sake of completeness, you can check the ODS version using: gstat -h ODS 11.2 means it is a Firebird 2.5 database. Mark -- Mark Rotteveel

Re: [firebird-support] Need help upgrading win 7 to win 10

2020-01-05 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
rebird 3 as well (though going from 2.5 to 3 needs to be planned and tested more thoroughly than upgrading within 2.5.x). And as always, check the release notes for all changes and fixes between 2.5.2 and 2.5.9: https://www.firebirdsql.org/file/documentation/release_notes/html/en/2_5/rlsnotes25.html Mark -- Mark Rotteveel

Re: [firebird-support] Remote backup using gbak

2020-01-03 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
esn't have streaming backup through the service manager, so you can't make a local backup directly to the client. Mark -- Mark Rotteveel

Re: [firebird-support] Firebird client connection timeout

2020-01-01 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
, but as far as I know that only governs the attach handshake, as it is only applied after establishing the socket connection, which makes it unsuitable. Mark -- Mark Rotteveel

Re: [firebird-support] Database/Table Corruption

2020-01-01 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 31/12/2019 18:27, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Gfix didn´t work even using it as you  explained. Please be more specific than "didn't work". What happened, did you get an error, did gfix find nothing wrong? What was the gfix output? Mark -- Mark Rotteveel

Re: [firebird-support] Plan problem en CTE

2019-12-31 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-12-30 17:57, Germán Balbi bal...@yahoo.com [firebird-support] wrote: > Hi. > I have this problem in FB 2.5 > > with x as ( > SELECT * > FROM tbl_x1 > JOIN tbl_fk1 ON cond_1 > WHERE cond_w1 > UNION > SELECT * > FROM tbl_x1 > JOIN tbl_fk1 ON cond_2 > WHERE cond_w2 > ) > >

Re: [firebird-support] Database/Table Corruption

2019-12-27 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
use gfix -mend as a last resort (and make a copy of the database before running it!). [1]: https://firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-dbverify.html -- Mark Rotteveel

Re: [firebird-support] Re: Securing Firebird Embedded database

2019-12-21 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
ntion during my application's installation? See https://github.com/FirebirdSQL/firebird/blob/B3_0_Release/builds/install/arch-specific/win32/installation_scripted.txt Mark -- Mark Rotteveel

Re: [firebird-support] Re: Securing Firebird Embedded database

2019-12-19 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-12-18 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) and if not, is there expected to be at

Re: [firebird-support] unsubcribe

2019-12-19 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
To unsubscribe, send an email to firebird-support-unsubscr...@yahoogroups.com Mark On 2019-12-18 16:34, David Wurdeman david.wurde...@mvpmt.com [firebird-support] wrote: > Please unsubscribe me from this group > > David A. Wurdeman > > Predictive Maintenance Technologies > > 914 East 17th

Re: [firebird-support] When opening an .FDB file, Firebird says the database is already open by the same computer

2019-12-18 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-12-17 15:36, David Wurdeman david.wurde...@mvpmt.com [firebird-support] wrote: > Thank you for the reply > > We use an application called Ascent, which is used to analyze > vibration data from industrial machines. It stores its data in .fdb > files. These files can either be on the

Re: [firebird-support] When opening an .FDB file, Firebird says the database is already open by the same computer

2019-12-17 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-12-16 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. Database should be 'shared' through a Firebird server instance. Users connect to the

Re: [firebird-support] SELECT IN wildcard

2019-12-13 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
d it to the right number of parameters at execution time). If you want to use wildcards, you need to use LIKE (or SIMILAR TO). Using SIMILAR TO you could simulate a list of values by separating them with pipes (|). Mark -- Mark Rotteveel

Re: [firebird-support] How do I limit an SQL search list to 10 records?

2019-12-13 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
and a record written by a long-running transaction might not show up as 'recent' (or at least as older than it may actually be). Mark -- Mark Rotteveel

Re: [firebird-support] How do I limit an SQL search list to 10 records?

2019-12-13 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
* FROM ORDER BY DESC FETCH NEXT 10 ROWS ONLY ) a ORDER BY ASC Or you can use ROW_NUMBER, although that is probably less efficient: SELECT * FROM ( SELECT .*, ROW_NUMBER OVER (ORDER BY DESC) AS ROWNR FROM ) a ORDER BY ASC WHERE ROWNR < 10 Mark -- Mark Rotteveel

Re: [firebird-support] How do I limit an SQL search list to 10 records?

2019-12-13 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-12-13 12:48, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > I added the KeyID so I could sort from newest to oldest. Was it > necessary to add this KeyID, or is there another way to find the > newest records without the KeyID? That depends on what you're trying to achieve,

Re: [firebird-support] How do I limit an SQL search list to 10 records?

2019-12-13 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-12-13 08:14, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > Den 2019-12-12 kl. 22:36, skrev Clyde Eisenbeis cte...@gmail.com > [firebird-support]: >> Marcin, Minor tweak => works!  I also added DESC to retrieve the >> newest records using the field key name

Re: [firebird-support] How do I limit an SQL search list to 10 records?

2019-12-13 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-12-12 19:59, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > This finds all records: > `` > "SELECT * FROM " + stTableName > > `` > > This does not work: > > `` "SELECT

Re: [firebird-support] Firebird 3.0 Column name length

2019-12-09 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
of Length Limit for Local Alias and Variable Names". I guess the problem is that column names internally in Firebird are UNICODE_FSS, and those 31 Cyrillic characters are more than 31 bytes in UNICODE_FSS. Mark [1]: http://tracker.firebirdsql.org/browse/CORE-2350 -- Mark Rotteveel

Re: [firebird-support] Firebird novice--help with application that uses Firebird

2019-12-07 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
specific application. I'd recommend contacting the vendor of your application. Mark -- Mark Rotteveel

Re: [firebird-support] Nagle Algorithm

2019-12-04 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-12-03 23:20, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 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

Re: [firebird-support] What key word specifies a search for an entire word?

2019-11-29 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
think is unlikely for a column which contains first names. Maybe you meant OR instead? Mark -- Mark Rotteveel

Re: [firebird-support] Why I cannot use firebird services to validate a remote database

2019-11-25 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
tracker.firebirdsql.org/browse/JDBC-600) to see if this is something that can be fixed or improved in Jaybird. Mark -- Mark Rotteveel

Re: [firebird-support] Why I cannot use firebird services to validate a remote database

2019-11-25 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
abase. What is the nature of your problem. If your problem is with Jaybird, then please ask on the firebird-java mailing list, and make sure to provide a minimal but reproducible example and errors (if any) or a description of the problem. Mark -- Mark Rotteveel

Re: [firebird-support] Grant execute on function.

2019-11-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
ing for built-in functions as they are handled in a different way than normal functions. Mark -- Mark Rotteveel

Re: [firebird-support] Grant execute on function.

2019-11-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
houldn't need a grant AFAIK, so that could indicate a bug. Mark -- Mark Rotteveel

Re: [firebird-support] Event handling, I think?

2019-11-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-11-22 11:02, Alan J Davies alan.dav...@aldis-systems.co.uk [firebird-support] wrote: > Hi all, is it possible to update a table when the current_date in > rdb$database changes to the next day? > > I need to reset a delivery counter to 0 in all the orders on a system. > I can presently do

Re: [firebird-support] Unable to complete network request to host "127.0.0.1" [SQLState:08006, ISC error code:335544721]

2019-11-21 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-11-21 20:29, Roberto Vieweg jjw.roberto.fireb...@gmail.com [firebird-support] wrote: > Full stack > > java.sql.SQLException: Unable to complete network request to host > "127.0.0.1". [SQLState:08006, ISC error code:335544721] > at >

Re: [firebird-support] ISC ERROR CODE:335544721

2019-11-19 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-11-18 21:32, mlcvi...@yahoo.fr [firebird-support] wrote: > Hello, > > I have Firebird 2.58 32 bit version in the C:\Program Files > (x86)\Firebird\Firebird_2_5 We're not talking about your Firebird server install, we're talking about client libraries fbclient.dll or gds32.dll, and

Re: [firebird-support] What is the optimum pageSize?

2019-11-18 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-11-17 12:22, jerz...@o2.pl [firebird-support] wrote: > On Sat, 16 Nov 2019 10:29:44 +0100, Mark Rotteveel > m...@lawinegevaar.nl [firebird-support] wrote: >> Because it is hard to do. A lot of internals in Firebird and its >> clients >> rely on this maximum size

Re: [firebird-support] What is the optimum pageSize?

2019-11-16 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
atically stored out-of-line (ie basically as a blob, but that is transparent to the user). > And in FB4 it is also 64 kB? Yes. Mark -- Mark Rotteveel

Re: [firebird-support] Re: What is the optimum pageSize?

2019-11-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-11-14 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? The page size doesn't restrict or limit your database design, with the exception of

Re: [firebird-support] Re: What is the optimum pageSize?

2019-11-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-11-15 00:12, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > Thanks for clarifying! This is very useful info, especially the > ibexpert.net [1] site. > > Is there a Firebird site that provides details such as CHAR and > VARCHAR max sizes, pageSize size options, etc.? Most

Re: [firebird-support] Re: What are the trade-offs of CHAR vs. VARCHAR?

2019-11-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
ocumentation is unfortunately wrong (although I'm not sure why the language reference even cares to describe such an implementation detail). That table contains some more problems, for example for VARCHAR it says the length is in "two trailing bytes". Mark -- Mark Rotteveel

Re: [firebird-support] Re: What are the trade-offs of CHAR vs. VARCHAR?

2019-11-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
ective behaviour. However, if you want to discuss internals, then please make sure you are at least in the right ballpark, or ask for confirmation instead of stating something with conviction. Mark -- Mark Rotteveel

Re: [firebird-support] What are the trade-offs of CHAR vs. VARCHAR?

2019-11-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
lls Firebird and InterBase tools, and in this respect their documentation is wrong. Mark -- Mark Rotteveel

[firebird-support] L s

2019-11-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-11-14 03:40, Richard Damon rich...@damon-family.org [firebird-support] wrote: > On 11/13/19 9:51 AM, blackfalconsoftw...@outlook.com [firebird-support] > wrote: >>   >> Thank you Anne, for your succinct comments regarding the differences >> between the efficiencies of a CHAR and VARCHAR

Re: [firebird-support] Re: What are the trade-offs of CHAR vs. VARCHAR?

2019-11-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-11-13 17:37, blackfalconsoftw...@outlook.com [firebird-support] wrote: > Your statement, which may be true, does not sit well with a previous > statement that states that a VARCHAR field of 1000 characters is > stored in the table with 1000 characters. > > Your statement is suggesting a

Re: [firebird-support] What are the trade-offs of CHAR vs. VARCHAR?

2019-11-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-11-13 15:51, blackfalconsoftw...@outlook.com [firebird-support] wrote: > Thank you Anne, for your succinct comments regarding the differences > between the efficiencies of a CHAR and VARCHAR field definitions. > > Human observation cannot actually elicit any observable effects > between

Re: [firebird-support] Re: What are the trade-offs of CHAR vs. VARCHAR?

2019-11-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-11-13 18:42, blackfalconsoftw...@outlook.com [firebird-support] wrote: > Here is the link to the definition of CHAR and VARCHAR field > definitions from the IB-Experts site... > > > https://www.ibexpert.net/ibe/index.php?n=Doc.CHAR > https://www.ibexpert.net/ibe/index.php?n=Doc.CHAR >

Re: [firebird-support] What are the trade-offs of CHAR vs. VARCHAR?

2019-11-13 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-11-12 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? > > What is the max pageSize for CHAR? Page size is about

Re: [firebird-support] words reserved by version

2019-11-12 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 12-11-2019 10:31, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > On 2019-11-12 10:14, Mark Rotteveel m...@lawinegevaar.nl > [firebird-support] wrote: >> On 2019-11-12 10:03, Norbert Saint Georges n...@tetrasys.eu >> [firebird-support] wrote: &g

Re: [firebird-support] distinct on list() function

2019-11-12 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
uess what problem you're seeing. Mark -- Mark Rotteveel

Re: [firebird-support] words reserved by version

2019-11-12 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-11-12 10:14, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > On 2019-11-12 10:03, Norbert Saint Georges n...@tetrasys.eu > [firebird-support] wrote: >> Good morning all, >> >> Is there an exhaustive list of all the words reserved by version

Re: [firebird-support] words reserved by version

2019-11-12 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-11-12 10:03, Norbert Saint Georges n...@tetrasys.eu [firebird-support] wrote: > Good morning all, > > Is there an exhaustive list of all the words reserved by version of > firebird (3.x, 4.x) somewhere? > > Thank you in advance. Yes, it is in the doc folder:

  1   2   3   4   5   6   7   8   9   10   >