Error message: types are not compatible

Former Member — Sun, 10 Jan 2021 10:06:08 GMT

Guys, the coding'd be as blew: and issue an error: The type of "S031~Spmon" or the result type of the function. "S031~Spmon" and the type of "S_ZYEAR" are not compatible for the operation in question.

What should I do?

thanks!

Select - options:
  S_ZYEAR for S031-Spmon.

Select ~
Inner join S031
        on S031~SPMON = @S_ZYEAR.

Re: Error message: types are not compatible

abo — Sun, 10 Jan 2021 10:23:06 GMT

"select option" is just a "range", which is a table with a given structure.

You cannot join on a range, only on a database table.

Perhaps you should use:

WHERE spmon in S_ZYEAR

topic Error message: types are not compatible in Application Development and Automation Discussions

Error message: types are not compatible

Re: Error message: types are not compatible