この記事は Eli M. による Secrets Of FireDac: Last Inserted Auto Generated Id And Enterprise Connectors の抄訳です。  自動インクリメントフィールドがあるテーブルにデータを挿入するとき、一般的にはSQLクエリを使用して新しく作成されたレコードの最後に挿入されたIDを取得します。TFDQueryを使用してINSERTクエリを実行し、続いて、SELECTクエリを実行すれば、新しく挿入された自動インクリメントIDを取得できます。 異なるデータベースには、これを実現するために異なるSQLクエリがあります。 たとえば、MySQLには、LAST_INSERT_ID（例：SELECT LAST_INSERT_ID））という名前で実行できるSELECTクエリ関数があります。 このSELECT文を直接実行するか、FireDAC内蔵の機能を使用することができます。 FireDACには、GetLastAutoGenValueというTFDConnectionコンポーネントから呼び出すことのでき...

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 the newly inserted auto increment ID. Different databases have different SQL queries to accomplish this. MySQL for example has a SELECT query function that you can run called LAST_INSERT_ID() (example: SELECT LAST_INSERT...

CodeRage XII was great! Plenty of contents and great fun. It was not the first time I have been doing a session on using Delphi Cloud API to integrate with Amazon Simple Storage Service (S3). This year I thought it would be cool to go a little bit further and implement custom "TAmazonS3" component to make it easier to work with Amazon S3 in Delphi. Cloud API is a set of classes implemented in Delphi that provide access to storage, queue and table services in both...

You’ve probably been at a restaurant and knew music was playing in the background but, not the music you wanted to hear. So, you just tuned it out rather than listen to it. Well, SoundJuke from Trend Music is a game changer in that regard. It puts full control over the music you hear on a dashboard hosted on your smartphone. You can compose a personal playlist through SoundJuke or use one of the standard playlists that the app shows. These prepared playlists are updated periodically, so you’re n...

In a moment my "Amazon Web Services with Delphi" CodeRage X session is starting. I'm very excited and the sessions so far were very good. It is still 2 and half more days to go! The source code for the demos shown during my AWS Delphi session has been uploaded to Embarcadero Code Central for you to have a look and enjoy! You can download all demos from http://cc.embarcadero.com What is cloud computing? "Cloud Computing"refers to the on-demand delivery of IT resources and applications via the ...

In RAD Studio XE8 we added new components to support the platform native HTTP/HTTPS libraries on all targeted platforms. I covered additional security programming details in my blog post "The RAD Studio XE8 Summer (Northern Hemisphere) and Winter (Southern Hemisphere) of Security!" We also updated Enterprise Mobility Services (EMS) to use the new native libraries so that you did not have to use OpenSSL. The Native HTTP libraries on multiple devices. and EMS use the new http://docwiki.embarc...