Kbase P57924: How to use Progress specific functions in a Microsoft Access query?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
GOAL:
How to use Progress specific functions in a MS Access query?
GOAL:
How to make a Pass-Through query in MS Access?
GOAL:
Why can't I use "PRO_ELEMENT" function in a MS Access query?
FACT(s) (Environment):
Microsoft Access
Progress 9.x
FIX:
MS Access queries are parsed on client side and MS Access cannot understand Progress specific syntax (like PRO_ELEMENT). To define a query that is parsed and executed solely on server side, open it in SQL view and then select "Query" - "SQL Specific" - "Pass-Through". Please note that you have to change the syntax of the query, e.g. prefix tables as "pub." (instead of "pub_"), replace brackets with quotation marks and remove semicolons from the end. Pass-Through query understands functions like PRO_ELEMENT and should also execute faster.