Hi there, I am another new addition to jdbforms-interests, and I'ld like to express my gratitude to the creators of DbForms at this point, it's an excellent piece of software. :)
Anyway I was experimenting with DevGUI and views on MS SQL Server, and I encountered a problem autodetecting the primary keys of views (I guess because views have no PKs, tables do). Nontherless DevGUI offers the option to detect the views, which should then detect and behave just like tables. Is there a (non-database-specific) way to determine the "PK column" of a view, which is in fact the PK column of the table the view is selecting from (assuming the view is selecting from just one table)? I am fairly sure this can be done in a database-specific way, but I don't really want to mess with MS SQL Server's deep and ugly internals. Any ideas? Sebastian Scheible FEINGUSS BLANK GmbH Industriestra�e 18 D- 88499 Riedlingen Tel: 0049 (0) 7371 / 182-306 Fax: 0049 (0) 7371 / 182-44-306 ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
