Hello,
i have a problem. I had created a new Integration Library and add a Query Script Generator. I set the Provider to MySQL Server Provider, set the correct Connection string. The Connection Test succeeded. When i write the following SQL Syntax "SELECT * FROM mwd_artikel WHERE ab_nr_15 = @test" and click the Button Find Query Parameters, i cant find no Variable. If i change the Provider to SQL Server Provider he find the Variable "test". If i change back to MySQL Server Provider and click "Find Query Parameters" he cant get the Variable :( I hope somebody can help me :/
Greets from Germany
I can't offer help on why it isn't found when selecting MySQL, but I wonder if you can find it using SQL first, then switch it to MySQL, then compile the project without clicking 'find query parameters' again?
The delimiter to catch variables might be different. Try using ? instead of @
Thank you very Much. With ? instead of @ it works perfectly :)