|
Choosing
datasource tables and views to build ASP code
After you successfully connected to database,
check off all datasource tables you'd like to build ASP code for.
After that highlight one of selected tables and step through other
screens in ASPRunner adjusting settings for selected table. You can
always see name of currently selected table in the middle of blue
info pane.
To switch between selected tables use Table
list button on the left.
 
If you'd like to keep default settings for the
rest of tables jump to Output
directory tab and build ASP code.
Using Add
new table
window you can add a new table to existing database.
For each field type name,
type, size, scale (applies to DECIMAL datatype in SQL Server, Oracle
and MySQL only). Set the Primary key field. Databases created with
ASPRunner will be saved into C:\Program
Files\ASPRunnerPro\database.mdb (database1.mdb, database2.mdb etc.)
 NOTE:
Don't change table settings after you've built the project
and added data records. All data will be lost after table modification.
To edit or delete tables right click on the table name in the list.
Add
table view
This feature
creates an additional view of the same table. This feature is useful
when you like to present several views of the same data.
Example:
Table Cars
shows all cars in the database. SQL query: Select * from Cars.
View Active
listings displays active
listings only.
SQL Query: Select
* from Cars where status='active'
View Closed
listings displays closed
listings only. SQL Query: Select
* from Cars where status='closed'
SQL query can
be modified later on SQL query
tab in ASPRunner.
|
