Re: foutje in vb6.0

Article View: be.comp.programming

Article #9772

Back to be.comp.programming Previous Next

#9772

From: SLE
Date: Mon, 08 Apr 2002 09:37

21 lines
1622 bytes

"ikke" <cdr@pandora.be> wrote in message
news:3ids8.5352$Ze.1988@afrodite.telenet-ops.be...
| blijkbaar is deze syntax fout, geeft iemand een idee waarom???
|
|
| Set registerrs = copyloggerdb.OpenRecordset(" select * from registraties
| WHERE Date between #" & Format(Calendar1.Value, "MM/DD/YYYY") & "# and #"
&
| Format(Calendar2.Value, "MM/DD/YYYY") & "# And Kostenplaats like
kostplaats
| And Persoon like gebruiker", dbOpenDynaset)
|

1 - Geeft wellicht geen fout, maar opgelet met datums: standaard SQL
verwacht steeds data in YYYY/MM/DD formaat.
2 - Plaats litterals (LIKE ...) steeds tussen single quotes (').


HTH,

SLE

Technical Details

Message-ID: <3cb16501$0$8162$ba620e4c@news.skynet.be>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!news.tele.dk!small.news.tele.dk!194.25.134.62!newsfeed00.sul.t-online.de!t-online.de!skynet.be!skynet.be!louie!not-for-mail

References: <3ids8.5352$Ze.1988@afrodite.telenet-ops.be>

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: fcea4,e19d984fafbccf1f
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2002-04-08 02:38:17 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!news.tele.dk!small.news.tele.dk!194.25.134.62!newsfeed00.sul.t-online.de!t-online.de!skynet.be!skynet.be!louie!not-for-mail
From: "SLE" <stevenDOTlecluyse@vskDOTbe>
Newsgroups: be.comp.programming
References: <3ids8.5352$Ze.1988@afrodite.telenet-ops.be>
Subject: Re: foutje in vb6.0
Date: Mon, 8 Apr 2002 11:37:06 +0200
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
Lines: 23
Message-ID: <3cb16501$0$8162$ba620e4c@news.skynet.be>
Organization: -= Skynet Usenet Service =-
NNTP-Posting-Host: 217.136.254.150
X-Trace: 1018258689 reader0.news.skynet.be 8162 217.136.254.150
X-Complaints-To: abuse@skynet.be

Reply to Parent Message