VB & SQL

Article View: free.it.visual-basic

Article #1920

Back to free.it.visual-basic Previous Next

#1920

From: ivangray
Date: Sun, 21 Dec 2003 22:13

11 lines
1314 bytes

come faccio ad essere sicuro di inserire un nuovo record ( quindi non
esistente ) in una tabella tramite una stringa SQL ? INSERT ritorna qualcosa
? se si come faccio ad interrogare la risposta ?

1000 grazie

ivahngray

ps. io ho sempre usato DAO e Recordset controllando .EOF e BOF prima di
inserire. Ma penso che esiste anche qualche altro modo. Ora vado con ODBC e
SQL 7.

Technical Details

Message-ID: <EWoFb.32009$0w.1640046@news2.tin.it>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!irazu.switch.ch!switch.ch!newsfeed.nextoneserver.com!news-out.tin.it!news-in.tin.it!news2.tin.it.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ITALIAN,ASCII-7-bit
X-Google-Thread: f94ee,42d46cb6f91ea73f,start
X-Google-Attributes: gidf94ee,public
X-Google-ArrivalTime: 2003-12-21 14:13:57 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!irazu.switch.ch!switch.ch!newsfeed.nextoneserver.com!news-out.tin.it!news-in.tin.it!news2.tin.it.POSTED!not-for-mail
From: "ivangray" <ivangray@virgilio.it>
Newsgroups: free.it.visual-basic
Subject: VB & SQL
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <EWoFb.32009$0w.1640046@news2.tin.it>
Date: Sun, 21 Dec 2003 22:13:56 GMT
NNTP-Posting-Host: 212.171.32.183
X-Complaints-To: newsmaster@tin.it
X-Trace: news2.tin.it 1072044836 212.171.32.183 (Sun, 21 Dec 2003 23:13:56 MET)
NNTP-Posting-Date: Sun, 21 Dec 2003 23:13:56 MET
Organization: TIN