![]() The SQL used in a ADOQuery component must be acceptable to the ADO driver in use. It is most often used to execute DDL commands or to execute a stored procedure (even though you should use the TADOStoredProc for such tasks) that does not return a result set. Note: even though executing commands using the ADOQuery component is possible, the ADOCommand component is more appropriate for this purpose. The most common statement, however, is the SELECT statement, which produces a view similar to that available using a Table component. These SQL statements can either be DDL (Data Definition Language) statements such as CREATE TABLE, ALTER INDEX, and so forth, or they can be DML (Data Manipulation Language) statements, such as SELECT, UPDATE, and DELETE. The TADOQuery component provides Delphi developers the ability to fetch data from one or multiple tables from an ADO database using SQL. In this chapter of the free database course for Delphi beginners - focus on ADO, we'll look at how you can take advantage of the TADOQuery component to boost your ADO-Delphi productivity. Take a look at how you can take advantage of the TADOQuery component to boost your ADO-Delphi productivity. Chapter seven of the free Delphi Database Course for beginners.
0 Comments
Leave a Reply. |