2 programers have 2 different ways of opening recordsets.
1st way - retrieve 1 record to Update
2nd way - retrieve all records to fill a comboboxVB Code:
With DataEnvironment1.rstblLabs If .State = adStateOpen Then .Close .Open "SELECT * FROM tblLabs WHERE pkLab = " & p_pkLab, _ , adOpenStatic, adLockOptimistic
after the 1st way has already happened
When the second query to this table is executed the onlyVB Code:
With RS If Not .State = adStateOpen Then .Open , , adOpenStatic, adLockOptimistic
record retrieved is the one from the 1st query. Is there any
way to clear out the selection string from the 1st query and
just retrieve all the records without passing a new selection
string? This code is everywhere in the program so a major
code change would be good to avoid.




Reply With Quote