Once you have created an adapter and some adaptermappings for the adapter, you can use the adapter to interact with your datasource. The ADO Adapter currently generates SELECT, INSERT, and UPDATE SQL statements.
Example 2.15. Using The ADO Adapter
'get a adapter from our form object
set hAdapter = hASPForm.Adapters("sample")
'get an insert statement
sSQL = hAdapter.getInsertSQL
'get an update statement
sSQL = hAdapter.getUpdateSQL
'get a select statement
sSQL = hAdapter.getSelectSQL
NOTE : this does not generate any criteria for you application, you simply concatenate this to the returned string