We continued our webinar with a look at how ridiculously fast and easy it is to create cross-platform apps with RAD Studio and connect to a variety of databases. One of the great strengths of RAD Studio, and particularly Delphi and C++ Builder is how it can use components like FireDAC to connect to almost any database system there is available. In the webinar I looked at the range of built-in…
Today (December 20th 2022) and tomorrow you can join us for Embarcadero’s two day Enterprise CodeRage event which focusses, as you might expect, on enterprise development topics using your favorite IDE software. I am presenting two sessions – this blog post…
A Complete Guide To Advanced Programming In C++
This article is part of a series which teaches you the basics of how to write C++ software. C and C++ both make use of pointers. Often, new C++ programmers can struggle with both the concept and correct use of pointers. In…
LearnCPlusPlus.org :: Learn FireDAC, MyDAC Components And MySQL, PostgreSQL, InterBase Databases, And Much More
March 29, 2021
Hello C++ Builder Developers,
We have great new C++ Builder post picks from the LearnCPlusPlus.org website on the basics of connectivity to different database systems. Do you want to learn how to connect to MySQL Server in C++ Builder? Want to use the MyDAC component to connect MySQL Database in C++ Builder? Do you want to connect to PostgreSQL in C++ Builder? Do you want to learn how to use the…
If you want to display only a range of results from a recordset you can using paging (otherwise known as pagination) to do so. It is a common pattern when doing web development to give the user 20 results for example and then the ability to move to the next page. If you are…
Secrets Of FireDac: Last Inserted Auto Generated Id And Enterprise Connectors
August 30, 2018
A common pattern when inserting data into a database table which has an auto increment field set on it is to use an SQL query to select the last inserted ID of the newly created record. Once you use your TFDQuery to run your INSERT query you can run this second query to get…
Secrets Of FireDAC: Dynamic Where Clause Using Conditional Substitution Macros
July 19, 2018
If you are using FireDAC and building your SQL queries manually you may be using more verbose code than is needed. FireDAC has a feature called Macros which allows you to do a variable substitution in your SQL query similar to parameter substitution but for raw SQL. However, in addition to macro substitution you can combine it with conditional substitutions which lets you do the real magic.
If you…
Author: John D7279
////
class function ExcelToJson(cells: TRect; excel_filename, sheet_name: String):TJSONObject;
It is a code for excel to JSON.
////
class function TExcelToFireDAC.ExcelToJson(cells: TRect; excel_filename, sheet_name: String): TJSONObject;
const
…
