🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.vdbase.data.sql
Article #495

UpdateSet

#495
From: brucewm
Date: Mon, 31 Aug 1998 00:00
32 lines
1514 bytes
Hi all

I'm having a problem with a updateSet class. When I run this the
destination table's first column gets updated not the specified column.
The column I need to update is the 4th column to the right. 

example:

 "Garbage"  "Accnt_numb"  "First_name"  "Accnt_name"

If I enter ("Select garbage, accnt_numb, first_numb, accnt_numb from
            PACESET order by accnt_numb") for the rowset it works fine. 
On a large table I hope that I don't have to specify all column names to
get to the one I need updated. Here is the code I'm working with. 
I'm new to OODML so please be patient with me. It's time to move ahead.
***********************************************************************
    q = new Query()
    q.sql = "select accnt_name from PACESET order by accnt_numb"
    q.active = true
    q.rowset.indexName = "Accnt_numb"

    u = new UpdateSet()

    u.source = q.rowset
    u.destination = "ACCTTEST.DBF"
    u.changedTableName = "ACCTTEST OLD.DBF"
    u.indexName = "Accnt_numb"
    u.update()

Thanx,

Bruce
Technical Details
Message-ID: <35EAD8E4.3DFA@ix.netcom.com>
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: ff5a1,a1ee04ee624023bd,start
X-Google-Attributes: gidff5a1,public
From: brucewm@ix.netcom.com
Subject: UpdateSet
Date: 1998/08/31
Message-ID: <35EAD8E4.3DFA@ix.netcom.com>
X-Deja-AN: 386483529
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.data.sql