Re: [firebird-support] Install a DB Firebird on a web site

On 27/03/2019 12:01, 'Stellarancia.com' ni...@stellarancia.com [firebird-support] wrote: > I was thinking of moving the database Firebird from the computer to a > Web site, to allow all one connection directed by app. > Ithink this is possible for Firebird, but I have not succeeded in > finding

Re: [firebird-support] Text search ...

On 14/03/2019 13:20, Steve Wiser st...@specializedbusinesssoftware.com [firebird-support] wrote: > Sorry, to be more clear we used lucene outside of firebird.  We also > happened to store specific information about the files in firebird.  I > stayed away from the lucene within firebird approach

Re: [firebird-support] Text search ...

On 13/03/2019 14:01, Steve Wiser st...@specializedbusinesssoftware.com [firebird-support] wrote: > We have used tesseract-ocr It can be quite amazing what one misses even searching for something specific. This has thrown up a couple of add-ons that look interesting as well. Just have to fight

Re: [firebird-support] Text search ...

On 13/03/2019 02:35, Andrew Lowe a...@wht.com.au [firebird-support] wrote: > Maybe you might want to have a look at Zotero. It does a lot of stuff > with pdf's, databases etc. That is working on a different part of the problem although it might have provided pointers except for one thing ...

[firebird-support] Text search ...

I've got a few of sites where I've got a growing number of pdf files which it would be nice to actually index the content. First problem is obviously the different qualities of pdf, and I've had finereader deployed in some cases to provide OCRed copies of the original, with the usual variable

Re: ODP: [firebird-support] Silly selection problem ...

On 04/03/2019 15:56, Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] wrote: > You can do this without window function also in FB<3, but less efective. > Do simple 2 subselects in your select. Can you explain how? Without the full window scan LAG and LEAD gave NULL ... --

Re: [firebird-support] Silly selection problem ...

On 02/03/2019 16:50, Lester Caine les...@lsces.co.uk [firebird-support] wrote: >> OK another reason for moving over to FB3 ... >> LEAD and LAG working nicely ... > Except it's only half the solution:( > I was hoping to avoid traversing the parent gallery ... it would be nic

Re: [firebird-support] Silly selection problem ...

On 02/03/2019 16:24, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > On 02/03/2019 16:06, Lester caineles...@lsces.co.uk [firebird-support] > wrote: >> In the past ( 20 years ago;) ) I would simply have added a second >> position column which is consecutive num

Re: [firebird-support] Silly selection problem ...

On 02/03/2019 16:06, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > In the past ( 20 years ago;) ) I would simply have added a second > position column which is consecutive numbers and reordered them when > changes are made, but I'm wondering if with all the things that ha

[firebird-support] Silly selection problem ...

I think I will probably have to add some extra logic into this problem, but it SHOULD be simple enough ... Table with three fields - Gallery_No, Image_No, Item_position A gallery can consist of any number of images but we normally only display a selection of up to 30. Item_position is a FLOAT

Re: [firebird-support] FB3 stability ...

On 25/02/2019 14:06, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > A search for firebird on Leap 15.1 packages does not even give a result > and across all versions only returns the PHP clients. But I know I've > seen a repo for databases with 3.0.4 in ... so now to f

Re: [firebird-support] FB3 stability ...

On 25/02/2019 12:21, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > Or you could just try it to see if it helps. You have repeatedly posted > similar problems over the last few months, and I don't get the > impression you made any progress on it. I have been making progress, but

Re: [firebird-support] FB3 stability ...

On 25/02/2019 11:34, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > On 25-2-2019 12:22, Lester Caine les...@lsces.co.uk [firebird-support] > wrote: >> OK ... Have development system upgraded and currently running SUSE Leap >> 15.0 out of the box so ... >>

[firebird-support] FB3 stability ...

