SAP BUSINES ONE-Query Generator Parameter Error

[former_member858913]

Hello every one,

i have this query:

SELECT T0."Code", T0."U_CMC_PO_Matr", T0."U_CMC_PO_EmpNam", T0."CreateDate" FROM "@CMC_PO_OBUL" T0 WHERE T0."CreateDate" >='[%0]'

Note that @CMC_PO_OBUL is a User Defined Table.

in this case there is no prompted area poping up when i excute the query but this error is showing up:

Please Help

[Johan_Hakkesteegt]

Hi,

Please remove the single quotes on both sides of the parameter prompt.

So '[%0]' should be [%0]

Regards,

Johan

[former_member858913]

hello, thank you for your reply

i tried to remove them but still the same error

[Johan_Hakkesteegt]

Does the CreateDate field have the correct data type (i.e. date / datetime)? Also, is the field name correct? What I mean is, is the field name CreateDate or is it U_CreateDate?

[former_member858913]

CreateDate field have Date as data type and the field name is also correct

[Johan_Hakkesteegt]

Could you please test this query:

SELECT T0."Code", T0."U_CMC_PO_Matr", T0."U_CMC_PO_EmpNam", T0."CreateDate" FROM "@CMC_PO_OBUL" T0