Mass Replace

Article View: borland.public.vdbase.forms

Article #141

Back to borland.public.vdbase.forms Previous Next

#141

From: Frank Loomer
Date: Wed, 31 Mar 1999 00:00

14 lines
1011 bytes

I've tried the following loop to mass replace a  text field with the
current date.
===========
Form.query1.rowset.first()
Do while not form.query1.rowset().last
    form.query1.rowset.fields["Curr_date"].value := dtoc(date())
    form.query1.rowset.next()
Enddo
===========
The loop works, but the the value change doesn't take..
On the other hand, the form....value statement works fine as a
standalone statement. ie if you take it out of the loop and run it after
the Enddo, the change works.
What am I doing wrong?

Technical Details

Message-ID: <37020C6F.514C72EB@nbccsj.gov.nb.ca>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 15bdfb,e947cea5a9ec5e3a,start
X-Google-Attributes: gid15bdfb,public
From: Frank Loomer <loomerf@nbccsj.gov.nb.ca>
Subject: Mass Replace
Date: 1999/03/31
Message-ID: <37020C6F.514C72EB@nbccsj.gov.nb.ca>
X-Deja-AN: 461134698
Content-Transfer-Encoding: 7bit
Organization: Another Netscape Collabra Server User
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.forms