From: Randy D. <ra...@ho...> - 2004-03-18 15:40:19
|
The question(s) and comments below were transferred from "support request". I am still using sqlpp and I have had few problems with the C++ Libs. I use the multi-column primary and foreign key methods extensively. In fact, I have generated flawless queries with multiple tables having multi-column PK and FK relationships. The problems outlined below began when I generated ASPX, C# code behind and C#. Regards, Randall Davis Previous JD comments: Hi, if you are still using sqlpp it would be nice to discuss such features in the mailing list. You can define multiple primary key without problem. I'll put an example on the wiki. R.D. Question: Summary: Primary Keys Initial Comment: I am using sqlpp to model and QBE using a meta data repository and I have had great success with a few exceptions(spacing around "AND" in joins). I make a few changes and it seems to work fine. I am now testing CS and aspnet generation. I am using release 2.9, XP pro and VS2003. I am new to C# and ASP.NET and the DNN approach to data access, but the problems I am having actually occur due the assumption that primary keys are generated ids or sequences. All of the pk's and fk's in my repository are multi-column and must be input by the user. The CS generator and aspnet generators (implicitly) assume that the pks are generated. Is there a way to get around this assumption? BTW, the control generator generates code to access text boxes that are not created for primary key columns. There is also a problem with this construct // m_RA_IDE_CHANGE_RULE_TBLDataGrid.OnItemCommand= "m_RA_IDE_CHANGE_RULE_TBLDataGrid_Click"; the method is not accessible due to protection level. Booleans should be initialized with true (currently "True"). This gives a string conversion error. |