OK ... Have development system upgraded and currently running SUSE Leap 15.0 out of the box so ... Firebird 3.0.2 PHP 7.2.5 Nginx 1.14.0 ( Apache is locked out ) Getting the following randomly ... Warning: fbird_connect(): Your user name and password are not defined. Ask your database

Re: [firebird-support] Re: Strange behavior on very large table

On 22/02/2019 04:33, my...@techsol.org [firebird-support] wrote: > >Given that this table is "temporary" storage, one supposes that you > are deleting rows from it regularly. Do you happen to be deleting > 900,000 rows each day before you load up the latest batch of 900,000? How much information

Re: ODP: [firebird-support] Built in RegEx Capability?

On 12/02/2019 16:36, Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] wrote: > Select > D.NAZWA > , SUBSTRING(D.NAZWA FROM POSITION('V', D.NAZWA)+1 FOR POSITION('p', > D.NAZWA)-3) AS V > , SUBSTRING(D.NAZWA FROM POSITION('p', D.NAZWA)+1 FOR POSITION(' ', > SUBSTRING(D.NAZWA

Re: [firebird-support] Built in RegEx Capability?

On 11/02/2019 22:22, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 11.02.2019 22:18, Lester caineles...@lsces.co.uk [firebird-support] wrote: >> Ideally I need to extract the 'V' element and the 'p' element into their >> own fields so I can look up Volume '12' and page '234'

Re: [firebird-support] Re: Built in RegEx Capability?

On 11/02/2019 22:51, blackfalconsoftw...@outlook.com [firebird-support] wrote: > It may be more convenient to pull out data via a Regex expression in SQL > code but it is rather redundant since all of the major development > languages already support extensive Regex pattern matching

[firebird-support] Built in RegEx Capability?

I have some data in a table which I need to 'pull apart'. It's essentially a ID for a reference but it's not as tidy as I would like because of the variable length and a little variable in case although the format is consistent. V p .pdf For example 'V12 p234 The state of the nation.pdf'

Re: [firebird-support] Consecutive values from different fields

On 24/01/2019 07:50, 'Autoneer' myauton...@gmail.com [firebird-support] wrote: > I have never worked with a recursive cte before and have no idea on how > to go about this. Personally I'd start by reordering the data to a single field ... It's easy enough to DISPLAY a week at a time working

Re: [firebird-support] Consecutive values from different fields

On 24/01/2019 07:50, 'Autoneer' myauton...@gmail.com [firebird-support] wrote: > I have never worked with a recursive cte before and have no idea on how > to go about this. Personally I'd start by reordering the data to a single field ... It's easy enough to DISPLAY a week at a time working

Re: [firebird-support] Falling at second hurdle ...

On 17/01/2019 21:11, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > But PHP gives > fbird_connect(): Incompatible wire encryption levels requested on client > and server > That is PHP on the same machine as FB3 Sorted ... I've update from 3.0.2 to 3.0.4 from the suse:d

Re: [firebird-support] Falling at second hurdle ...

On 17/01/2019 20:36, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: >> WHAT am I not reading here? > I'd suggest to explicitly specify the user manager plugin you want to > use instead of leaving it to the specific configuration (doing this will > also detect problems if an

Re: [firebird-support] Falling at second hurdle ...

On 17/01/2019 20:13, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > On 17/01/2019 19:34, Dimitry Sibiryakov s...@ibphoenix.com > [firebird-support] wrote: >> 17.01.2019 20:11, Lester caineles...@lsces.co.uk [firebird-support] wrote: >>> So what can I do nex

Re: [firebird-support] Falling at second hurdle ...

On 17/01/2019 19:34, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 17.01.2019 20:11, Lester caineles...@lsces.co.uk [firebird-support] wrote: >> So what can I do next to get this to work? > You can read Release Notes for Firebird 3.0, chapter "Compatibility > Issues"

Re: [firebird-support] Falling at second hurdle ...

On 17/01/2019 18:40, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > On 17/01/2019 16:27, Mark rotteveelm...@lawinegevaar.nl > [firebird-support] wrote: >> On 17-1-2019 11:59, Lester caineles...@lsces.co.uk [firebird-support] >> wrote: >>> On 17/01/2019 1

Re: [firebird-support] Falling at second hurdle ...

On 17/01/2019 16:27, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > On 17-1-2019 11:59, Lester Caine les...@lsces.co.uk [firebird-support] > wrote: >> On 17/01/2019 10:51, liviuslivius liviusliv...@poczta.onet.pl >> [firebird-support] wrote: >>> I suppo

[firebird-support] Falling at second hurdle ...

OK, hitting a brick wall using older server setups with things that are considered essential these days no longer working, and the fixes requiring a full upgrade. Servers are running SUSE42.3 with Nginx/PHP7.0/FB2.5 and reliant on Letsecrypt for certificates, but trying to run a renew

Re: [firebird-support] concat a integer variable to a varchar

On 05/01/2019 11:23, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: >>> RTFM == Read The Fucking Manual, which - to me - is similar to saying >>> "You're an idiot and why the fuck are you bothering us with this simple >>> question.". >> In my time "F" stayed for "Following"

Re: [firebird-support] Converting dates and the ISO-8601 format

On 10/11/2018 11:19, i...@synapsesoftware.co.uk [firebird-support] wrote: > Fantastic! Works a treat! Wow, wonder how many other people are going to > be tripped up by this ! ? There is a list for firebird users on php firebird-...@yahoogroups.com It is true that Firebird does not perhaps get

Re: [firebird-support] Re: Server crash when no more space for the database

On 07/11/2018 07:51, hv...@users.sourceforge.net [firebird-support] wrote: > > While I executed some OLTP with 2.5(.9.27119 SS Win64) and no more space > > for the database the server crashed. See the attachment. Is it a known > > limitation (not fixed in 2.5 because it's too old) or a bug? >

Re: [firebird-support] Server crash when no more space for the database

On 06/11/2018 17:07, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote: > While I executed some OLTP with 2.5(.9.27119 SS Win64) and no more space > for the database the server crashed. See the attachment. Is it a known > limitation (not fixed in 2.5 because it's too old) or a bug? Where

Re: [firebird-support] Re: Sequential auto incremental numbering

On 03/09/18 07:29, 'Christian Giesen' ch...@xt.co.za [firebird-support] wrote: >   NextInvNo = (SELECT MAX(INVOICE_NO) FROM INVOICE) + 1; Christian ... there was many years ago a very nice article on this very problem. The whole reason that will not work is when two or more people are adding

Re: [firebird-support] Re: Sequential auto incremental numbering

On 03/09/18 10:36, Svein Erling Tysvær setys...@gmail.com [firebird-support] wrote: > I think the article Lester refers to may be the 'An auditable series of > numbers' article which can be found on > http://www.ibobjects.com/TechInfo.html. THAT is the one ... did not think t check IBObjects

Re: [firebird-support] Re: Mailing list change?

On 11/08/18 08:29, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: >> Another concern is the consideration of moving the current forum's data >> into a new forum's format. > Migrating the archive to a new platform is in my opinion not a > requirement. We will however need to

Re: [firebird-support] Re: Mailing list change?

On 11/08/18 09:42, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > I'm actually thinking about an accessible archive so they old post > remain available in some form. But creating a 'just-in-case' backup is > good idea. > > I'm going to play at that I have been trying since 2000

Re: [firebird-support] Mailing list change?

On 09/08/18 16:42, DougC d...@moosemail.net [firebird-support] wrote: > In light of the current problem of duplicate messages being sent out, > I'd like to bring up the idea of changing platforms from the Yahoo > Groups platform. Many other mailing lists I receive used to use Yahoo > Groups but

Re: [firebird-support] LOCALTIME and LOCALTIMESTAMP

On 18/07/18 09:50, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > I suggest you take this question to the firebird-devel mailing list as > it concerns an unreleased version. Questions on FB4 are off topic here. Although the corner cutting being taken in the current

Re: [firebird-support] hosting on linux questions

On 14/07/18 16:05, Issam Boughanmi amigof...@gmail.com [firebird-support] wrote: > i want to setup a vps to host my web site / application using existing > firebird databases > > 1- after some search , it seems that the recommended linux distribution > for a web server is centos 7, then ubuntu

Re: [firebird-support] Auto-increment generating old ID's for insertion

On 03/04/18 06:19, 'Joje' j...@codework-solutions.com [firebird-support] wrote: > SET GENERATOR _ID_GEN TO 16594028 Of cause you only need that to fix the current problem. A set query should not exist in the normal code. -- Lester Caine - G8HFL - Contact -

Re: [firebird-support] Auto-increment generating old ID's for insertion

On 02/04/18 13:11, 'Joje' j...@codework-solutions.com [firebird-support] wrote: > I have issue where auto-increment of ID column is generating older ID’s > that is already used in table. > > Currently, my transaction table has around 16 million rows and *ID of > last inserted row is

Re: [firebird-support] Firebird accounts package ...

On 03/02/18 08:53, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > Anybody got an accounting package powered by Firebird? OK after some work I've got kMyMoney installed with MySQL and Postgres drivers, but there is no pre-compiled Firebird driver for qt4-sql for SUSE. Anybody bu

[firebird-support] Firebird accounts package ...

Anybody got an accounting package powered by Firebird? My sage setup which I've used for many years has screwed up the database last year and while it's possible I can pay to recover it, it's time for a tidy-up of 15 years of data anyway. I've got CVS dumps of the current 15 years of history

Re: [firebird-support] What is currently available ...

On 07/09/17 11:04, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > Having be reliant on Interbase and then Firebird since the 90's I have a > lot of client data stored which I can rely on being available. Early > systems still use the windows based builder 6 code for s

[firebird-support] What is currently available ...

Having be reliant on Interbase and then Firebird since the 90's I have a lot of client data stored which I can rely on being available. Early systems still use the windows based builder 6 code for some areas, but on the whole access is via web based interfaces. I've used PHP5 since before it's

Re: [firebird-support] Spatial extensions...

On 26/08/17 17:01, prosse...@yahoo.com [firebird-support] wrote: > > I'm bored and need a challenge... I'd really like to add spatial support > to firebird so how do I sign up? I've been programming in C, C++ and > Delphi for 30 years and now I can write what I want to write! It would be nice

Re: [firebird-support] Firebird 2.5 - Alter table - drop default - bug or feature

On 26/04/17 16:34, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: > If Firebird were to convert a record from its stored format through each > intervening format, the result would be more logical but it would be a change > to a behavior that's over 30 years old. And there are

Re: [firebird-support] Firebird 2.5 - Alter table - drop default - bug or feature

On 25/04/17 16:50, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > The SQL standard is quite clear at what needs to happen: adding a new > column with a default should behave as if that column has existed from > the original create table (btw: irrespective of the NOT NULL

Re: [firebird-support] Firebird 2.5 - Alter table - drop default - bug or feature

On 25/04/17 12:51, Maxi maxiroba...@gmail.com [firebird-support] wrote: > I expect the value assigned by DEFAULT when I add the new field is > still there. There has been various discussions on this area ... If you add 'NOT NULL' to an existing field, then you need to populate the existing

Re: [firebird-support] ezSQL/Wordpress

On 09/03/17 11:23, 'Alan McDonald' a...@meta.com.au [firebird-support] wrote: > I use ezSQL with Firebird > Excellent, as long as you use my version :-0 > Happy to give it to you Yes please - thought someone would have used it ;) > I use it in conjunction with ez_results - grid browser - my

[firebird-support] ezSQL/Wordpress

I've picked up a client who has his website on wordpress which is MySQL only. The database is only 60Mb as a raw SQL dump but still took the best part of an hour to restore via 'mysql-workbench' so not the best response for backup between machines. Now I though ezSQL supported Firebird? I'll

Re: [firebird-support] Migrating a 2.5 server

On 07/02/17 08:14, Luke Crooks l...@solentwholesale.com [firebird-support] wrote: > When running the 2.5 server on our Windows DC and having clients access > from the local network, performance was very slow (almost unusable). We > are using a safescan product (Time Attendance +) which uses a

Re: [firebird-support] Time zones

On 12/01/17 14:09, Tim Ward t...@telensa.com [firebird-support] wrote: > Can someone point me in the right direction please? There have been many attempts to justify storing a time stamp complete with timezone directly in a time field, but the real answer is that it is always wrong. Store

Re: [firebird-support] Overflow problem

On 25/11/16 14:11, fabia...@itbizolutions.com.au [firebird-support] wrote: > Are you trying to store details of the American public debt? or the world's > public debt? Just kiding Not See other post ;) It is vulnerability to overflow edge cases that are the potential problem - especially in

Re: [firebird-support] Overflow problem

On 25/11/16 13:56, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > On 2016-11-25 12:40, Lester Caine les...@lsces.co.uk [firebird-support] > wrote: >> > Nothing to do with Firebird but can anybody explain why the numbers in >> > 'SELECT FIRST 1021211211212

[firebird-support] Overflow problem

Nothing to do with Firebird but can anybody explain why the numbers in 'SELECT FIRST 102121121121212 SKIP 3574239239242420' would be a problem in MySQL or is it some other vulnerability the original sQL injection was trying to hit. I know I need to add limit checks in the code which reprocessed

Re: [firebird-support] Digest Number 9396 (Temporary Tables)

On 22/11/16 07:09, tiberiu_horv...@yahoo.com [firebird-support] wrote: > I have code that uses temporary tables in at least 30 places in my > programs. This is the way I did complicated queries. Most of these > procedures are written 10 years ago (Interbase, Firebird 1.0). I cannot > change

Re: [firebird-support] problem - change autoincrement fields to identity fields

On 18/11/16 11:03, Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support] wrote: > But I want to use identity fields because such fields don't uses a generator > and a trigger. Putting this a different way ... the correct way of ensuring where multiple users are adding records

[firebird-support] Missing something ...

OK I've put a new machine together using the latest builds via SUSE which has given me Nginx, PHP7 and Firebird3. Firebird is working locally and after a couple of problems Nginx and PHP7 are talking since they package manager did not complete the configuration. Now I need to configure FB3 so

Re: [firebird-support] Vulnerability

On 27/09/16 19:01, Carlos Mazariegos carlosemazarieg...@gmail.com [firebird-support] wrote: > The vulnerability that reported Palo Alto is: > > > * *Unique Threat Id:* 31633 > * *Descriptión:* Ther exists a buffer overflow vulnerability in > Borland Interbase server. Which has nothing

Re: [firebird-support] PHP PDO fetch from insert... into... or from stored procedure without suspend clause? Is it possible?

On 13/09/16 11:09, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > I tried to create new topic in firebird-php but it is getting list, not > visible. :(( On all the yahoo lists the fist posts are moderated. It's up now ... -- Lester Caine - G8HFL - Contact -

Re: [firebird-support] PHP PDO fetch from insert... into... or from stored procedure without suspend clause? Is it possible?

On 13/09/16 06:30, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > But it looks like from the Yii2 code that select and insert...returning > is handled alike in the PHP Data Objects. Can it be possible that > Firebird PDO driver deviates from the official PDO interface. Who > develops

Re: [firebird-support] Transaction in limbo

On 19/07/16 11:14, michael.vilhelm...@microcom.dk [firebird-support] wrote: > As I read about 2 phase commits, its about 2 databases. We do not use > more than one Application with two connections to the same database? That may not be so easy to spot if you don't have full access to the code. --

Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2

On 11/03/16 13:06, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > As quoted in the documentation in my previous mail, Windows only guarantees > updates of the timestamps when the handle is closed. Which has been the case in windows for 20 years. It is only M$ who could 'fix'

Re: [firebird-support] FirebridSQL and Log´s

On 12/02/16 19:14, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > I am thinking about the better/faster/easier way to log changes made in > records on the tables of my DB. > > Could someone share experience (good or bad)? Any suggestion?

Re: [firebird-support] Firebird 3.0 RC1 - SQL optimization help

On 24/01/16 08:04, Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support] wrote: > I needed some time to understand (at least try to understand) your post. > Please, note that my SQL knowledge is very limited. I really don’t know > internals of database any system. Though, I need to

Re: [firebird-support] The PHP default transaction

On 21/01/16 10:44, Tim Ward t...@telensa.com [firebird-support] wrote: > (1) Is this likely to be the "default transaction" that PHP creates for > a connection if you don't do an explicit start transaction? Ie, does PHP > create the default transaction for a connection even if you never use it

Re: [firebird-support] Extract seconds from timestamp

On 06/01/16 08:37, 'Bogdan' bog...@mordicom.si [firebird-support] wrote: > I wonder if this is an error or sql srandard: > > select cast(extract(second from cast('12.12.2016 23:59:59:9000' as > timestamp)) as integer) from rdb$database

Re: [firebird-support] 2 servers acessing one database

On 16/12/15 15:19, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] wrote: > What I mean is using 2 servers to connect to the same DB. > This DB is in a shared disk that both servers can access. > So I would have, for example, 100 clients connecting on server 1, another 100 > clients

Re: [firebird-support] Re: How to make Sphinx work with Firebird on Linux?

On 13/11/15 14:22, hv...@users.sourceforge.net [firebird-support] wrote: > Patch was updated but not announced: > > http://web.firebirdsql.org/download/sphinx/ > > You should get Sphinx sources, apply patch and make by yourself on CentOS Little problem Vlad ... 2.2.9 is not actually available,

Re: [firebird-support] Re: How to make Sphinx work with Firebird on Linux?

On 13/11/15 16:23, hv...@users.sourceforge.net [firebird-support] wrote: >> ---In firebird-support@yahoogroups.com, wrote : >> >> On 13/11/15 14:22, hvlad@... [firebird-support] wrote: > > > > Patch was updated but not announced: > > > > > >

Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off

On 22/09/15 10:31, Glenn Thomas Hvidsten g...@vensafe.no [firebird-support] wrote: > Thanks for all the suggestions so far. > We have already put some of our clients computers on UPS. I'm still > interested in other settings we can enable (or disable) to make the database > server more robust

Re: [firebird-support] Firebird Server on Windows 10

On 11/09/15 21:29, Mike Ro miker...@gmail.com [firebird-support] wrote: >> On a more radical solution, try installing your firebirdsql to a >> folder NOT in Program Files. >> > Yes, this solves it! > > So it is definitely a permissions thing, but I haven't been able to find > out what yet.

Re: [firebird-support] Re: Hex string literal, blob not supported for conversion?

On 31/08/15 16:07, 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support] wrote: > Nevertheless, the parameter is BLOB. Why is one blob conversion supported, > but an other, that looks the same to the user, fails? Martijn ... I always thought that the 'blob' in a function

Re: [firebird-support] Re: Using events with php

On 26/08/15 19:48, dmil...@amfes.com [firebird-support] wrote: You're correct - but I'm trying to follow an example I saw. I think what you are missing perhaps is that the added ID on the example is allowing the client to only monitor events for a particular ID. So the client asks to see

Re: ODP: [firebird-support] Taking database back from v2.5 ODS11.2 to v2.1 ODS11.1

On 07/08/15 06:30, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: Why do you need to go back? There is still a lot of code in use that will not run with 2.5 and running both versions can be a bit of a nightmare. I've restored on the wrong machine myself while looking to do

Re: [firebird-support] Proper way for copy data from big table

On 19/06/15 14:20, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: SELECT FIRST 100 SKIP 0 * FROM SOURCE_TABLE -we got 100 reads - ok SELECT FIRST 100 SKIP 100 * FROM SOURCE_TABLE -we got 200 reads - not ok SELECT FIRST 100 SKIP 200 * FROM

[firebird-support] Dragging things up to date ...

OK just been going around in circles trying to find notes on converting from NONE to UTF8 and not getting anywhere ... Historically I've always been happy with NONE, but these days all the web site traffic is UTF8 so I think it's time to start tidying up, and so I THINK I need to switch the

Re: [firebird-support] performance on calculated fields - performance question

On 29/04/15 21:40, shg_siste...@yahoo.com.ar [firebird-support] wrote: With 40.000 records, I have no problem with this. But do you think it will be very bad as the customers keep growing? I mean, generally speaking, it's expensive (regarding to the speed) to have calculated fields?? The

Re: [firebird-support] Revert DB to previous version

On 18/03/15 17:37, sboyd...@gmail.com [firebird-support] wrote: If I understand what you are saying, you want me to copy gbak.exe for 2.0.5 to the 2.1 system and use the 2.0.5 gbak to back up the 2.1 database using the 2.1 Firebird service. Correct? Spot on ... But it will not work if you have

Re: [firebird-support] I don´t receive my messages

On 20/01/15 19:49, Eduardo guse...@gmail.com [firebird-support] wrote: Yesterday I sent an e-mail to the list but I didn´t receive it. I received other mails from the list but didn´t receive my own message. Today I received an answer to my message and I sent a new mail. Again I didn´t

Re: [firebird-support] Stability on newer windows ...

On 24/11/14 11:59, marcus mar...@antiphasis.net [firebird-support] wrote: I did a full backup and restore to the databases but JUSThad WDZP (Server) Mon Nov 24 10:26:52 2014 Database: HISTORY internal gds software consistency check (cannot find tip page (165), file: tra.cpp line: 2494)

Re: [firebird-support] Stability on newer windows ...

On 19/11/14 18:18, Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support] wrote: Try using the 32 bit version of Firebird, maybe this can help you. Run 32bit Firebird 2.1.6 with 32bit apache and php but it is unfortunate a 64bit version of Windows7 which is all that was

[firebird-support] Stability on newer windows ...

My systems have run for many years on XP and W2k without any problems, but now I'm being forced to upgrade systems on sites to a later version of windows, I'm hitting problems. I'm having to live with both Windows 7 and 8.1, fortunately 8 is black listed like vista. I've had problems with windows

Re: [firebird-support] Stability on newer windows ...

On 19/11/14 17:15, Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support] wrote: Currently, FB 2.1 is lo longer supported as older OSs. Maybe your problem was corrected in a newer FB version as FB 2.5.3 (that corrects a bug of caching on 64 bit Windows by example).

[firebird-support] Hack attempts ...

One of my sites is being hit with an attempt to hack into it or at least that is what I assume. The following SQL is being added where they think it will get processed

Re: [firebird-support] Re: Hack attempts ...

On 20/09/14 10:51, map...@gmail.com [firebird-support] wrote: Seems to be an automated bot that tries to takeover the server something inspired by sqlmap https://github.com/sqlmapproject/sqlmap or phpmvs http://sourceforge.net/projects/phpmvs/ some of the takeover attempts are

Re: [firebird-support] Help!!! - Problem with Firebird Embeded

On 14/09/14 09:25, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: And still both myapp.exe and IB_SQL.exe give Database unavailable message (ISC ERROR CODE:335544375 in the cae of IB_SQL.exe) :( Ok, so you don't have the error with your own application (myapp.exe), but with

Re: [firebird-support] Help!!! - Problem with Firebird Embeded

On 14/09/14 12:46, Adam adam...@gmail.com [firebird-support] wrote: Engine Code :335544721 Engine Message: Unable to complete network request to host localhost Failed to establish connection. So yes FlameRobin provides more information but still I cannot understand why This means

Re: [firebird-support] Help!!! - Problem with Firebird Embeded

On 14/09/14 13:20, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: On 14-9-2014 14:11, Lester Caine les...@lsces.co.uk [firebird-support] wrote: On 14/09/14 12:46, Adam adam...@gmail.com [firebird-support] wrote: Engine Code :335544721 Engine Message: Unable to complete

Re: [firebird-support] Help!!! - Problem with Firebird Embeded

On 14/09/14 13:38, Adam adam...@gmail.com [firebird-support] wrote: 1 - Running my app results in the following error message: [FireDAC][Phy][IB]-314. Cannot load vendor library [fbclient.dll]. Hint: check it is in the PATH or application EXE directories, and has x86 bitness. I've checked

Re: [firebird-support] Help!!! - Problem with Firebird Embeded

On 14/09/14 14:00, Adam adam...@gmail.com [firebird-support] wrote: Otherwise you need the 32bit build ... which may account for your earlier results as the deleted versions may have been the right 'bittyness' and being picked up rather then the renamed embedded one in your

Re: [firebird-support] Help!!! - Problem with Firebird Embeded

On 14/09/14 14:34, Adam adam...@gmail.com [firebird-support] wrote: Just tested it and all works fine. FlameRobin uses the FireBird running in background process and yes as long as the database is not being concurrently accessed all works fine. Thank you o much for giving your time to my

[firebird-support] Strange date values

I thought I'd save some time by spending some money on XMLWizard to do some CSV imports of data sets ... rather than pulling together my own PHP scripts. It seems to work well enough on Windows, but I could not get the Linux version working. But the problem I've found is that while the date

Re: [firebird-support] Data Partitioning with Firebird

On 06/08/14 02:41, Nigel Weeks nigel.we...@karbonit.com.au [firebird-support] wrote: I've been using Firebird for years, but mainly keeping a very low profile. I'm planning a Health Informatics project with the University of Tasmania, and as I've used Firebird to power all the other projects,

Re: [firebird-support] Re: AV in fbembed.dll_unloaded

On 02/08/14 14:11, tobias_subscri...@tgtools.com [firebird-support] wrote: Wow, many thanks! I can't believe it ... and there is not a trace of this in IBO? Very strange ... so I need to grab IBO's DLL handle and get the function address myself, OK ... I can do it ... but I am still shocked.

[firebird-support] Yahoo broken again?

I've just been trying to access the list on-line, but it would seem yahoo have broken everything again? Keeps coming back that the redirect can not complete? Is the 'VISIT YOUR GROUP' below working for anybody? -- Lester Caine - G8HFL - Contact -

Re: [firebird-support] Yahoo broken again?

On 27/06/14 09:16, Lester Caine les...@lsces.co.uk [firebird-support] wrote: I've just been trying to access the list on-line, but it would seem yahoo have broken everything again? Keeps coming back that the redirect can not complete? Is the 'VISIT YOUR GROUP' below working for anybody? OK

Re: [firebird-support] Database Too Large.

On 27/06/14 08:43, 'stefano.mala...@gmail.com' stefano.mala...@gmail.com [firebird-support] wrote: i run SAM Brodcaster (Webradio Automation Software) with firebird database. I've a big problem because SAMDB.FDB increase day after day in an exaggerated way. After 150 days of running the db

Re: [firebird-support] loading data from a .csv file?

I process mine through php ;) Although I have dropped mysql data as simple insert data. It would perhaps be nice as an option in flamerobin Sent from my android device so the quoting is crap! -Original Message- From: Alan Shank li...@notoriousshankbrothers.com [firebird-support]

  1   2   >