Wrox Programmer Forums
|
Pro VB 6 For advanced Visual Basic coders working in version 6 (not .NET). Beginning-level questions will be redirected to other forums, including Beginning VB 6.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 25th, 2003, 04:09 AM
Registered User
 
Join Date: Aug 2003
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem with recordset

Hi.
I have the following code:

start code:
Set SearchEntities = GetRecordset(strSQL, adOpenForwardOnly)
If Not SearchEntities Is Nothing Then
    If SearchEntities.State = 0 Then GoTo err_h_SearchEntities
End If
end code:

where SearchEntities is a recordset object.
after the "getRecordSet" the "SearchEntities" is not nothing
but
the state is 0

How could it be ?
Is it possible that there is a syncronize problem ?

thanks.

 
Old August 25th, 2003, 10:17 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

hi there..

0 is for close.. i think.. if not please correct me..

what code is the recordset at that point???

Gonzalo Bianchi





Similar Threads
Thread Thread Starter Forum Replies Last Post
problem with recordset rwahdan BOOK: Access 2003 VBA Programmer's Reference 1 March 13th, 2008 05:03 AM
Recordset Problem hugoscp Classic ASP Professional 0 July 10th, 2007 05:59 AM
recordset problem jdsflash ASP.NET 1.0 and 1.1 Basics 1 May 16th, 2006 11:49 AM
Problem In Recordset zaeem Classic ASP Databases 2 October 22nd, 2003 01:34 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.