Subscribe to this list via RSS Blog posts tagged in FireDAC
New in 10.2: Editing Data in TFDMemTable at Design-Time The new Delphi 10.2 Tokyo (and corresponding C++Builder and RAD Studio version) has been released and it has many new smaller and bigger features. Clearly the biggest, most visible new thing is the new Delphi Linux 64-bit compiler and the capability to build server-side apps with Delphi. It did not take too long for the first Delphi developers to start playing with building GUIs for Linux with Delphi FireMonkey. One of my favourite new features in Delphi 10.2 is the possibility to edit data i...

Posted by on in Blogs
Cool App Contender: Change-Pro for Excel How long do you spend looking for changes in an Excel spreadsheet? Compare in seconds! If you only spend an hour a day (220 hours/year) on reviewing and modifying Excel spreadsheets, Change-Pro for Excel will save you 50% –75% of your time. Be more productive and deliver greater value.  Reduce your frustration of never being sure that you know exactly what you’re looking at with the document in front of you. Litera has created a unique app that is built using Embarcadero technology that inc...
FireDAC TFDMoniFlatFileClientLinkを使ったLOGの吐き出し方法[JAPAN] 毛利です。   FireDACにはDB側とTFDConnection間のやりとりをしている内容をLOGとして保存する機能がありますのでご紹介します。 まずTFDConnection, TFDQuery, TDataSource, TDBGridを使いクエリーをグリッド表示します。 今回 TFDConnectionの接続先はInterBaseです。 コードは1行もありません。全てコンポーネントのプロパティ設定のみです。 TFDConnection, TFDQuery, TDataSource, TDBGridの4つコンポーネントを配置後 FDConnection1コンポーネントをダブルクリックし接続設定します。 その後上の図のようにコンポーネントの設定をします。 FDQuery1.Connection に FDConnection1、DataSource1.DataSet に FDQuery1、DBGrid1.DataSource  に DataSource1を 設定します。 FDConnection1のConnectedプロパ...
FiremonkeyでREST JSONファイルからTFDMemTableを更新しデザイン画面でデータセット編集[JAPAN] 毛利です。 Delphi / C++Builder 10.2 Tokyoの新機能としてTFDMemTableデザイン時に編集できるダイアログが追加されました。 TFDMemTableをフォームに配置後、右クリックで[データセットの編集]項目が出てきます。 ですが、何も入っていないのでエラーになります。 まずはRESTでJSONを取得TFDMemTableに取込み、データセット編集を試してみたいと思います。 TRESTClientとTRESTRequest, TRESTResponse, TRESTResponseDataSetAdapter, TFDMemTable を配置し それぞれをプロパティで接続しました。 TRESTClientのBaseURLにシンプルなJSONで返信が返るURLを設定します。 次に、ビジュアルバインディング画面でFDMemTable1を右クリックし、新規コントロールにリンク TGridを選択してOKをクリックします。 デザイン画面上にTGridが配置されるので AlignをClientに設定します REST...

Posted by on in Blogs
Delphi 10.2 "Tokyo" has been released! Great news to all Delphi and C++Builder developers! RAD Studio, Delphi and C++Builder 10.2 "Tokyo" have been released and are now globally available with plenty of new features! It is late evening here in Amsterdam, but I'm excited installing brand new version of RAD Studio into a clean, already prepared Win10 x64 VMWare virtual machine. I think it will last for quite some time! Clearly the biggest new feature in Delphi 10.2 is the capability to build Linux server-side applications. Next week...
"Accessing Databases with Delphi and FireDAC" webinar, Weds, March 22nd On Wednesday, March 22nd, 11am CET, I have presented one hour, demo-oriented, developer webinar about FireDAC. FireDAC is the best database access library available in Delphi, C++Builder and RAD Studio! During the presentation the focus was on new and improved FireDAC features in upcoming RAD Studio 10.2 Tokyo release. Different database access framework libraries available in RAD Studio were discussed, working with Data Explorer, configuring database connection and working...
RAD Server EMS Package to get data from a remote database through a REST API call and display the data on an EMS Client application. Embarcadero's Enterprise Mobility Services (EMS) is a turnkey middleware solution, part of RAD Server that supports secure, encrypted communication using an industry-standard REST interface. With built-in support for users and groups, EMS is a perfect platform for exposing your custom REST endpoints to a wide range of authorized clients. Developers will especially appreciate the ease with which corporate data and features can be securely accessed from mobile clients, which normally lack th...

Posted by on in Blogs
RAD Studio 10.2 Preview in Warsaw, Poland I'm just back from Warsaw, my home city, where I met 90 enthusiastic Delphi and C++Builder developers on the "RAD Studio 10.2 Tokyo Preview" presentation. It is always nice to do the presentation in Polish, and meet friendly faces. As always the event was perfectly organised by BSC Polska, Embarcadero representative for Poland. The queue during the break and after the presentation to ask questions and have a quick chat is always a good sign, that the presentation was well received. Similarly to...

Posted by on in Blogs
Cool App Contender: Preschool It doesn’t matter where you live in this complex world but, when your child is ready for preschool, the fears and sense of discomfort overwhelm every parent at some point. How do you know what your child is being taught? Is what your child being taught the right thing in your mind? The people at Cube Development think it’s vital for South African preschoolers and their parents to have answers to their questions and a way of tracking the activities in the classroom. Preschool Link developed ...
How to make RESTful WebBroker using C++Builder C++Builder Professional Edition and up has WebBroker included.  With that WebBroker you can easily make a RESTful server, or you can use RAD Server with it's built in RESTful server support. For RESTful input, Resource and Suffix are expressed on the URL side. This article shows how to make a stand-alone RESTful WebBroker on Windows 64-bit. (This article was translated to English. Some of the grammar isn't perfect, but you will get general the idea.)

Check out more tips and tricks in this development video: