To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102277 Issue #|102277 Summary|QUERIES AND TABLES Component|Database access Version|OOo 3.0.1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|kimpoy69
------- Additional comments from [email protected] Wed May 27 05:21:41 +0000 2009 ------- Problem on queries 'incorrect syntax near ':'. I'm using direct SQL QUERY on sql server and use it as another query and other table but can't use the parameter query on the criteria. only when I directly enter date it is functional. this is my query SELECT "BASIS FOR REPORT"."dt_date" AS "date", "BASIS FOR REPORT"."SHIFT", "BASIS FOR REPORT"."QTY", "piecerate_table"."coop_rate", "piecerate_table"."member_rate", "BASIS FOR REPORT"."QTY" * "piecerate_table"."coop_rate" AS "coop due", "BASIS FOR REPORT"."QTY" * "piecerate_table"."member_rate" * "BASIS FOR REPORT"."FACTOR" AS "MEMBER DUE", "BASIS FOR REPORT"."QTY" * "piecerate_table"."member_rate" * "BASIS FOR REPORT"."FACTOR" * .083 AS "NTH ALLOC", "BASIS FOR REPORT"."QTY" * "piecerate_table"."coop_rate" * .01 AS "SERVE FEE", "piecerate_table"."category" AS "CATEGORY" FROM "jfipaydata"."dbo"."piecerate_table" AS "piecerate_table", "BASIS FOR REPORT" AS "BASIS FOR REPORT" WHERE "piecerate_table"."s_sku_code" = "BASIS FOR REPORT"."SKU" AND "BASIS FOR REPORT"."dt_date" BETWEEN :dt_from AND :dt_to --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
