Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

MoveFirst Error

In this portion of the code in VB6 I get an error when Procedure2 is used and it occurs on the MoveFirst command at the end.  Any ideas?

Procedure2:

esql = "select * From frmRegistrationCSW Where frmRegistrationCSWCheck4 = 1 And frmRegistrationCSWCheck10 =1 And frmRegistrationCSWText15  >= convert( datetime, " & ravi & BeginDate & ravi & " , 101 )And frmRegistrationCSWText15  <= convert( datetime, " & ravi & EndDate & ravi & " , 101 ) "

If Not Combo1.Text = "-All-" Then
esql = esql & " And frmRegistrationCSWText1 = " & ravi & Program & ravi
End If

rec.Open (esql), conn, adOpenStatic, adLockOptimistic


Com(2) = rec.RecordCount
Text2.Text = Com(2)


rec.MoveFirst
0
al4629740
Asked:
al4629740
1 Solution
 
hesCommented:
What error ?
And why do you need to do a movefirst ?
0
 
al4629740Author Commented:
nevermind, I got the answer.  Thanks anyways.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now