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
SMS Sender – Automate Your SMS Discover SMS Sender! Tired of manually sending SMS for your personal or business needs? SMS Sender is the solution for you! With SMS Sender, you can easily automate SMS sending through its integrated web server. A single REST call is all you need to send messages quickly and efficiently.…
Read more
Bracket Highlighting in Delphi 12.0 Using SynEdit Delphi 12.0 users have a new tool to improve code readability: a procedure for enabling bracket highlighting in SynEdit. This feature helps developers quickly identify matching parentheses, braces, and other types of brackets within their code, which is essential for navigating complex code structures efficiently. To implement this…
Read more
Since 2014, it’s been possible to compile applications with Delphi for the iOS world and integrate the Indy library for TCP/IP communication with SSL encryption thanks to OpenSSL, as documented on Embarcadero’s website at the following link https://blogs.embarcadero.com/openssl-and-https-support-for-ios-devices/. This can be done by including the “IdSSLOpenSSLHeaders_Static.pas” library in your project and copying the compiled libraries…
Read more
