tomhoran
asked on
connection is busy with results from another hstmt
i'm getting this error. the vb program use to work before.
Dim FSAElecRecSet As ADODB.Recordset
Set FSAElecRecSet = New ADODB.Recordset
Dim FSAClaimRecSet As ADODB.Recordset
Set FSAClaimRecSet = New ADODB.Recordset
SelStmnt = "select curr_year_last_proc_date, prev_year_last_proc_date, min_reimburse_amt, " & _
"fe.cust_no, fe.company_no, fe.soc_sec_no, fe.plan_year_code, customer_type, " & _
"fe.fsa_type, type, eff_date, term_date, customer_contact, company_contact, " & _
"annual_contrib, lvl1_download_reimbur_cnt, lvl1_download_reimbur_fee, lvl2_download_reimbur_fee, " & _
"reimburse_deduc_code from fsa_elections as fe " & _
"join proc3_cust_and_comp_nos as toproc on fe.cust_no = toproc.cust_no " & _
"and fe.company_no = toproc.company_no " & _
"join fsa_type_tbl as ftt on fe.cust_no = ftt.cust_no " & _
"and fe.company_no = toproc.company_no " & _
"and fe.plan_year_code = ftt.plan_year_code " & _
"and fe.fsa_type = ftt.code " & _
"where ( (fe.plan_year_code = curr_year_plan_code) " & _
"or (fe.plan_year_code = prev_year_plan_code) ) and reimburse_deduc_code <> '' " & _
"order by fe.cust_no, fe.company_no, soc_sec_no, fe.plan_year_code, fe.fsa_type "
FSAElecRecSet.Open SelStmnt, HROnline_DataBase, adOpenForwardOnly, adLockReadOnly
If FSAElecRecSet.EOF Then
Exit Sub
End If
FSAElecRecSet.MoveFirst
SelStmnt = "select claim.cust_no, " & _
"claim.company_no, soc_sec_no, plan_year_code, fsa_type, claim_no, " & _
"claim_amt, prev_year_plan_code " & _
"from fsa_claims as claim " & _
"join proc3_cust_and_comp_nos as toproc on claim.cust_no = toproc.cust_no " & _
"and claim.company_no = toproc.company_no " & _
"where claim.status_code = 'CA' " & _
"and ( (plan_year_code = curr_year_plan_code and status_date " & _
"<= curr_year_grace_end_date and curr_year_last_proc_date >= '" & _
ProcRunDate & "') " & _
"or (plan_year_code = prev_year_plan_code and status_date <= " & _
"prev_year_grace_end_date and prev_year_last_proc_date >= '" & _
ProcRunDate & "') ) " & _
"order by claim.cust_no, claim.company_no, soc_sec_no, plan_year_code, " & _
"fsa_type, claim_date "
************************** ********** *
i get the error on the open? ideas?
FSAClaimRecSet.Open SelStmnt, HROnline_DataBase, adOpenForwardOnly, adLockReadOnly
Dim FSAElecRecSet As ADODB.Recordset
Set FSAElecRecSet = New ADODB.Recordset
Dim FSAClaimRecSet As ADODB.Recordset
Set FSAClaimRecSet = New ADODB.Recordset
SelStmnt = "select curr_year_last_proc_date, prev_year_last_proc_date, min_reimburse_amt, " & _
"fe.cust_no, fe.company_no, fe.soc_sec_no, fe.plan_year_code, customer_type, " & _
"fe.fsa_type, type, eff_date, term_date, customer_contact, company_contact, " & _
"annual_contrib, lvl1_download_reimbur_cnt,
"reimburse_deduc_code from fsa_elections as fe " & _
"join proc3_cust_and_comp_nos as toproc on fe.cust_no = toproc.cust_no " & _
"and fe.company_no = toproc.company_no " & _
"join fsa_type_tbl as ftt on fe.cust_no = ftt.cust_no " & _
"and fe.company_no = toproc.company_no " & _
"and fe.plan_year_code = ftt.plan_year_code " & _
"and fe.fsa_type = ftt.code " & _
"where ( (fe.plan_year_code = curr_year_plan_code) " & _
"or (fe.plan_year_code = prev_year_plan_code) ) and reimburse_deduc_code <> '' " & _
"order by fe.cust_no, fe.company_no, soc_sec_no, fe.plan_year_code, fe.fsa_type "
FSAElecRecSet.Open SelStmnt, HROnline_DataBase, adOpenForwardOnly, adLockReadOnly
If FSAElecRecSet.EOF Then
Exit Sub
End If
FSAElecRecSet.MoveFirst
SelStmnt = "select claim.cust_no, " & _
"claim.company_no, soc_sec_no, plan_year_code, fsa_type, claim_no, " & _
"claim_amt, prev_year_plan_code " & _
"from fsa_claims as claim " & _
"join proc3_cust_and_comp_nos as toproc on claim.cust_no = toproc.cust_no " & _
"and claim.company_no = toproc.company_no " & _
"where claim.status_code = 'CA' " & _
"and ( (plan_year_code = curr_year_plan_code and status_date " & _
"<= curr_year_grace_end_date and curr_year_last_proc_date >= '" & _
ProcRunDate & "') " & _
"or (plan_year_code = prev_year_plan_code and status_date <= " & _
"prev_year_grace_end_date and prev_year_last_proc_date >= '" & _
ProcRunDate & "') ) " & _
"order by claim.cust_no, claim.company_no, soc_sec_no, plan_year_code, " & _
"fsa_type, claim_date "
**************************
i get the error on the open? ideas?
FSAClaimRecSet.Open SelStmnt, HROnline_DataBase, adOpenForwardOnly, adLockReadOnly
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
please post the exact error message
ASKER
this did it .. thanks
FSAAcctRecSet.CursorLocati on = adUseClient
FSAElecRecSet.CursorLocati on = adUseClient
FSAClaimRecSet.CursorLocat ion = adUseClient
FSAAcctRecSet.CursorLocati
FSAElecRecSet.CursorLocati
FSAClaimRecSet.CursorLocat