We have Bp code next number series automatically through FMS query.
Its working fine for long time but Suddenly my fms is not working. How to solve this issue.
SELECT CASE $[OCRD.CARDTYPE]
WHEN 'C' THEN 'C'
WHEN 'S' THEN 'S'
WHEN 'L' THEN 'L'
(SELECT RIGHT('0000000' + LTRIM(RTRIM(CAST((SELECT MAX(Right(CardCode,6)) + 1
FROM [OCRD] WHERE CARDTYPE = $[OCRD.CARDTYPE]) AS CHAR))), 6))