Frequently Asked Questions

Home

Demo

FAQ

Support

System Requirements

Download

Pricing/Order

 

 

 

 

Q1: What happens to my Database when i run nTierASP?
Q2: What is the best environment for using nTierASP?
Q3: How to add my code in VB classes and ASPs generated by nTierASP?



Q1: What happens to my Database when i run nTierASP?
A:
  • After connecting to a Database, nTierASP could execute Existing Stored Procedures, in order to find out about any Recordset that may come up from Stored Procedures.
    Execution of Existing Stored Procedures MAY CHANGE TABLE DATA, depending from the actions that a Stored Procedure can take. If you allow nTierASP to execute Existing Stored Procedures, you must also provide parameter values for these Stored Procedures.
  • It creates a Table with the name tblXFieldName. In this table nTierASP stores table names and column names of all user tables in the Database. tblXFieldName is used later from nTierASP to create ASPs with labels you want to.
    Values of tblXFieldName can be edited. The ENFieldName column of table tblXFieldName should contain the coresponding value labels of FieldName column you want to be displayed in ASPs.
  • If Execute Stored Procedures To SQL Server (overwrite) from properties is selected, nTierASP Creates Stored Procedures first in the local drive and then on the SQL Server overwriting Stored Procedures with the same name without a warning.

Allways use nTierASP in a test-PC.
Top


Q2: What is the best environment for using nTierASP?
A: The best choice for using nTierASP is a test-PC with the following:
  • MS Windows 2000 Server with SP2 or MS Windows NT 4.0 Server with SP6a, depends on what platform is the target/live PC
  • MS SQL Server 2000 or MS SQL Server 7.0 SP3
  • MS Visual Basic 6.0 with SP5
  • and a good HTML Editor like Allaire's HomeSite 4.x to edit ASPs.
See also System Requirements
Top


Q3: How to add my code in VB classes and ASPs generated by nTierASP?
A: In VB Classes and ASPs generated by nTierASP you can find these comments:
'Don't Delete Or Edit these 2 lines
'nTierASP User Defined Code - Start


<Your User Defined Code goes here>


'Don't Delete Or Edit these 2 lines
'nTierASP User Defined Code - End
You can add your User Defined Code here.
You should NEVER add code above or bellow the comment lines and you should NEVER edit the comment lines.
When you run again nTierASP for the same Database, all of the code is replaced except User Defined Code.
e.g.
'Don't Delete Or Edit these 2 lines
'nTierASP User Defined Code - Start

Public Function LookUp_CategoryID(ByVal CategoryID As Long) As ADODB.Recordset
On Error GoTo Err
    If IsEmpty(m_Conn) Then Exit Function
	.........
	.........
    Set LookUp_CategoryID = adoRS
    Set adoRS = Nothing:    Set adoParam = Nothing:     Set adoCmd = Nothing
    Exit Function
Err:
    Err.Raise Number:=vbObjectError, Source:="Northwind.CategoriesDC", Description:=Err.Description _
	& " *** Method: LookUp_CategoryID - Class Module: CategoriesDC"
End Function



'Don't Delete Or Edit these 2 lines
'nTierASP User Defined Code - End
Top

©2003 - 2010 DeMaria.gr. All rights reserved.