Visual Basic, VB4.0 Sql query

VB4.0 Sql query

Author	Message
Antti Maunul #1 / 3	VB4.0 Sql query I have a VB 4.0 application where i try to make a simple query to a table where the key is of type Date. The database is an MS Access 2.0 database. The Sql statement which I tried first was: Dim WantedDate as Date SQL = "Select xxxx from Calendar where CalendarDate = " & WantedDate Set MyRS = MyDB.OpenRecordset(SQL, dbOpenSnapshot) .. .. Using this I get error code 3075. I've tried many different methods to get the right SQL string, but no luck so far. Examples that I've found from Vb Faq's don't use a variable on the right side of the query, so no help there. Certainly should be a trivial case, but hope someone will tell the answer anyway...I'm just stuck with this one. Thanks in advance Antti Maunula
Mon, 22 Mar 1999 03:00:00 GMT

Robert Ki #2 / 3	VB4.0 Sql query Dates in SQL queries have to be enclosed in #'s..... i.e.: SQL = "Select xxxx from Calendar where CalendarDate = #" & WantedDate & "#"
Mon, 22 Mar 1999 03:00:00 GMT

Paul Sampso #3 / 3	VB4.0 Sql query Quote: > I have a VB 4.0 application where i try to make a simple query > to a table where the key is of type Date. The database is > an MS Access 2.0 database. > The Sql statement which I tried first was: > Dim WantedDate as Date > SQL = "Select xxxx from Calendar where CalendarDate = " & WantedDate Access 2 seems to want to be told explicitly that what it's got is a date, and this information is imparted unto it by surrounding the date with # characters. Thus what you may find you'll need is: SQL = "Select xxxx from Calendar where CalendarDate = #" & WantedDate & "#" Quote: > Set MyRS = MyDB.OpenRecordset(SQL, dbOpenSnapshot) > .. -- Vox (0\|+44)1642 216 200 }\|{ o\|o }o\|o{ Zetland Buildings, Exchange Square Fax (0\|+44)1642 216 201 o o * Middlesbrough, Cleveland. TS1 1DE "Imitation is the sincerest form of being a thieving bastard." -- somebody else
Tue, 23 Mar 1999 03:00:00 GMT

Page 1 of 1

[ 3 post ]