Article View: free.it.visual-basic
Article #252Insert
From: DB
Date: Wed, 15 Nov 2006 16:37
Date: Wed, 15 Nov 2006 16:37
9 lines
1378 bytes
1378 bytes
Premetto che sono un principiante e mi trovo d'avanti questo problema. Ho
questa porzione di codice che mi dovrebbe inserire nella tabella STAMPANOMI
tutto il contenuto della tabella DATI, invece mi inserisce il primo record e
basta ! Cosa sbaglio ? GRAZIE A TUTTI
Data1.RecordSource = "select * from dati order by flag, cognome, nome"
Data1.Database.Execute "delete from stampanomi"
Data1.Database.Execute ("insert into stampanomi select * from dati ")
Data1.Refresh
Technical Details
Message-ID:
<455b424a$0$7628$4fafbaef@reader1.news.tin.it>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news2.volia.net!feeder.news.tin.it!spool.news.tin.it!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: f94ee,746823ddaa40cd0b,start X-Google-Attributes: gidf94ee,public X-Google-Language: ITALIAN,ASCII-7-bit Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news2.volia.net!feeder.news.tin.it!spool.news.tin.it!not-for-mail From: "DB" <domenicobutaTOGLI@alice.it> Newsgroups: free.it.visual-basic Subject: Insert Date: Wed, 15 Nov 2006 17:37:29 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2869 X-RFC2646: Format=Flowed; Original X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 Lines: 12 Message-ID: <455b424a$0$7628$4fafbaef@reader1.news.tin.it> Organization: TIN.IT (http://www.tin.it) X-Comments: Please send technical notifications to newsmaster@tin.it NNTP-Posting-Host: 87.10.166.76 X-Trace: 1163608650 reader1.news.tin.it 7628 87.10.166.76:4029 X-Complaints-To: Please send abuse reports to abuse@tin.it