vb6 - Password Changer using VAccess -
hey working on password changer. user logs in ( successfully), loads global var user initials, launch password expired form. try , use initials on password expired form retrieve user info db.
vauserlog.fieldvalue("userinit") = userinitials vauserlog.getequal vastat = vauserlog.status
vastat keeps giving me error of 4. using pervasive v9. connection va looks like:
with vauserlog .refreshlocations = true .ddfpath = datapath .tablename = "userlog" .location = "userlog.mkd" .open if .status <> 0 errmsg = "error opening file " + .tablename + " - status " + str$(.status) + vbcrlf + "contact department" end if end
in db table, userinit char, 3. userinitials string.
probably missing small can't think right now. appreciate. lemme know if require more info.
cheers
status 4 means record not found. in case, case of value being searched wrong, there's different padding (spaces versus binary zero), or userinitials value isn't in data file. can use mkde tracing see what's being passed psql engine. once you've done that, make sure value you're using works through function executor can open file , perform getequal.
here suggestions: - make sure you're pointing right data files. - make sure you're passing right value getequal (by setting fieldvalue).
Comments
Post a Comment