community, I have a tickler. In the report with ADO (OLE DB connection) appears next error Error Below you can see partly example of a command. Command There is no syntactic error near the SET keyword. When I manually select an empty string for CLIENT_NUM everything works fine. Is anyone have suggestions?
I tried to change the empty string to 'all' but this doesn`t resolve my problem. In CR UI I tried many times with the default value and without. Maybe it depends on version of the Native Client?
1条答案
按热度按时间ibrsph3r1#
It was a basic error. If I want to use the client number, it works; but if I want to get results for all clients and use an empty string, the parameter must be concluded in single quotes. Like
{?CLIENT_NUM}instead of{?CLIENT_NUM}.