Filter Results III: Create Parameterized SQL Statements
In a previous example, the SQL Statement was hardcoded to return summary data for only the Smith Divorce Case. Often, you will want to let the user specify the case. This issue strays into two important areas of database application development. Obviously, it is an issue for the database. It is a user-interface development issue as well. Issues regarding user interface are addressed in Part V, “Putting Your Database to Work—Building a Simple Access Database Application,” of this book. The issues regarding how the database deals with these “dynamic” SQL statements will be addressed now.
SQL statements that require immediate user input are known as parameterized queries. The SQL Statement ...
Get Absolute Beginner’s Guide to Databases now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.