Article View: free.it.visual-basic
Article #860Re: errore in una sub...
From: tebby
Date: Wed, 01 Jun 2005 16:50
Date: Wed, 01 Jun 2005 16:50
29 lines
1965 bytes
1965 bytes
l'errore sql te lo restituisce xke magari metti l'apice singolo e l'id ๏ฟฝ
numerico
l'apice singolo serve solo con le stringhe
se porti la query in access e lo vedi subito
"Link" <claudio.scara@virgilio.it> ha scritto nel messaggio
news:EZ7he.893848$b5.39348534@news3.tin.it...
> Private Sub Command2_Click()
> If Text1.Text <> " " Then
> If MsgBox("Vuoi cancellare la chiamata?", vbYesNo + vbDefaultButton2) =
> vbYes Then
> query = "delete * from assenza where assenza.id = '" & Text1.Text & "'"
> db.Execute query 'qui mi dice tipi di dati non corrispondenti
> nell'espressione criterio
> rs.Requery
> Set chiamperse.Data1.Recordset = rs
> End If
> Else: MsgBox "Inserisci l'ID della chiamata!", vbExclamation, "Errore"
> Exit Sub
> End If
> numero_perse
> End Sub
>
>
> perch๏ฟฝ mi da quell'errore?? grazie
>
>
Technical Details
Message-ID:
<hHlne.38050$795.1161182@twister1.libero.it>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsgate.cistron.nl!feeder1.essentkabel.com!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!news-out.tin.it!news-in.tin.it!nntp.infostrada.it!twister1.libero.it.POSTED!not-for-mailReferences:
<EZ7he.893848$b5.39348534@news3.tin.it>Show Full Headers
Complete Article Headers
X-Google-Thread: f94ee,fe698954e19c13a6 X-Google-Attributes: gidf94ee,public X-Google-Language: ITALIAN,ASCII Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsgate.cistron.nl!feeder1.essentkabel.com!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!news-out.tin.it!news-in.tin.it!nntp.infostrada.it!twister1.libero.it.POSTED!not-for-mail From: "tebby" <tebez85@hotmail.com> Newsgroups: free.it.visual-basic References: <EZ7he.893848$b5.39348534@news3.tin.it> Subject: Re: errore in una sub... Lines: 31 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Response Message-ID: <hHlne.38050$795.1161182@twister1.libero.it> Date: Wed, 01 Jun 2005 16:50:21 GMT NNTP-Posting-Host: 151.47.138.154 X-Complaints-To: abuse@net24.it X-Trace: twister1.libero.it 1117644621 151.47.138.154 (Wed, 01 Jun 2005 18:50:21 MET DST) NNTP-Posting-Date: Wed, 01 Jun 2005 18:50:21 MET DST Organization: [Infostrada]