smartFB v. 2.2.0.185 is available for download at the link: https://api.xtumble.com/downloadattachmentpub?cid=05830520960&fname=/applications/public/SetupSmartFB.exe What’s New: New form to test API connections, styled like Postman ( Tools –> Network Utility –> API Tester ) Direct display of stored procedure parameters on the main db tree Improved syntax highlighting and parenthesis management in the editor Introduced field-level dependency analysis…
Read more
Managing the “&” character with Firebird’s string manipulation functions sometimes may not yield the expected results. The documentation for Firebird’s official “REPLACE” function: https://firebirdsql.org/refdocs/langrefupd25-intfunc-replace.html For example, if we were to make the classic replacement “>” with “>” with an update, it would be normal to write:
|
1 2 |
UPDATE "YOUR_TB_NAME" SET "YOUR_TB_NAME"."TEXT_FIELD" = REPLACE("YOUR_TB_NAME"."TEXT_FIELD",'>','>') |
If this syntax does not produce the expected…
Read more
smartFB v. 2.2.0.185 is available at: https://api.xtumble.com/downloadattachmentpub?cid=05830520960&fname=/applications/public/SetupSmartFB.exe Whats new: Firebird 5.0 support “Internal Function” manager For any questions or feedback, please do not hesitate to contact us. Your opinion is crucial to us! Thank you for your support and trust in smartFB. Good luck with your Firebird databases!
Firebird 5.0 brings with it a remarkable series of improvements from many points of view, from performance to security to the management of parallel backups and restores. You can find these well described at the following link: https://ib-aid.com/en/articles/detailed-new-features-of-firebird-5-part-1-improvements-in-optimizer. So, let’s get down to business, let’s install Firebird 5.0 on a nice Ubuntu 22.04 machine in…
Read more
A new version of smartFB, the rapid Firebird and Interbase database management tool. New features: Improved usability and minor graphic tweaks Improved management of embedded database creation Integration with Xtumble4Delphi library for JSON to Delphi Record management Started implementation of a tool that allows you to export / import datasets in MIDAS ClientDataset and FiredacMemTable…
Read more
From version 2.5 Firebird introduces the “SIMILAR TO” predicate which allows you to apply a subset of regular expressions in an SQL condition. The documentation of the “SIMILAR TO” predicate is available at https://firebirdsql.org/refdocs/langrefupd25-similar-to.html If we wanted to check if there are numbers (DIGIT) inside a string, i.e. characters from ‘0’ to ‘9’ we could…
Read more
