query sql

Article View: free.it.visual-basic

Article #1091

Back to free.it.visual-basic Previous Next

#1091

From: McNamara
Date: Tue, 30 Nov 2004 23:34

20 lines
1732 bytes

Ciao a tutti
devo eseguire le seguente query SQL select * from Contabilit� where Data
BetWeen <valore1> and  <valore2>
dove valore 1 e valore 2 sono rispettivamente text1.text e text2.text....il
contenuto di valore 1 e 2 � di tipo date---> ad esempio 30/11/2004,devo
interrogare il database in questa maniera..."visualizzami risultati dal
30/11/2004 al 02/12/2004"--->questo � lo scopo della query...
io ho provato cosi:
Private Sub Search_Date_Click()
  Dim StringaSQL As String
  datPrimaryRS.Recordset.Close
  StringaSQL = "SELECT * FROM Contabilit�"
  StringaSQL = StringaSQL + " WHERE Data Between"
  StringaSQL = StringaSQL + " = '" + daDate.Text + "'and "
  StringaSQL = StringaSQL + " = '" + aDate.Text + "'"
  datPrimaryRS.Recordset.Open

End Sub

Grazie ciao

Technical Details

Message-ID: <gs7rd.435561$35.19106299@news4.tin.it>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!news-out.tin.it!news-in.tin.it!news4.tin.it.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: f94ee,5099321312088ca,start
X-Google-Attributes: gidf94ee,public
X-Google-Language: ITALIAN,ASCII
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!news-out.tin.it!news-in.tin.it!news4.tin.it.POSTED!not-for-mail
From: "McNamara" <McNamara@email.it>
Newsgroups: free.it.visual-basic
Subject: query sql
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <gs7rd.435561$35.19106299@news4.tin.it>
Date: Tue, 30 Nov 2004 23:34:36 GMT
NNTP-Posting-Host: 82.49.32.139
X-Complaints-To: "Please send abuse reports to abuse@tin.it and technical notifications to newsmaster@tin.it"
X-Trace: news4.tin.it 1101857676 82.49.32.139 (Wed, 01 Dec 2004 00:34:36 MET)
NNTP-Posting-Date: Wed, 01 Dec 2004 00:34:36 MET
Organization: TIN