The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Execution of sp through Slx
Posted: 24 Mar 10 5:27 PM
|
I recently migrated from versión 6.2 to Saleslogix 7.5, and now when I execute a store procedure from the application it returns less information than if executed from sql Query Analizer.
This didn't happen on versión 6.2.
I already ckeck the conections to de Data Base and they are ok.
What else should I check?
Thanks.
|
|
|
|
Re: Execution of sp through Slx
Posted: 25 Mar 10 5:52 AM
|
More info required.
What should the sp return and how are you calling it? What does 'less information' mean? Nothing? |
|
|
|
Re: Execution of sp through Slx
Posted: 25 Mar 10 7:25 AM
|
The sp should return 306 rows of client information and it is only returning 40 rows. I am calling it with the following sentence
sql = "sysdba.CC_Olimpo_Rep_Men_mas '" & strTipoProducto & "','" & strFechaPortFolio & "'"
objSLXDB.ExecuteSql (Sql)
Thanks for the help. |
|
|
|
Re: Execution of sp through Slx
Posted: 25 Mar 10 7:34 AM
|
Ok ...
I try not to execute stored procs in SLX - as it tends to break sync to remotes - but don't you have to include the word 'exec' to make it execute?
Also, as you are logged in under the sysdba schema, you can omit that from your statement:
sql = "exec CC_Olimpo_Rep_Men_mas '" & strTipoProducto & "','" & strFechaPortFolio & "'"
How are you capturing the rows that are returned by the sp? |
|
|
|
Re: Execution of sp through Slx
Posted: 25 Mar 10 7:54 AM
|
Hi. It is not really neccesary to include the word exec it works without it. I will omit the sysdba.
This sp fills in a table and later a report on Crystal Report reads from that table.
Do you know if you can execute a web service from Slx? Because I tried calling the sp from a web service and it worked correctly.
|
|
|
| |
|
Re: Execution of sp through Slx
Posted: 25 Mar 10 8:31 AM
|
the sp calls 3 other sps that are on another server. The weird thing is that it brings info so the connections are correct. I will keep on checking.
Thanks for the link, I think I will try to resolve it that way. |
|
|
|
Re: Execution of sp through Slx
Posted: 26 Mar 10 7:48 AM
|
| if sync is not an issue just go direct against native sql, if it is an issue, go direct and transfer into a slx based rs on the return. Updated in the provider security layer and how slx provider identifies errors make it so you should 1) use exec and 2) turn off all record count or msg stmts echo'd from the sp's. If a sp echo's record counts for example, and 3 come back, slx will fail the sync process and probably some of the results figuring that errors occured. |
|
|
|