In terms of database access the most simple (and most common) Visual LANSA generated application works like this: