[Sqlpp-devel] (no subject)

[Randy D. <ra...@ho...>]

		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.