Subscribe to this list via RSS Blog posts tagged in SQL

Posted by on in Enterprise
Interbase Generator 応用1[JAPAN] Interbase generator一覧を取得 generatorは “RDB$GENERATORS"ここに入っています。 select * from RDB$GENERATORS; この方法でgenerator一覧の取得が可能です。 1つのgeneratorデータを取得 “gen_id([ジェネレータ名],0)"で取得できますが上記のRDB$GENERATORSを使って取得する事も可能です。 RDB$GENERATORSをselectで呼ぶ事も可能 select gen_id([ジェネレータ名],0) from RDB$DATABASE; --もしくは select rdb$generator_id from RDB$GENERATORS where rdb$generator_name='[ジェネレータ名]'; オラクルの場合DUALが使えるがInterbaseはDUALがありません。RDB$DATABASEを代用します。 generatorを設定 generatorをセットする場合 SET GENERATOR [ジェネレータ名] TO...

Posted by on in Enterprise
Interbase Generatorの使い方[JAPAN]   Interbaseはジェネレータを持っています。 generator 新規作成 create generator sq1 create generatorで"sq1"と言う名称のgeneratorが一つ完成しました。中身は0が入っています。 generatorの番号セット SET generator sq1 TO 1 set generator で“sq1"の中身に1をセットします。 generator呼び出し generatorは自動インクリメントの代わりにも利用できます。 --こんなテーブルを作ったとして create table t1(i1 int); --インサート insert into t1(i1) values(GEN_ID(sq1,1)); GEN_ID()関数を使うと、t1テーブルに1が追加されて"sq1"も1になります。再度上記インサート文を入れるとt1テーブルに追記されますが2が入り"sq1"も2になります。自動インクリメントのような動きが作れます。 他の方法として、ストアドプロシージャ + トリガー...
InterBase 2017 - еще ближе к грандам. В тени шумной, но приятной информационной кампании по поводу выхода новейшей RAD Studio 10.2 осталось не менее знаменательное событие - официальный выход СУБД InterBase 2017. Мне бы хотелось исправить этот недочет и пролить свет на ряд новшеств в этой версии СУБД, которые позволяют говорить об огромном потенциале нашего продукта. Начнем с того, что InterBase является основой ряда решений, которые применяются для создания многозвенных систем и работы с Интернетом Вещей (IoT). Это стало возможным...
Database Application Tools for FireDAC that ship with our products - check them out! I received a comment on one of my blog posts from Wilfred Oluoch who was happy to see our renewed focus on development tools. He also said he would like to see a revamped "Database Desktop" style tool that works with InterBase/SQLite and other databases. Thank you Wilfred. We do have several database tools integrated into the IDE and also as standalone applications. Inside of the IDE you can use the Data Explorer to work with your FireDAC and dbExpress based database connections. Outside of...

Posted by on in Data
Newsgroup Nugget: Row-level locking with FireDAC Here is a recent newsgroup post asking about Row-Level locking using FireDAC to talk to SQL databases. Enjoy! Emery asks: I’m working on a project right now that’s presently using FireDAC to connect to PostgreSql, but we are planning on expanding the possible backends to include MS/SQL, MySQL and Oracle as well (with possibly other, not yet identified, alternatives as well). PostgreSql may or may not be in our long-term plans. One of the single most important requirements that I have is the a...
Embarcadero Community Webcast – Episode #5 - February 2, 2015 Embarcadero Community Webcast – Episode #5 Monday Februray 2, 2015 A weekly Embarcadero Community webcast, by David Intersimone "David I", covering recent Embarcadero and Industry news, upcoming events, blog posts, articles and Community Questions and Answers. The recording appears on the Embarcadero YouTube channel.  Episode #5 YouTube URL - https://www.youtube.com/watch?v=N6u-sywhV8Q Developers in China can watch the video on YouKu - http://v.youku.com/v_show/id_XODg1NDY3NTY0.htm...

Posted by on in Programming
CodeRage 9 C++ Track Sessions to Watch You can watch the replays of the CodeRage 9 C++ track sessions on YouTube. These sessions will help you modernize your VCL applications, learn more about multi-device and mobile development using FireMonkey, connect with SQL databases using FireDAC, build enterprise class mobile applications with Enterprise Mobility Services, add speed to your VCL and FireMonkey applications using the new Parallel Programming Library, become a better C++ programmer by learning from some of the industry's top exp...
CodeRage 9 Delphi/Object Pascal Track Sessions to Watch You can watch the replays of the CodeRage 9 Delphi/Object Pascal track sessions on YouTube. These sessions will help you modernize your VCL applications, learn more about multi-device and mobile development using FireMonkey, connect with SQL databases using FireDAC, build enterprise class mobile applications with Enterprise Mobility Services, add speed to your VCL and FireMonkey applications using the new Parallel Programming Library, become a better Object Pascal programmer by learning from som...
Performance Improvements with SQL Server 2014 Whenever there is new model of any vehicle launched in the market, it is expected it should have some enhancements or new features which would make it superior from previous model. If the features are appealing, generally customers are positive and forthcoming to pay little more than previous model. Above theory holds good for SQL Server product as well. It is expected that SQL Server 2014 should have some new enhancements as compared to the predecessor SQL Server 2012 version. In SQL Server 20...
Developer Direct 2014 Mobile School: Lesson 4 Slides and Replays Wednesday, July 16, 2014: Lesson 4 - Building Powerful Multi-tier, Multi-device Applications using DataSnap REST/JSON This lesson will show you how to create multi-tier applications (in some cases with zero lines of code) that work with your mobile applications. In this lesson, you will learn how to create middle-tier server applications containing business logic and access to remote enterprise SQL databases. This lesson will also show you how to use the same MastSQL.GDB database in the midd...

Check out more tips and tricks in this development video: