Tag: cws_src680_qiq User: fs Date: 2006/06/30 07:50:12 Modified: dba/dbaccess/qa/complex/dbaccess/CRMDatabase.java
Log: corrected table name File Changes: Directory: /dba/dbaccess/qa/complex/dbaccess/ ============================================= File [changed]: CRMDatabase.java Url: http://dba.openoffice.org/source/browse/dba/dbaccess/qa/complex/dbaccess/CRMDatabase.java?r1=1.1.2.3&r2=1.1.2.4 Delta lines: +6 -6 ------------------- --- CRMDatabase.java 29 Jun 2006 10:17:40 -0000 1.1.2.3 +++ CRMDatabase.java 30 Jun 2006 14:50:09 -0000 1.1.2.4 @@ -4,9 +4,9 @@ * * $RCSfile: CRMDatabase.java,v $ * - * $Revision: 1.1.2.3 $ + * $Revision: 1.1.2.4 $ * - * last change: $Author: fs $ $Date: 2006/06/29 10:17:40 $ + * last change: $Author: fs $ $Date: 2006/06/30 14:50:09 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -151,14 +151,14 @@ "\"Customers\".\"Name\" AS \"Customer Name\", " + "\"Orders\".\"OrderDate\", " + "\"Orders\".\"ShipDate\", " + - "\"OrderDetails\".\"Quantity\", " + + "\"orders_details\".\"Quantity\", " + "\"Products\".\"Name\" AS \"Product Name\" " + - "FROM \"OrderDetails\" AS \"OrderDetails\", " + + "FROM \"orders_details\" AS \"orders_details\", " + "\"Orders\" AS \"Orders\", " + "\"Products\" AS \"Products\", " + "\"Customers\" AS \"Customers\" " + - "WHERE ( \"OrderDetails\".\"OrderID\" = \"Orders\".\"ID\" " + - "AND \"OrderDetails\".\"ProductID\" = \"Products\".\"ID\" " + + "WHERE ( \"orders_details\".\"OrderID\" = \"Orders\".\"ID\" " + + "AND \"orders_details\".\"ProductID\" = \"Products\".\"ID\" " + "AND \"Orders\".\"CustomerID\" = \"Customers\".\"ID\" )" ); --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
