Page 1 of 1
StiMobileDesigner - sql with parameters
Posted: Mon Oct 19, 2015 1:01 am
by 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
Re: StiMobileDesigner - sql with parameters
Posted: Mon Oct 19, 2015 6:35 am
by Alex K.
Hello,
Can you please send us your report which reproduce the issue for analysis.
Thank you.
Re: StiMobileDesigner - sql with parameters
Posted: Mon Oct 19, 2015 6:56 am
by 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 3720 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 3720 times
When clicking "OK" I am just getting "busy screen", as on picture:
- _par3.png (10.93 KiB) Viewed 3720 times
.
After some time(e.g. 5 mins), "busy" screen dissapears without any message.
Re: StiMobileDesigner - sql with parameters
Posted: Mon Oct 19, 2015 7:24 am
by 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.
Re: StiMobileDesigner - sql with parameters
Posted: Mon Oct 19, 2015 12:57 pm
by 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.
Re: StiMobileDesigner - sql with parameters
Posted: Mon Oct 19, 2015 1:30 pm
by 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.
Re: StiMobileDesigner - sql with parameters
Posted: Tue Oct 20, 2015 9:47 am
by FrenkR
can I get this patch immediately, please? It is a showstopper for me.
Re: StiMobileDesigner - sql with parameters
Posted: Tue Oct 20, 2015 12:48 pm
by Andrew
Frank,
Please send a request to
support@stimulsoft.com asking for the patch. We will prepare this for you.
Thank you.
Re: StiMobileDesigner - sql with parameters
Posted: Thu Oct 22, 2015 8:47 am
by FrenkR
updated to latest beta. Parametric search now works. Thanks.
Re: StiMobileDesigner - sql with parameters
Posted: Thu Oct 22, 2015 9:40 am
by HighAley
Hello.
We are always glad to help you.
Let us know if you need any additional help.
Thank you.