In Chapter 5 we used SQL statements to insert, select, update, and delete data, and in the last chapter we used SQL statements to select data from the State_T table. While the use of in-line SQL statements is great for ad-hoc queries, they are not generally used in production applications. They do, however, have their place in production applications where dynamic SQL statements are to be built and executed. Dynamic SQL statements are SQL statements that are built in your VB code, thus they are generated dynamically at run-time. You typically use If.. Else.. EndIf statements to build the SQL statements needed to retrieve the data that the us..
|
