FireDAC SQLiteで時間を取得すると # select datetime('now') as now_   これだと日本時間で取得できません     'localtime'をつけると、日本時間が取得できます。 # select datetime('now', 'localtime') as now_  ...

Delphiを使ってかんたんにSQLite接続のスマホアプリ作り クロスプラットフォーム開発環境の Delphi を使って、iOS / android 上で動作する データベース接続アプリをつくります。データベース接続の基本的な部分だけを実装して iPhone上で動かすまでの一連の手順をここで紹介します。 使用環境 項目 エディション / バージョン OS Windows 10 Pro, 1607 RAD Studio 10.2 Tokyo, Enterprise Edition macOS Sierra 10.12.5 iOS iPhone7, iOS10.3.2 この記事の手順はRAD Studioのトライアル版で確認することができます。トライアル版のインストールについてこちらの記事をどうぞ 使用するデータベース ： SQLite モバイル・スマホ向けに使用するローカルデータベースとしてSQLiteを使用します。オープンソースデータベースデータベースで、軽量。データベース実体はファイル一つ...

FireDACのTFDBatchMoveを使いデータセットから別のテーブルに簡単に書き込む事ができます。 TFDBatchMove用のコンポーネントは下記です。 この中でTFDBatchMoveDataSetReader, TFDBatchMoveDataSetWriterを試してみました。 TFDBatchMoveDataSetReaderはコピー元になるDatasetを設定 TFDBatchMoveDataSetWriterにはコピー先になる空のDatasetを設定しました。

On Wednesday the 16th I’ll be presenting “Getting Started with Database Applications for Mobile” with Delphi and C++ Builder during the CodeRage XI. Here you can find the samples available for download in our Code Central: http://cc.embarcadero.com/item/30656 And here the presentation with the links and references: http://www.slideshare.net/fernandoluizrizzato/getting-started-with-database-applications-for-mobile Hope you find this useful!...

There are a number of different embedded databases that you can use with Delphi and C++Builder. InterBase ToGo and IBLite are two embedded databases offered by Embarcadero. SQLite is an embedded SQL database engine developed by the SQLite Consortium. And finally there is TFDMemTable which can save and load data from binary, XML, JSON and query through it's LocalSQL property. Each embedded database has it's own strengths and you can quickly deploy any of these solutions with your apps. InterBase...

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 writing and reading from disk on iOS and Android. Lesson 3 Slides You can download the slides (PPTX and PDF) slides for ...

During each day of January 2013, I am creating a new video showing you how to use the new C++Builder XE3 compilers for Win32, Win64 and OSX to create multi-platform, database, multi-tier, HD and 3D applications. In this eighteenth video you will learn how to build the SQLite Windown 64-bit DLL and use SQLite in your your C++Builder XE3 and FireMonkey Windows and Mac HD applications. In my recent blog post, I showed you how to build the 64-bit Windows SQLite3.DLL. Additional SQLite information ...

SQLite database access is now supported using dbExpress in Delphi XE3 and C++Builder XE3.  On the SQLite download page you will find a zip file containing the source code for SQLite 3.x (as of this blog post the verison is 3.7.15.2).  Also on the download page you will find pre-compiled Windows binaries for the SQLite command line shell application and the SQLite Win32 DLL. In order to use SQLite with Delphi XE3 and C++Builder XE3 64-bit applications, you'll need to build a 64-bit version of the...

RAD Studio XE3 now supports using SQLite (version 3.x) databases in your Delphi and C++Builder VCL (Windows) and FireMonkey (Windows and Mac) applications. To connect to a SQLite database, you use the same dbExpress framework components (TSQLConnection and TSQLQuery) that you use for other SQL databases.   This short video shows you how to use the SQLite console application to create a database and then use dbExpress components, the LiveBindings Wizard and LiveBinding Designer to create a FireM...