Language selection on BP form (134)

Ronald van Amelsvoort

For the language selection I made a Query (SELECT T0.LangCode FROM OCRD T0 WHERE T0.CardCode = [%CardCode]) and saved it in the SWA_LD_Language setion.

On the printdefinition, is select this query. Tryanig to print, i get the message 'Invalid Collum Name' when the CardCode is contains alphnumeric character.

Cardcode 1 --> Everything ok
CardCode d150848 --> Error.

See also the screenshot.

What do i have to change to make this work?
Ronald.


Attachment
[url=http://www.coresystems.ch/wp-content/../wp-content/forum-image-uploads/r-amelsvoort/Invalid colum name.jpg]Invalid colum name.jpg[/url]

Philipp Emmenegger

Hi Ronald

Did you try it this way:

SELECT T0.LangCode FROM OCRD T0 WHERE T0.CardCode = '[%CardCode]'

Ronald van Amelsvoort

Philipp,

This is the solution.


Thanks for the Help.


Ronald.