UpdateBatch

Article View: free.it.visual-basic

Article #3854

Back to free.it.visual-basic Previous Next

#3854

From: Dancan
Date: Tue, 26 Feb 2002 15:28

21 lines
1553 bytes

Posso fare un UpdateBatch con ado se ho una InnerJoin  nel datasource di ado

Esempio :

adors.open "SELECT  TBLPRINCIPALE .C1,
                                   TBLPRINCIPALE .C2,
                                   TBLPRINCIPALE .C3,
                                   TBLPERSONE.P1  FROM TBLPRINCIPALE
                                   INNER JOIN TBLPERSONE ON
PRINCIPALE.IDMaster = TBLPERSONE.IDChild WHERE IDMASTER = 1


POSSO POPOLARE I DATI DEL RECORDSET :


ADORS("C1") = "Prova1"
ADORS("C2") = "Prova2"
ADORS("C3") = "Prova3"
ADORS("P1") = "Prova4"

ADORS.UPDATEBATCH

Technical Details

Message-ID: <mSNe8.29852$fa5.1022276@twister2.libero.it>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!212.177.105.133!news.mailgate.org!nntp.infostrada.it!twister2.libero.it.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f94ee,14d7559b645503a9,start
X-Google-Attributes: gidf94ee,public
X-Google-ArrivalTime: 2002-02-26 07:30:31 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!212.177.105.133!news.mailgate.org!nntp.infostrada.it!twister2.libero.it.POSTED!not-for-mail
From: "Dancan" <geniovi@libero.it>
Newsgroups: free.it.visual-basic
Subject: UpdateBatch
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Message-ID: <mSNe8.29852$fa5.1022276@twister2.libero.it>
Date: Tue, 26 Feb 2002 16:28:05 +0100
NNTP-Posting-Host: 151.4.110.150
X-Complaints-To: abuse@iunet.it
X-Trace: twister2.libero.it 1014737426 151.4.110.150 (Tue, 26 Feb 2002 16:30:26 MET)
NNTP-Posting-Date: Tue, 26 Feb 2002 16:30:26 MET
Organization: [Infostrada]