Watch, Follow, &
Connect with Us

Embarcadero Blogs

Latest Posts


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 database support without the need of a separate admin intensive process.  Embedded databases should be fast, have a small foot print, provide admin free capabilities all at the same time as providing full features SQL capabilities. Unfortunately, not all embedded databases provide complete capabilities, InterBase however is very feature rich in all editions. For more about Embedded databases and the different types they come in, watch the short video below.

Follow these links for

More about InterBase, the embedded database
Your free Developer edition or trial of InterBase

The post What is an embedded database? appeared first on Stephen Ball's Technical Blog.


posted @ Fri, 27 Feb 2015 11:40:01 +0000 by Stephen Ball


Buy Delphi, C++Builder or RAD Studio XE7, Get the Next Release Free

If you haven't purchased or upgrade to Delphi, RAD Studio or C++Builder XE7 yet, there has never been a better time. If you buy or upgrade now, you get the next major release free. This is in addition to the Buy One, Get One offer and the Bonus Pack.

Here's the info on it from the Embarcadero web site:


Get the Next Major Release Free!

Buy XE7 and get a free next major release to keep you up to date with latest hotfixes, exclusive content, support and more. Purchase a qualifying RAD Studio, Delphi or C++Builder XE7 product by March 31, 2015 to get the next major release free!
Availability: Available on purchases from February 23 - March 31, 2015.
How to get it: Once the next major release is ready, you will receive email instructions on accessing the maintenance portal to redeem your free copy. You must redeem your free copy within 2 weeks of the release.
Restrictions Apply. Not available with purchase Academic and Starter editions. See qualifying SKUs.

posted @ Thu, 26 Feb 2015 11:38:00 +0000 by Tim Del Chiaro


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 SDK with update.
Microsoft Visual Studio 2005 or above.
InterBase XE or above.

Installation Instructions

Run the InterBase ADO.Net 2.0 installer.

Usage Instructions

Start Visual Studio 2005/2008
File new C# Windows application
Project – Add Reference and add the AdoDbxClient.dll, DbxCommonDriver, DBXInterBaseDriver to your project.
Add a DataGridView component to your Windows Form
The sample code below fills a DataGridView component with the contents of the employee table of the employee.gdb sample InterBase database:

Code Example

>>>
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Borland.Data;
using Borland.Data.Units;
using System.Data.SqlClient;
using System.Data.Common;
namespace IBXEApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
ReadData(getConnection());
}
public DbConnection getConnection()
{
// DbProviderFactory factory = DbProviderFactories.GetFactory
// ("Borland.Data.AdoDbxClient");
DbConnection c = new TAdoDbxInterBaseConnection();
//DbConnection c = factory.CreateConnection();
c.ConnectionString = "Database=C:\\Embarcadero\\InterBase\\examples\\database\\employee.gdb;User_Name=sysdba;Password=masterkey";
return c;
}
public void ReadData(DbConnection conn)
{
string sql = "select * from employee";
DbCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
DbDataReader myreader = cmd.ExecuteReader();
dataGridView1.DataSource = myreader;
DataSet ds = new DataSet();
DataTable dt = new DataTable("employee");
ds.Tables.Add(dt);
ds.Load(myreader, LoadOption.PreserveChanges, ds.Tables[0]);
dataGridView1.DataSource = ds.Tables[0];
myreader.Close();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{

}
}
}
<<<

The post Connecting to InterBase from Visual Studio appeared first on Stephen Ball's Technical Blog.


posted @ Tue, 24 Feb 2015 11:40:02 +0000 by Stephen Ball


Radically Better UI Design with FireUI

Here's a copy of the latest RAD Studio, Delphi and C++Builder XE7 email. This one focuses on FireUI, one of the great new exclusive features in XE7 (and a reason to buy or upgrade).


Radically Better UI Design with FireUI
“The XE7 FireUI Multi-Device designer allows us to create a master view and customize the layout for numerous other devices. The development time it saves is worth the upgrade to XE7 alone.”
- Andrew Tierney, CastleSoft


Building User Interfaces for multiple form factors is challenging and resource intensive yet is becoming a common requirement. Introducing FireUI. Rather than building a completely separate User Interface for each form factor, FireUI allows you to create a common UI that can be natively optimized for different form factors. Share UI controls, event handling logic, and more across all form factors but deliver the best user experience for each device – you need to try it to believe it.


Create an app for Windows, OS X, iOS and Android in minutes!
  • New! Multi-Device Designer – focus on a common design with optimized inherited views for each target platform and device
  • New! MultiView Smart Layout Component – easily deliver the user expected layout and behavior for each form factor and platform
  • New! Behavior Services API – dynamic, platform specific behaviors that adapt at runtime

