8/25/2025 12:31:54 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
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!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
No Columns defined in rowset
Posted: 15 Sep 08 6:08 AM
|
hi..
when i try to execute my stored procedure.i get the following error.."No Columns defined in rowset"
my code is
Dim rsUpActClstr
Dim ExeQuery
ExeQuery ='---Sql statement
set rsUpActClstr = objSLXDB.Execute(ExeQuery)
set rsUpActClstr = nothing |
|
|
| |
|
Re: No Columns defined in rowset
Posted: 16 Sep 08 2:30 AM
|
hi Ryan
My query Looks like this
Most of the Input parameters are taken from controls.
set rsUpActClstr = objSLXDB.Execute("UpSLXClust ('" & StrAccntid & "','" & Application.BasicFunctions.GetIDFor("ACNT_CLUSTR") & "','" & Application.BasicFunctions.CurrentUserID & "','" & CPType.Text & "','" & PRating.Text & "','" & SRAting.Text & "','" & CTover.Text & "','" & CEmp.Text & "','" & CTAtype.Text & "','" & galr & "','" & galcbu & "','" & CBUbook.Text & "','" & TIbook.Text & "','" & Research.Text & "','" & CVE.Text & "','" & Tbook.Text & "','" & Sbook.Text & "','" & Smgmt.Text & "','" & ParentEdit.Text & "','" & Clust.Text & "')")
set rsUpActClstr = nothing
When i Execute this Query i get "No Columns defined in rowset" Error.
|
|
|
|
Re: No Columns defined in rowset
Posted: 16 Sep 08 2:35 AM
|
So I take it that UpSLXClust is a stored proc then?
What version of SLX is this for?
Does UpSLXClust return rows or do something else?
Have you tried placing "exec" before the UpSLXClust? |
|
|
|
Re: No Columns defined in rowset
Posted: 16 Sep 08 3:24 AM
|
yes ryan. UpSLXClust is a stored procedure.
Version of SLX is 6.2
UpSLXClust has few select,insert and update statements .
i have tried placing exec keyword before UpSLXClust, it gives me error.
i guess bec already recordet is executing the Stored proc.
i dont get this error in another server, where same application is running on.
please help me to fix this issue.
Thanks
|
|
|
|
Re: No Columns defined in rowset
Posted: 16 Sep 08 12:30 PM
|
Maybe try to state the type of execution option to perform with adExecuteNoRecords and/or adCmdStoredProc?
i.e.
.Execute sqlstatement, recs, adExecuteNoRecords
or
.Execute sqlstatement, recs, adExecuteNoRecords + adCmdStoredProc
|
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|