Article View: borland.public.vdbase.data.sql
Article #495UpdateSet
From: brucewm
Date: Mon, 31 Aug 1998 00:00
Date: Mon, 31 Aug 1998 00:00
32 lines
1514 bytes
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-mailShow 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