Welcome back to our series about creating a reminder application in ! C++Builder Our last article discussed , design the user interface by dragging and dropping components, and write code to control some components. how to set up C++Builder If you haven't read: Building Your First App Using C++ Builder (Part 1) This part will integrate SQLite into the application and attempt to store reminders added by users into the database. After adding reminders to the database, we will display reminders to users when they are requested. Fourth Step: Create Database C++Builder allows you to make use of several databases in one program with its FireDAC library. We will integrate our SQLite database into this application. To accomplish this, we need to begin by downloading and installing the SQLite database. Feel free to choose whichever database you want to use. Note that firedac allows you to integrate multiple databases into your application. Once you have downloaded and set up your database, you will need to choose the type of database and link it to your application. Double click on Fdconnection in the design form. This action will open the firedac connection editor. Here you can select the name of the database you intend to use and provide more details about the database. All we need to modify for this simple app is the Driver Id and the location of the database we have created on the desktop (next to the Database tag). After completing this step, we can start writing code to retrieve data from the database and store data collected from the user into the database. We created a database on the desktop located in the following path: C:\\Users\\uk\\OneDrive\\Desktop\\reminderdb.db Fifth Step: Write to Database When we click the add reminder button, we want to take the user's current time, and date selected using the time and DateTime pickers, respectively, and store them into the database. We will need to write some SQL statements to create a reminder table in the database if it does not exist already and insert the date/time values as a string into the database whenever the onClick event is triggered. We have also added a "Show Reminders" button to retrieve reminders from the database and display them in the Memo. Double click on the "Add Reminder" button to create an empty fastcall function for the 'AddReminder' button. In this function, we will make use of our FDConnection to connect to the database. The driver name and path to the database need to be specified. This will help the program identify the location of the database it will be communicating with it. FDConnection1->DriverName = ;
FDConnection1->Params->Values[ ] = ; "SQLite" "Database" "C:\\Users\\uk\\OneDrive\\Desktop\\reminderdb.db" Once this is done, you can write code that will modify, insert, update, delete, or retrieve data from the database. Begin by opening the connection to the database using this command, FDConnection1->Open(); This command goes hand in hand with the close database command, and once we have finished executing all queries, we will need to close the connection to the database using: FDConnection1->Close(); After establishing and opening the communication portal, we will execute an SQL statement to create the reminder table if it does not exist in the reminder database. We need only two fields for the table, i.e., the id field and the DateTime field, stored in string format. To create a table, we can call the ExecSQL statement to execute a SQL query. This ExecSQL function can be called whenever you want to create tables, insert or delete data, but it can't be used if data needs to be retrieved from the database. Add the following statement to create a table if it does not exist in the database. FDConnection1->ExecSQL( ); "CREATE TABLE IF NOT EXISTS Reminder (Id int, time TEXT NOT NULL)" Next, we want to insert the time into the database. We can still make use of the ExecSQL function after retrieving the DateTime value using the code we wrote in the previous part of this article: date =  dateTime.FormatString( );
FDConnection1->ExecSQL( +date+ ); String "dd/mm/yyyy HH:mm" "INSERT INTO Reminder (time) VALUES ('" "')" Sixth Step: Read from Database To retrieve added reminders from the database, double click on the "Show Reminders" button to create an empty fastcall function for retrieving reminders. We will make use of TFDQuery. TFDQuery is used to execute queries and will allow us to make use of result sets. Here's some sample code illustrating how to make use of TFDquery. Here we want to select all reminders from the Reminder table and display them to the user. TFDQuery *query;
query = TFDQuery( );
query->Connection = FDConnection1;
query->SQL->Text = ;
query->Open(); new this "SELECT * FROM Reminder" To make use of TFDQuery the following header needs to be added to your code: , #include <FireDAC.DApt.hpp> Code for outputting retrieved data TVarRec args[ ] = { };
Memo1->Lines->Add(System::UnicodeString::Format( , args,ARRAYSIZE(args) - )); (!query->Eof) {
TVarRec [ ] = { query->FieldByName( )->AsString};
	Memo1->Lines->Add(System::UnicodeString::Format( , , ARRAYSIZE( ) - ));
	query->Next();
} 1 "time" "|%25s |" 1 while arguments 1 "time" "|%-25s |" arguments arguments 1 When all the different sections of code shared are added together, we get the following program: #include <FireDAC.DApt.hpp> __fastcall TForm2::buttonAddReminderOnClick(TObject *Sender)
{
    TDateTime dateTime;
	ReplaceDate(dateTime, DateTimePicker1-> );
	ReplaceTime(dateTime, TimePicker1->Time);
	Memo1->Text = ;
	FDConnection1->DriverName = ;
	FDConnection1->Params->Values[ ] = ; {
		FDConnection1->Open();
		FDConnection1->ExecSQL( ); date =  dateTime.FormatString( );
		FDConnection1->ExecSQL( +date+ );
		FDConnection1->Close();
	} (Exception& E)
	{
		Memo1->Text = E.Message;
	}
} __fastcall TForm2::buttonShowReminderOnClick(TObject *Sender)
{
	FDConnection1->DriverName = ;
	FDConnection1->Params->Values[ ] = ; {
		FDConnection1->Open();
		TFDQuery *query;
		query = TFDQuery( );
		query->Connection = FDConnection1;
		query->SQL->Text = ;
		query->Open();
		TVarRec args[ ] = { };
		Memo1->Lines->Add(System::UnicodeString::Format( , args, ARRAYSIZE(args) - )); (!query->Eof) {
		  TVarRec [ ] = { query->FieldByName( )->AsString};
		  Memo1->Lines->Add(System::UnicodeString::Format( , , ARRAYSIZE( ) - ));
		  query->Next();
		}
		query->Close();
		FDConnection1->Close();
	} (Exception& E)
	{
		Memo1->Text = E.Message;
	}
} void Date "" "SQLite" "Database" "C:\\Users\\k_umm\\OneDrive\\Desktop\\reminderdb.db" try "CREATE TABLE IF NOT EXISTS Reminder (id INTEGER PRIMARY KEY AUTOINCREMENT, time TEXT NOT NULL)" String "dd/mm/yyyy HH:mm" "INSERT INTO Reminder (time) VALUES ('" "')" catch //--------------------------------------------------------------------------- void "SQLite" "Database" "C:\\Users\\k_umm\\OneDrive\\Desktop\\reminderdb.db" try new this "SELECT * FROM Reminder" 1 "time" "|%25s |" 1 while arguments 1 "time" "|%-25s |" arguments arguments 1 catch Seventh Step: So far, we have built a mini reminder app that gets input from the user and stores it in the database. Our users will also expect to receive notifications during the specified periods. FireDate is supported by Android, macOS, and iOS. It can be used by passing information about the date and time when the notification should be triggered. MyNotification->FireDate = System::Dateutils::EncodeDateTime( , , , , , , ); 2015 12 16 17 30 00 00 You can find more information about how to make use of notifications in your application : here For some sample code that you can refer to, . click here

