PowerQuery- ODBC SQL中的动态参数

发布于 2025-02-01 17:25:26 字数 864 浏览 2 评论 0原文

我正在尝试另一种方法来解决一个类似的问题，我问过以前;我设法在PowerQuery编辑器中创建了一个动态参数，该参数显示在Excel表中输入的日期值。日期参数的高级编辑器如下所示：

(
let
Source = Excel.CurrentWorkbook(){[Name="DATE_RANGE"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"START_DATE", type date}, {"END_DATE", 
type date}}),
START_DATE = #"Changed Type"{0}[START_DATE]
in
START_DATE
)
meta [IsParameterQuery=true, Type="Any", IsParameterQueryRequired=true]

参数名称为“ StartDateValue”。

现在，尝试在我的obdc 中尝试使用此参数值，其中条款我尝试了以下内容：

WHERE A."CREATED_DTM" = :StartDateValue

这使我拥有“ ora-01008：并非所有变量绑定”错误代码。。我将如何在我的子句中获得此参数值，而我缺少什么？

原文

I'm trying a different approach to a similar question I've asked previously; I have managed to create a dynamic parameter in my PowerQuery Editor which displays a date value entered in an Excel table. The Advanced Editor for the Date Parameter looks like this:

(
let
Source = Excel.CurrentWorkbook(){[Name="DATE_RANGE"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"START_DATE", type date}, {"END_DATE", 
type date}}),
START_DATE = #"Changed Type"{0}[START_DATE]
in
START_DATE
)
meta [IsParameterQuery=true, Type="Any", IsParameterQueryRequired=true]

The parameter name is "StartDateValue".

Now, trying to use this parameter value in my OBDC WHERE clause I have tried the following:

WHERE A."CREATED_DTM" = :StartDateValue

Which leaves me with a "ORA-01008: not all variables bound" error code. How would I get this parameter value to work in my clause and what am I missing?

分享到QQ

分享到微博