Using variable in SQL statement

[umueglitz]

Hallo,
I try the test version before i purchase a license. Target is to realize one report to check out if all works as we need it. All looks very good but I have a problem to define the Where condition with an variable in the SQL statement. I didn't found an corresponding example in your sample files and in the online documentation I also didn't find and explaination. Potentially I'm wrong but I think there should be such a possibility. I want to define the value in the C# main program and transfer this value to the SQL statement. I used a syntax for the variable {variabl name}, but the SQL assistant reports an syntax error. Can you show me an small example how to handle such an problem.

Thanks in advance for your support.

[umueglitz]

Found the solution by myself. Everything works fine.

[Lech Kulikowski]

Hello

Ok.
Please let us know if you need any additional help.

Thank you.