|
After you successfully connected to the 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
ASPRunnerPro 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 pane on the left.
Using Create 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 ASPRunnerPro will be saved into
C:\Program
Files\ASPRunnerPro6.2\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
ASPRunnerPro.
Synchronize
database
Every time you make changes to the database in ASPRunnerPro
(e.g. you create new table or view, you add or edit table fields
etc.), these changes should be implemented in the database. In
other words, the structures of the database and ject should be
synchronized.
To synchronize database, right-click tables tree or blank area
near tables tree and select Sync
database.
Note: As from
ASPRunnerPro 6.1 database synchronization should be implemented
manually. In ASPRunnerPro 6.0 and earlier database synchronization
was implemented automatically.
|
