Re: To FETCH or NOT

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: george collins (george_at_nospan.com)
Date: 05/06/04 

Date: Thu, 6 May 2004 14:19:01 -0700

Okay, I am trying this.

Here is what I am doing.

field(1) has a value of a part number which is like "123/456-7(8)A"
I need to make field(2) to be the text in field(1) with out the punctuation
of "/ or - or ( or )"

I now use a mid$(field) loop checking each character for / or - or ( or )
and loop thru the field and create a new field(2) and update it.

I am just having problems. (MENTAL) today with figuring it out.

Continuing on.

thanks

George
"Al Reid" <areidjr@reidDASHhome.com> wrote in message
news:ek5hZf5MEHA.2996@TK2MSFTNGP12.phx.gbl...
> How about:
>
> con.Execute "UPDATE myTable SET myField2 = myField1 WHERE...
>
> No Fetch, no loops, no hits, no errors.
>
> --
> Al Reid
>
> "It ain't what you don't know that gets you into trouble. It's what you
know
> for sure that just ain't so." --- Mark Twain
>
> "george collins" <george@nospan.com> wrote in message
news:%23Zo3hX5MEHA.3348@TK2MSFTNGP09.phx.gbl...
> > Newbie here.
> >
> > I need to update a single field in a row, 250000 rows, predicated on
data in
> > an existing field in the row.
> >
> > row.field(1) has value, then row.field(2) now has this value.
> >
> > I don't know how to loop through the table. A select * returns
everything
> > and I need to test each row at a time.
> >
> > Can someone point me in the right direction.
> >
> > I am using vb6 and ADO to SQL2000.
> >
> > Is fetch with a next the best way or is "withevents' best?
> >
> > Looking for guidance.
> > Thanks
> > George
> >
> >
>
>

Relevant Pages

  • Re: Murray vs Reid...
    ... Reid pissed on Gordon Brown's leg, ... I'm amazed you even attempt to bring up George Galloway on ... "I still go to the cinema with my wife. ... I still kiss her. ...
    (uk.sport.football.clubs.celtic)
  • Re: When did you catch the travel bug?
    ... The Reid wrote: ... > Following up to george ... >>You might also like a week long sailboat trip through the Queen ... >>Charlotte Islands of British Columbia. ...
    (rec.travel.europe)
  • Re: Murray vs Reid...
    ... Reid pissed on Gordon Brown's leg, ... I'm amazed you even attempt to bring up George Galloway on ... drawn out MOD security clearences for my ... get cleared for some of the jobs Reid has had. ...
    (uk.sport.football.clubs.celtic)
  • Re: populating arrays
    ... George wrote: ... I moved it outside the loop, and the values of u produce on two successive runs are listed below. ... I reseeded to show nonrandom behavior. ... It seems that what you have demonstrated is that the first random number in the sequence doesn't change very much when the generator is reseeded using a time of day based seed that hasn't really changed very much. ...
    (comp.lang.fortran)
  • Re: error "There is not enough memory available now."
    ... "George" schrieb im Newsbeitrag ... > I've seen a number of posts to this error message, ... I tried to set ulimit -s ... If you change the for loop to a while loop it will work with ksh88, ...
    (comp.unix.aix)