2. ASPRunnerPro General questions
  3. distinguish between tables in different schemas
This topic is locked

distinguish between tables in different schemas

 		1/21/2008 6:49:03 AM
ASPRunnerPro General questions
M
 mstx04 author

Hello,
I have a table named Country, and that table exists in several schemas, like this.
[Schema1].[Country]

[Schema2].[Country]

[Schema3].[Country]
I would like to distinguish between these in ASPRunner, and have web pages for each table, because they are logically different.
Suprisingly is the generated output from ASPRunner only webpages for one Country table. Country_List.asp etc. Why isn't the webpages created like Schema1_Country_List.asp etc.? I know i can get around this problem using custom views, but wouldn't it make more sense if ASPRunner distinguish between tables in different schemas automatically?
I am using SQL Server and ASPRunner 5.1 build 327.
Mikael
M
 		mstx04 author 1/26/2008

I would like to add further comments on this topic.
I have a table in default schema called
[dbo].[Country]
with the following columns, Name and Region.
and a view created in a different schema called
[MyView].[Country]
with the following columns, LongName and Continent.
These two tables are both visible in the Datasource tables page. If i select [MyView].[Country] and go to the following page, I can see that the query for [MyView].[Country] is

[codebox]

Select Name, Region

From [MyView].[Country][/codebox]
which is wrong! the definition for [MyView].[Country] select query should be

[codebox]

Select LongName, Continent

From [MyView].[Country][/codebox]
Is this the intended behaviour of ASPRunner?
Regards,

Mikael
Sergey Kornilov admin 1/28/2008

I'm afraid ASPRunnerPro do not support tables that exist in several schemas.