The video tutorial is excellent but my progress has been slowed by getting Firebird, Flamerobin and LibreOffice installed and configured using Linux with a Manjaro distribution. Firebird and Flamerobin are cooperating with one another (finally!) but it seems that LibreOffice 7.6 works on partially with Firebird-5. I can not enter or edit records through LibreOffice base to a Firebird database. From my short investigation it looks like I might have to retard Firebird all the way back to version 2.5. Have you had any similar experiences? /r Ted Baker, Newry, Maine, USA
So, I'm on windows 10 and using Firebird 4, I'm back researching Firebird security at the moment and hope to have several more videos out on Firebird soon. My experience with not being able to edit records in LiberOffice base has been when I've forgotten to declare a primary key on a table (This isn't just a Firebird thing, this will happen with MySql or HSQLDB also). Could that be the issue with your situation?
Thank you for the very prompt reply. After a little more digging I have determined the culprit to be Firebird-ODBC. The Arch Linux AUR ODBC install package has not kept up with the recent releases of Firebird. Since AUR install packages rely on volunteers it might be some time before an update is available; a beta version is available for Windows but not for Linux. If I use the internal Firebird driver in LibreOffice Base everything works as it should. So, I will put the ODBC connection aside for now, use the internal driver and continue to work along with your excellent video. Please keep them coming. /r Ted Baker, Newry, Maine, US
@@edwardbaker8200 There's three ways to connect to Firebird on windows at least (that I've found so far), Firebird internal driver and firebird odbc work with lo base windows, with odbc windows I click "quoted identifiers", sensitive identifier and autoquoted identifier, from memory nearly (9 months ago) the config of the odbc driver made a difference. also the ibexpert driver might be free it says trial on the site, but I'm not sure if it's got a time limit or not the site isn't clear on this issue so it's worth playing with.
Thanks for showing some of the programing that happens with Flamerobin, Firebird, ODBC and LibreOffice BASE. As A newbie I don't really understand what your task manager does. Respectfully, I am not sure that I do. My main interest for watching was to try and learn more about using Flamerobin. I want to try and use Delphi 11 and Firebird 3 more. But first I have to decide on what goes into my Database. I have two Firebird v3 Databases. A single table database and one database with five tables. 1) How do I check their integrity and /or repair them ? can that be done in Flamerobin ? 2) one database has a table "x" (81 000 entries) and four other tables "a", "b", "c", "d" and another second database has a same database "x" (82 700 entries) [ let's call it "x"(Max) ]. If I want to keep the table "x" (Max) with the largest number of entries and move/copy the other four tables "a", "b", "c", "d" into that database containing table "x" (Max), is there an easy way to do that using Flamerobin ? To reiterate, this question is on how to copy four tables into another database. 3) So, assuming I now have all the tables I want in one Database, is there a way to obtain a 64bit ODBC driver for Paradox 7 tables ? I have only been able to find 32bit versions. This is for datapumping into Firebird 3. If one of the programs is in mis-match ie not all 32-bit or not all 64 bit then datapumping is doomed to fail. Anyway, thanks again for the Flamerobin tutorial it is much appreciated. Out of curiosity why did you leave the language field blank when creating the Flamerobin connection ? Cheers
I'm afraid that you've asked a lot of detailed questions, I'm just getting on top of Firebird myself, so in short giving you those answers would involve hours of research on my time, time I don't have.. Just use google and the Firebird documentation. Re point two I'd look for a way to export the table as a csv file then import it into another database, dont forget that LibreOffice base will connect to Firebird so you could look into using base to effect the transfer.
I was able to resolve the Firebird issue and also downloaded Flamerobin and the OCDB. I was able to run the test connection successfully. However, when I opened the Flamerobin to connect to the Taskmanager FBD file it gave me an SQL message of 902. It indicated it could not find the file. So if you have a solution Im open to suggestions. I know you are a busy person so if you don't have time I understand. Thanks
In Firebird you've got to connect to the database, so if you're using the terminal it would look something like this.... C:\Users\businessprogrammer>cd C:\Program Files\Firebird\Firebird_4_0 C:\Program Files\Firebird\Firebird_4_0>isql -user sysdba -password masterkey Use CONNECT or CREATE DATABASE to specify a database SQL> connect "D:\LocalData\FirebirdDB\DEVBIDESTIMATOR.FDB"; Database: "D:\LocalData\FirebirdDB\DEVBIDESTIMATOR.FDB", User: SYSDBA Flamerobin lets you attach multiple databases, google around that topic, hopefully, I'll do some more videos on this topic in the near future.
Would you be willing please to show how to automate data entry in LibreOffice Calc using Python? A good example for me and what I need is showing how to OCR a PDF, extract data, sort and categorize data and fill Libreoffice Calc table with data, all using Python.
This book US amzn.to/3DqA3mr or UK amzn.to/3pTed87 covers those topics. You should'nt need to ocr a pdf as it's alreay in electronic format. pandas with python will handle the sorting and categorising, you can then use python to write a csv which can be imported to libreOffice. the book also cover writing excel files which calc can read it might even cover writing ods calc files.
Well this is the download page, choose your operating system, and go from there, don't know what you mean by "unconfirmed"? firebirdsql.org/en/firebird-4-0/#Win64 I've just test downloaded the Windows 64 executable from that page without any problems.
![ILLSLICK X YOUNGOHM - We're The same [Official Video]](http://i.ytimg.com/vi/yUJNkobYR0E/mqdefault.jpg)
The video tutorial is excellent but my progress has been slowed by getting Firebird, Flamerobin and LibreOffice installed and configured using Linux with a Manjaro distribution. Firebird and Flamerobin are cooperating with one another (finally!) but it seems that LibreOffice 7.6 works on partially with Firebird-5. I can not enter or edit records through LibreOffice base to a Firebird database. From my short investigation it looks like I might have to retard Firebird all the way back to version 2.5. Have you had any similar experiences? /r Ted Baker, Newry, Maine, USA
So, I'm on windows 10 and using Firebird 4, I'm back researching Firebird security at the moment and hope to have several more videos out on Firebird soon. My experience with not being able to edit records in LiberOffice base has been when I've forgotten to declare a primary key on a table (This isn't just a Firebird thing, this will happen with MySql or HSQLDB also).
Could that be the issue with your situation?
Thank you for the very prompt reply. After a little more digging I have determined the culprit to be Firebird-ODBC. The Arch Linux AUR ODBC install package has not kept up with the recent releases of Firebird. Since AUR install packages rely on volunteers it might be some time before an update is available; a beta version is available for Windows but not for Linux. If I use the internal Firebird driver in LibreOffice Base everything works as it should. So, I will put the ODBC connection aside for now, use the internal driver and continue to work along with your excellent video. Please keep them coming. /r Ted Baker, Newry, Maine, US
@@edwardbaker8200 There's three ways to connect to Firebird on windows at least (that I've found so far), Firebird internal driver and firebird odbc work with lo base windows, with odbc windows I click "quoted identifiers", sensitive identifier and autoquoted identifier, from memory nearly (9 months ago) the config of the odbc driver made a difference. also the ibexpert driver might be free it says trial on the site, but I'm not sure if it's got a time limit or not the site isn't clear on this issue so it's worth playing with.
Thanks for showing some of the programing that happens with Flamerobin, Firebird, ODBC and LibreOffice BASE.
As A newbie I don't really understand what your task manager does. Respectfully, I am not sure that I do.
My main interest for watching was to try and learn more about using Flamerobin.
I want to try and use Delphi 11 and Firebird 3 more.
But first I have to decide on what goes into my Database.
I have two Firebird v3 Databases. A single table database and one database with five tables.
1) How do I check their integrity and /or repair them ?
can that be done in Flamerobin ?
2) one database has a table "x" (81 000 entries) and four other tables "a", "b", "c", "d"
and another second database has a same database "x" (82 700 entries) [ let's call it "x"(Max) ].
If I want to keep the table "x" (Max) with the largest number of entries and move/copy the other four tables "a", "b", "c", "d" into that database containing table "x" (Max),
is there an easy way to do that using Flamerobin ?
To reiterate, this question is on how to copy four tables into another database.
3) So, assuming I now have all the tables I want in one Database, is there a way to obtain a 64bit ODBC driver for Paradox 7 tables ? I have only been able to find 32bit versions. This is for datapumping into Firebird 3.
If one of the programs is in mis-match ie not all 32-bit or not all 64 bit then datapumping is doomed to fail.
Anyway, thanks again for the Flamerobin tutorial it is much appreciated.
Out of curiosity why did you leave the language field blank when creating the Flamerobin connection ?
Cheers
I'm afraid that you've asked a lot of detailed questions, I'm just getting on top of Firebird myself, so in short giving you those answers would involve hours of research on my time, time I don't have..
Just use google and the Firebird documentation.
Re point two I'd look for a way to export the table as a csv file then import it into another database, dont forget that LibreOffice base will connect to Firebird so you could look into using base to effect the transfer.
How do you make the writing with pen to see it. Fascinating.
I've got a camera pointing down on that desk, two desk mounted vertical supports with a crossbar on the supports, camera is mounted to the crossbar.
I was able to resolve the Firebird issue and also downloaded Flamerobin and the OCDB. I was able to run the test connection successfully. However, when I opened the Flamerobin to connect to the Taskmanager FBD file it gave me an SQL message of 902. It indicated it could not find the file. So if you have a solution Im open to suggestions. I know you are a busy person so if you don't have time I understand. Thanks
In Firebird you've got to connect to the database, so if you're using the terminal it would look something like this....
C:\Users\businessprogrammer>cd C:\Program Files\Firebird\Firebird_4_0
C:\Program Files\Firebird\Firebird_4_0>isql -user sysdba -password masterkey
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect "D:\LocalData\FirebirdDB\DEVBIDESTIMATOR.FDB";
Database: "D:\LocalData\FirebirdDB\DEVBIDESTIMATOR.FDB", User: SYSDBA
Flamerobin lets you attach multiple databases, google around that topic, hopefully, I'll do some more videos on this topic in the near future.
Would you be willing please to show how to automate data entry in LibreOffice Calc using Python?
A good example for me and what I need is showing how to OCR a PDF, extract data, sort and categorize data and fill Libreoffice Calc table with data, all using Python.
This book US amzn.to/3DqA3mr or UK amzn.to/3pTed87 covers those topics. You should'nt need to ocr a pdf as it's alreay in electronic format.
pandas with python will handle the sorting and categorising, you can then use python to write a csv which can be imported to libreOffice.
the book also cover writing excel files which calc can read it might even cover writing ods calc files.
@@BusinessProgrammer I don't think scanned documents that are just contained into the PDF count as "recognizable" without the use of a OCR engine.
Tried to download Firebird. It shows up as unconfirmed and I don't know where to go from there. Thanks
Well this is the download page, choose your operating system, and go from there, don't know what you mean by "unconfirmed"?
firebirdsql.org/en/firebird-4-0/#Win64
I've just test downloaded the Windows 64 executable from that page without any problems.
What is fire bird?
Watch the video to find out...