某些呼叫后无效的记录集 [英] Invalid recordset after some calls

问题描述

我面临一个问题.我执行选择查询并获取保留的记录集，每当提示输入特定记录的数据时，我都会使用记录集的查找"功能来查找所需的记录并返回其数据.

一段时间后，我的记录集变得无效，不知道为什么吗?谁能向我解释并建议我一些解决方法.

问候，
Sikander

Hi,
I''m facing a problem. I execute select query and get recordset which i retain and whenever i get prompt for data of specific record, I use ''Find'' function of recordset to findout my desired record and returned its data.

After some time, my recordset becomes invalid, do''t know why? Can anyone explain to me and suggest me some solution.

Regards,
Sikander

推荐答案

通常来说，您不应保持连接处于活动状态.这允许ADO进行连接池(这是非常擅长的).通过ADO获取数据时，建立连接，每次获取数据并关闭连接.了解更多:http://www.mofeel.net/27-microsoft-public-data-ado/4811.aspx

祝你好运！

Generally speaking, you should not keep a connection alive. This allows ADO to do connection pooling (which it is very good at). When getting data via ADO, make a connection, get your data and close the connection each time.Read More: http://www.mofeel.net/27-microsoft-public-data-ado/4811.aspx

Good luck!

这篇关于某些呼叫后无效的记录集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！