Using The Adapter

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