Re: SQL Server e Visual Basic 6

Article View: free.it.visual-basic

Article #1077

Back to free.it.visual-basic Previous Next

#1077

From: Fr4nc3sc0
Date: Tue, 23 Nov 2004 18:25

14 lines
1483 bytes

"alex" <alex84freeangel@yahoo.it> ha scritto nel messaggio
news:%05od.199463$b5.9902709@news3.tin.it...
> Io l'ho scritta cos�:
> dim sql as string
> sql="Select  *  from NomeTable " & _
>       "where NomeTable.Data between #" & text1.text  & "# and #" &
> text2.text & "#"
> ma mi dice error sintax near '#'.

Credo che i cancelletti debbano essere sostituiti dall'apostrofo. Visto che
si tratta un testo l'apostrofo � il carattere idoneo alla tua query.

Ti saluto
fs

Technical Details

Message-ID: <cnvv92$cur$1@newsreader.mailgate.org>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!213.246.39.15.MISMATCH!async2!news.mailgate.org!newsreader.mailgate.org!not-for-mail

References: <%05od.199463$b5.9902709@news3.tin.it>

Show Full Headers

Complete Article Headers

X-Google-Thread: f94ee,db46606194f0ae18
X-Google-Attributes: gidf94ee,public
X-Google-Language: ITALIAN,ASCII
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!213.246.39.15.MISMATCH!async2!news.mailgate.org!newsreader.mailgate.org!not-for-mail
From: "Fr4nc3sc0" <nontidicolamia@email.no>
Newsgroups: free.it.visual-basic
Subject: Re: SQL Server e Visual Basic 6
Date: Tue, 23 Nov 2004 19:25:37 +0100
Organization: Mailgate.ORG Server - http://www.Mailgate.ORG
Lines: 19
Sender: f.sorrentino@tin.it
Message-ID: <cnvv92$cur$1@newsreader.mailgate.org>
References: <%05od.199463$b5.9902709@news3.tin.it>
NNTP-Posting-Host: 83.103.45.26
X-Trace: newsreader.mailgate.org 1101234275 13275 83.103.45.26 (23 Nov 2004 18:24:35 GMT)
X-Complaints-To: abuse@mailgate.org
NNTP-Posting-Date: Tue, 23 Nov 2004 18:24:35 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409

Reply to Parent Message