The Best Reasons to Adopt a Security-First Approach

Building Your First App Using C++ Builder (Part 1)

Check out the blog!

Nominated for 2022 - HackerNoon Contributor of the Year - Developer

Nominated for 2022 - HackerNoon Contributor of the Year - Distributed Systems

Nominated for 2022 - Software Developer of the Year

Nominated for 2022 - HackerNoon Contributor of the Year - App Development

Nominated for 2022 - HackerNoon Contributor of the Year - Mobile

Too Long; Didn't Read

Make resilience your competitive advantage

Building Your First App Using C++ Builder (Part 2)

Building Your First App Using C++ Builder (Part 2)

About Author

Comments

TOPICS

THIS ARTICLE WAS FEATURED IN

Related Stories

Untitled Story

Which C++ Builder Should I Use?

18 Best Productivity Apps For Remote Workers

15 Most Useful Tools for Software Devs in 2021

3 Ubuntu Alternatives for better User Experience

5 Handy Apps for Boosting Productivity During a Workation

Which C++ Builder Should I Use?

18 Best Productivity Apps For Remote Workers

15 Most Useful Tools for Software Devs in 2021

3 Ubuntu Alternatives for better User Experience

5 Handy Apps for Boosting Productivity During a Workation

Light-Mode

Classic

Newspaper

Dark-Mode

Neon Noir

Minty

HN StartUps