SQL Server e Visual Basic 6

Article View: free.it.visual-basic

Article #1073

Back to free.it.visual-basic Previous Next

#1073

From: alex
Date: Sun, 21 Nov 2004 18:21

17 lines
1373 bytes

Ringrazio gi� da ora chi mi risponde.

Quale � la giusta sintassi in VB per comunicare con SQL Server, relativo a
una forma del tipo:

text1.text=data1
text2.text=data2

Select * From NomeTable
where NomeTable.Data between Text1.text and text2.text.

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 '#'.

Technical Details

Message-ID: <%05od.199463$b5.9902709@news3.tin.it>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!news-out.tin.it!news-in.tin.it!news3.tin.it.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: f94ee,db46606194f0ae18,start
X-Google-Attributes: gidf94ee,public
X-Google-Language: ITALIAN,ASCII
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!news-out.tin.it!news-in.tin.it!news3.tin.it.POSTED!not-for-mail
From: "alex" <alex84freeangel@yahoo.it>
Newsgroups: free.it.visual-basic
Subject: SQL Server e Visual Basic 6
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <%05od.199463$b5.9902709@news3.tin.it>
Date: Sun, 21 Nov 2004 18:21:47 GMT
NNTP-Posting-Host: 82.49.110.23
X-Complaints-To: "Please send abuse reports to abuse@tin.it and technical notifications to newsmaster@tin.it"
X-Trace: news3.tin.it 1101061307 82.49.110.23 (Sun, 21 Nov 2004 19:21:47 MET)
NNTP-Posting-Date: Sun, 21 Nov 2004 19:21:47 MET
Organization: TIN