netcracker Posted June 15, 2006 Share Posted June 15, 2006 hey! i have a problem... i have a rather lage table and i would like to searce and replace a certain string.eg.:table name: TBLcolumn: CLMN rs.open "select CLMN from TBL",conn while not rs.eof replace (CMLN, "value to be replaced", "the new value") rs.movenext wendrs.close Link to comment Share on other sites More sharing options...
netcracker Posted June 16, 2006 Author Share Posted June 16, 2006 silly me... all i wanted was to have that value replaced into the table... but i wasn't doing the UPDATE procedure and i was wanderring why wasn't there any change.. duh! so the "replace" function works just fine, it is me who is not functioning after a hard day's work... please disregard this topic, and, Admin, you might as well erase it completly as it is of no interest to any one...sorry Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now