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 RonaldDid 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.
0
Please sign in to leave a comment.
Comments
0 comments