StiMobileDesigner - sql with parameters

[FrenkR]

Hi,
I have defined a valid SQL with 2 parameters(@orno, @cntn), added 2 parameters(first one is type text, size 9, second one is type int). In expression, I set expresion to {'100000013'} for a first one and {1} for a second one.
When I clicked "retrieve data", I got a dialog "SQL expressions" that requested parameter values from me. After entering parameter data(don't know why is this necessary?), I see only "wait" image(rotating circle)

If I define SQL without parameters, data are returned without any problems.

Looks like parametrers are not working. Also "expression" field is very small and has no drag/drop possibility to set or link value of parameter.
ver: 2015.2

Rgds,
Frenk

[Alex K.]

Hello,

Can you please send us your report which reproduce the issue for analysis.

Thank you.

[FrenkR]

hi,
I can't save dataset with parameters because i get "busy" rolling circle in the middle. Connection to DB is MSSQL. I prepared printscreens:

_par1.png (13.88 KiB) Viewed 3719 times

SQL in green (withaout "where" part)executes perfectly and returns data. After adding data, I defined 2 parameters one string and one int.

_par2.png (11.93 KiB) Viewed 3719 times

When clicking "OK" I am just getting "busy screen", as on picture:

_par3.png (10.93 KiB) Viewed 3719 times

.
After some time(e.g. 5 mins), "busy" screen dissapears without any message.

[HighAley]

Hello, Frenk.

You shouldn't use Braces {} in Expression.
You should use double quotes when you set string value.

Also we have noticed that the Designer hangs and we need make an improvement.
The fix will be available in our next prerelease build.

Thank you.

[FrenkR]

when applying fix, can you please add button for selecting expression as is in other designers? It will help a lot.

regarding brackets, I was not sure but I tried all versions(single quoted, double quoted, inside brackets) and neither worked. Thank you for this info.

[Alex K.]

Hello,

The issue is fixed. The fix will be available in the next build at this week.
Also for the string values in the expression you need use double quotes - "100000013"

Thank you.

[FrenkR]

can I get this patch immediately, please? It is a showstopper for me.

[Andrew]

Frank,

Please send a request to support@stimulsoft.com asking for the patch. We will prepare this for you.

Thank you.

[FrenkR]

updated to latest beta. Parametric search now works. Thanks.

[HighAley]

Hello.

We are always glad to help you.
Let us know if you need any additional help.

Thank you.