cplusDBAction 4.2                                                                                        Copyright addoit GmbH 2009

 

 

7.3 View with Group By (code from clsDBGenType::clsDeclarationView3)

 

“GROUP BY” and “HAVING” statements are also supported (as seen in Picture 45: A View with WHERE and GROUP BY statements ).

 


Picture 45: A View with WHERE and GROUP BY statements

 

However, there will always be some special SQL views not compatible with all database providers. Therefore, always test your views on all database providers, should they be more complex than the code samples shown in the above sections.

 

 

 

Related Topics

7 Views Support


Copyright (c) 1998-2009 addoit GmbH, All Rights Reserved.

www.addoit.com                                                                                                          Page 1 of 52