Re: Mass Replace

Article View: borland.public.vdbase.forms

Article #144

Back to borland.public.vdbase.forms Previous Next

#144

From: Ken Mayer [dBVIPS]
Date: Thu, 01 Apr 1999 00:00

27 lines
1167 bytes

Frank Loomer <loomerf@nbccsj.gov.nb.ca> wrote:

>===========
>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?

In addition to Gary's response, see UPDATE SET in the language
reference -- it's faster.

Ken
---
Ken Mayer [dBVIPS]

GO HERE! NOW!

news.dbase2000.com

These newsgroups are going away fast!

Technical Details

Message-ID: <3702ba8a.1111626@forums.borland.com>

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

References: <37020C6F.514C72EB@nbccsj.gov.nb.ca>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 15bdfb,e947cea5a9ec5e3a
X-Google-Attributes: gid15bdfb,public
From: supportInfo@borland.com (Ken Mayer [dBVIPS])
Subject: Re: Mass Replace
Date: 1999/04/01
Message-ID: <3702ba8a.1111626@forums.borland.com>
X-Deja-AN: 461359116
References: <37020C6F.514C72EB@nbccsj.gov.nb.ca>
Organization: Golden Stag Productions
Reply-To: teamb@opto-pps.com
Newsgroups: borland.public.vdbase.forms

Reply to Parent Message