News

Rapid SQL XE6 / 8.7.5 is Now Available

Author: Embarcadero USA Rapid SQL XE6 version 8.7.5 is now available. EmbarcaderoRapid SQL is the integrated SQL development environment for IBM DB2, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, Sybase and Teradata database systems. Rapid SQL is your fast path to higher productivity whether you’re programming in SQL, PL/SQL, Transact-SQL or HTML. Customers with current maintenance…
Read more
News

Beginning Joins with SQL

Author: mahdy M7244 Introduction When we are talking about relational database, we are usually talking about many different tables and the relationships between them. We define relationships with various keys like primary key, foreign key, etc. When we have to retrieve data…
News

Top 2 Errors When Working with Datetime Conversions

Author: jpro51 Working on universal applications has its own challenges. Often I have seen developers resort to unwanted conversions inside the database based on application needs. I am a firm supporter that databases are not the place to play with date and time conversions. Databases are a great source for storing and retrieving data based on your needs. It has to be treated like this for most…
Read more
News

3 Cool SQL Server TSQL Snippets for Productivity

Author: Tim DelChiaro Nobody would want to shy away from some help. This is second to human nature and we never try totalk it out explicitly. When at work, if we can surely get help from our colleagues when it comes to driving the deadlines and completing it ahead of…
C++

Developer Direct 2014 Mobile School: Lesson 3 Slides and Replays

Author: Wayne S8181 Monday, July 14, 2014: Lesson 3 – Accessing Local Storage and Data In this lesson, we explore local storage covering a range of options including using INI files and local document storage. This lesson will also show how to use FireDAC database access components to connect to and use local SQLite, InterBase IBLite and IBToGo. You will understand the core concepts when…
Read more
Delphi

ORM Frameworks for Delphi...

I have just returned from myRAD Studio XE3 World Tour stops in Europe. It was great to see so many young and old developers in London, Amsterdam, Warsaw and Heidelberg. In two cities I was asked whether there were any Object Relational Mapping solutions for…
Delphi

Delphi JSON Viewer

Author: Michael K22532 JSON support has been introduced in Delphi 2010 as a part of DBExpress database driver architecture, but of course JSON support is not limited to just database applications. JSON is similar to XML as both are text-based data interchange formats. Delphi…
News

JSON Types for Server Methods in DataSnap 2010

Author: Adrian Z1428 converter_1946 I am very happy I was granted permission to talk about the new features present in Delphi 2010 concerning database area. DataSnap 2010 (DS2010) extended the list of server method parameter types with the full suite of JSON types. It is now possible to pass a TJSONObject instance for example from a client process to a server as input or output parameter and…
Read more