Critical Fixes in Previous Versions Now Included With Update Subscription!
Did you know we’ve updated Support and Maintenance, now called Update Subscription, to include critical fixes for previous versions of RAD Studio, Delphi and C++Builder at no additional cost? Now you’ll get critical hotfixes and updates on previous versions for up to 2 years from release, early beta access and more! Learn about Update Subscription >
Check out other popular new features in RAD Studio, Delphi and C++Builder XE7
!
New! App Tethering
New! Bluetooth
New! Parallel Programming
New! Behavior Services
New! MultiView Controls
New! Enterprise Mobility Services



See all the Limited Time Special Offers >


Up Next: Building Connected Apps with Bluetooth and App Tethering

posted @ Tue, 24 Feb 2015 07:30:00 +0000 by Tim Del Chiaro


RAD in Action: Building Connected Apps with Bluetooth and App Tethering

You’re invited to join me for a discussion and demonstration on how App Tethering and Bluetooth can be used to create exciting and new Internet of Things (IoT) solutions with distributed, connected apps.

RAD in Action: Building Connected Apps with Bluetooth and App Tethering

Wednesday, February 25, 2015
6AM San Francisco / 9AM New York / 2PM London / 3PM Milan
11AM San Francisco / 2PM New York / 7PM London / 8PM Milan
5PM San Francisco / 26-Feb 10AM Tokyo / 26-Feb 12PM Sydney

CLICK HERE TO REGISTER TODAY!

Useful IoT apps are not stand-alone mobile apps, but are distributed over several tiers, gadgets and devices such as operating system platforms including Windows, Mac, iOS, Android, as well as middle-ware, cloud, servers, and enterprise services. Bluetooth integrates IoT into an app solution. With App Tethering you can also breathe new life into existing desktop applications by extending them to include IoT.

Here’s what you will learn:

  • Capture Bluetooth LE data directly from a temperature and heart rate sensor
  • Use App Tethering to build a connected app and create a distributed IoT solution
  • Analyze the data lifecycle of an IoT solution to understand the possible data management and app logic tiers

Virtually all industries can immediately benefit from building connected apps, such as retail, food services, health care, manufacturing and industrial automation, and the applications are limitless!

Don’t miss out on this valuable information that will help you deliver highly innovative IoT solutions that your users and customers will love. Click here to Register for the webinar today!


posted @ Tue, 24 Feb 2015 14:58:22 +0000 by Al Mannarino


VCL and FireMonkey Style Gallery

With C++Builder, Delphi and RAD Studio XE7, we make it easy to customize the look of your application. You can choose from the built-in bitmap based native styles or work with custom styles. We recently added a VCL Styles Gallery and a FireMonkey Styles Gallery to our website where you can see a great preview of all the bitmap based styles.

VCLStylesGallery 

FMXStylesGallery1

Special offers and bonuses with your purchase of RAD Studio XE7, Delphi XE7, or C++Builder XE7!

    


posted @ Mon, 23 Feb 2015 18:23:00 +0000 by sarinadupont


Enterprise Mobility Services: Working with SQL Databases using Delphi Object Pascal

Accessing Enterprise Databases from the the EMS server and making the data easily available on mobile (and desktop) apps is one of the core tenets of EMS, and the combined use of FireDAC and special purpose data conduit components makes this task relatively easy.



This is a video replay from the CodeRage 9 online developer conference.


posted @ Mon, 23 Feb 2015 08:00:00 +0000 by Tim Del Chiaro


The Top Productivity Solution for DBAs

Why has Monster Energy drink become standard operating equipment for DBAs? Join us for a hard-hitting look at the state-of-the-union for DBAs, what to expect in the future and caffeine-free ideas for short-term success. This is a video replay from the DataU Online Conference.

Click here to watch 15 more videos from the DataU series.
Click here to learn more about DB PowerStudio.

Wes Kranz currently serves as the Sr. Director of Database Products at Embarcadero. He has a passion for making life easier with technology and has held numerous senior leadership roles at software & technology consulting companies. With experience as code slinger (developer), data doctor (database administrator) and model mechanic (data modeler), Wes provides leadership for database product management and marketing teams.


posted @ Fri, 20 Feb 2015 23:06:00 +0000 by Tim DelChiaro


Code Monkey in Delphi Code

In this special musical number I’ve created a music video based on Jonathan Coulton’s Code Monkey written in Delphi’s Object Pascal. [Download the code] [Download the video (mp4)]

posted @ Thu, 19 Feb 2015 06:39:21 +0000 by Jim McKeeth


Touch Management with Delphi and RAD Studio Object Pascal on all Platforms

Discover how to manage simple touch, gestures and multi-touch with Delphi and VCL or FireMonkey on all the platforms.



This is a video replay from the CodeRage 9 online developer conference.

    posted @ Tue, 17 Feb 2015 07:30:00 +0000 by Tim Del Chiaro


    Server Response from: BLOGS1