Forums

This topic is locked

Record navigation on Stored procedure

Posted 04 Sep 2003 17:49:35
1
has voted
04 Sep 2003 17:49:35 Moazam Baig posted:
Can we use the recordset navigation behaviour on a recordset retrieved by stored procedure? I am having difficulty with it.

Replies

Replied 08 Sep 2003 09:56:49
08 Sep 2003 09:56:49 Kenny Darcy replied:


<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Can we use the recordset navigation behaviour on a recordset retrieved by stored procedure? I am having difficulty with it.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote> Hi yea, I have managed to do what you are doing quiet easily using the following extension from Tom Muck, it is free if your database is access and works brialliant. www.dwteam.com/help/insertretrieve/

Regards


Kenny
Replied 20 Sep 2003 00:43:37
20 Sep 2003 00:43:37 Moazam Baig replied:
Hi!

Thank you very much for the help. I was able to resolve the problem on my own. It is quite strange that record navigation behaviour doesn;t work properly when you use a stored procedure, through the bindings panel and then choosing stored procedure from the command type.

However, if you create a record set and then from the list select stored procedure and then choose your desired stored procedure, then the navigation behaviour begins to work.

Thanks for your help.

Reply to this topic