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 describes the first session: How To Make MySQL Your SQL. The second session is tomorrow (December 21st 2022) and there is a…
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…
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 implementing a REST API in RAD Server you might also implement this functionality instead of delivering 2 million rows for…
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…
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
def_excel_application = 'Excel.Application';
var
jres: TJSONObject;
jline: TJSONObject;
ExcelApp…
