RE: Witango-Talk: Declare Cursor

[Ben Johansen]

Hi Ben   You can run a cursor within a stored procedure, but Witango will not be able to interact with it. You could create a stored procedure that does a process based on some criteria passed in that populates a table Based on the criteria, then you can use a search action in Witango to and then a subsequent @FOR loop to go through the data.   Example DirectDBMS = select (storeprocname(‘parm1,param2’) from dummyonerowtable Search = select col1,col2,col3 from storedprocfilledtable – data returned in @@resultSet For = "loop" through resultSet   Hope This Helps   Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm  Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Benjamin Strickland Sent: Thursday, October 17, 2002 6:05 AM To: Multiple recipients of list witango-talk Subject: Witango-Talk: Declare Cursor   Is is possible to use the Declare Cursor and all related commands in a stored procedure running in WiTango or 3.6?   Benjamin Strickland