Stephen Ball Ball

Associate Product Manager, InterBase and Product Evangelist RAD tools.

Posted by on in Tutorial
InterBase Change Views Demo and Video InterBase Change Views Example Demo This week I hosted a Skill Sprints session looking at InterBase Change Views with an example set of code working around a Pharmacy needing to keep centralised drug information updated at distributed pharmacies. The example code will ship with the next major release of the RAD Studio products – which you can get for free, by buying XE7 now with a limited-time RAD offer.   This InterBase Change Views Example demo shows off this powerful way to...

Posted by on in Tutorial
What is an embedded database? A common question for a developer is how to store data. While file formats like INI files. XML, CSV etc provide a simple way to store data, they are often not secure enough or provide enough features for most applications. This is when a data store is required. One such option is an embedded database. What is an embedded database? An Embedded database is one that can be deployed inside or along side you application. They are called embedded as they can be silently deployed / installed to provide...

Posted by on in Tutorial
Connecting to InterBase from Visual Studio I was recently asked how to connect to InterBase from Visual Studio, and while its not something I have done before, luckily I know a man who has. – Thanks to Gabe Goldfield for checking the example below with InterBase XE7 and Visual Studio 2013 Ultimate. Connecting to InterBase from Visual Studio InterBase currently supports an ADO.Net driver that works with InterBase XE, XE3 and XE7 providing both 32bit and 64bit support. Full details here. Prerequisites You will need to have .Net 2.0 ...
InterBase Change Views – Part 3 – Using a change view In Part 1 I explored the concept of change views, before how to create a Change View ready for use in Part 2. In Part 3 we are going to explore how to use a Change View to collect data that has changed in your subscription. Using an InterBase Change View to fetch data deltas Once a Change View Subscription has been created and access to it has been granted (to either users or roles), then its time to start using your Change View! The following steps are the high level overview of using a Change ...
InterBase Change Views – Part 2 – Creating a Change View If you have ever spent time planning how to identify what data has changed, then change views is about to simplify the way you develop for ever! If you haven’t already read Part 1 of InterBase Change Views this provides a high level overview of the technology. Steps for creating a Change View Rather than having to create and manage triggers to add records into log tables or planning additional date fields into your metadata (and hoping date & time changes don’t effect you) Change...
InterBase Change Views – Part 1 – What is a change view This is the first post of a series on InterBase Change Views and is intended to be a high level overview of the new powerful change view technology that is patent pending and part of InterBase. Following this post I plan to show more posts taking the concept of Change Views into the real world with some real application examples. InterBase Change Views InterBase XE7 introduces a new way to track data changes to the database called Change Views. Change Views are a new “subscription based” model a...

Posted by on in Tutorial
Delphi, C++ and InterBase Community I’m sure some of you have seen the new Delphi, C++ and InterBase community platform that is being developed at Embarcadero. If not I would highly recommend a visit. The Embarcadero Community is the new home to blogs, event diaries, latest news and features articles. While the old locations are still working, over time expect to see more and more on the community. Community is also social media ready with links for Facebook, Twitter, linkedIn and Google+   Forums and Answers ...

Posted by on in Tutorial
Free FireDAC training online Free FireDAC training online! FireDAC is the Universal Data Access library for developing applications for multiple devices, connected to enterprise databases. Starting tomorrow you can join the embarcadero team for free FireDAC training online in these special sessions, where you will be taken from a beginner to an expert by showing you how to utilise FireDAC in multiple situations. Having used multiple database technologies over the years of developing with Delphi, I hav...
Embarcadero Acquires Castalia and Usertility from TwoDesk Software I did a blog post recently about Castalia which includes a video demoing some of the additional features Castalia adds to super charge the RAD Studio IDE. Having played with it for over a month now, I’m really excited that it will have tighter integration in the future following the announcement yesterday that Castalia has been acquired by Embarcadero. In addition to the news on Castalia, Usertility has also being acquired. This brings some exciting possibili...

Posted by on in Tutorial
Setting the default XML DOM in Delphi XE7 Managing the default XML DOM Scanning the whats new in RAD Studio XE7 (Delphi, C++ Builder) it covers the introduction of a new XML Dom (OmniXML) meaning there are now 3 XML DOMS to choose from when setting the default XML DOM. MSXML ADOM OmniXML The XML Dom defines which engine in essence is used to work with your XML documents. Should I read on? Well if your using SOAP or XML in your projects, then this could make a difference to your speed and performance of the applications, and it takes s...

Check out more tips and tricks in this development video: