Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.

Welcome, Guest
Guest Settings

Thread: Coding for SQL Server - TFdQuery vs TFdTable

This question is not answered. Helpful answers available: 2. Correct answers available: 1.

Permlink Replies: 0 Threads: [ Previous | Next ]
Mark Anderson

Posts: 38
Registered: 4/22/07
Coding for SQL Server - TFdQuery vs TFdTable  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 27, 2018 6:31 PM

I have been a Delphi developer for many years, and have used many databases. I 'm about to tackle my first SQL Server project.

I use Rad Studio 10.2 Tokyo on a Windows 10 server. I use FireDac for the database components.

I would appreciate someone helping me understand the design ramifications between the following two approaches:

Database access using FDtables, and calling table.findkey, table.edit,, or table.delete methods as opposed to coding sql select, insert, modify, and delete statements.

My understanding (which may be incorrect) is that the edit, insert, and delete methods are simply wrappers around the corresponding sql statements mentioned above.

I've done it both ways, and I don't see a big difference in response time, so I'm hoping for guidance. I want to approach this project with the proper mindset.

Thanks so much

Mark Anderson
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02