This topic is locked

2 Menu-entries for the same table ??

1/23/2005 3:03:26 PM
ASPRunnerPro General questions
Pfeiffer author

Hello,
normally i can construct the table,edit,view.... pages related to ONE table in the list.

Because of different views I need the possibility to create two different views on the same table, but I found no way to do so.
Is is possile ??
Best regards

Uwe Pfeiffer

Sergey Kornilov admin 1/24/2005

Uwe,
I would recommend to create an additional view for this table in SQL Server and use this view as a datasource in ASPRunnerPro.
CREATE VIEW vw_TableName AS SELECT * FROM TableName

Pfeiffer author 1/28/2005

I'm not quite sure wether I can update filed in a view (MySQL) and

use the view like a normal table.... ??

Sergey Kornilov admin 1/31/2005

Uwe,
I'm sorry you cannot do this with older MySQL versions. They have added this feature recently.
Also this feature available in MS Access and SQL Server.