Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.


Welcome, Guest
Guest Settings
Help

Thread: A question for SQL Server Experts: Delphi database access


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
A question for SQL Server Experts: Delphi database access  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 15, 2018 11:29 AM
Greetings

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, table.post, 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
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02