Re: syntaxfout

Article View: be.comp.programming

Article #4831

Back to be.comp.programming Previous Next

#4831

From: Theo
Date: Mon, 30 Jun 2003 17:42

17 lines
1807 bytes

"Rollo Tomasi" <nospam@anyhost.com> wrote in message
news:ghTLa.6467$S%1.724622366@hestia.telenet-ops.be...
> >>
> >> sql = "INSERT INTO message (Time,From,Message,Read) Values ('" &
> >> TimeValue(now()) & "', '" & nummer & "', '" & tekst & "', false)"
> >> conn.execute(sql)
> >> Database is een access-datebase
> > "From" is een reserved word.
> Time ook.

Klopt.
Maar de meeste databases (even getest op Access, Sqlserver en Oracle) hebben
er geen moeite mee, in tegenstelling tot From.
Met Read zou ik overigens ook voorzichtig zijn: in Transact-sql (Sybase,
Sqlserver) is dat nl. ook een keyword. Access en Oracle pakken hem wel.

Theo

Technical Details

Message-ID: <3f007697$0$2237$e4fe514c@dreader6.news.xs4all.nl>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!diablo.theplanet.net!news.indigo.ie!feeder.news.heanet.ie!surfnet.nl!newsfeed.wxs.nl!transit.news.xs4all.nl!rhinewceros.xs4all.nl!not-for-mail

References:

<ocYKa.2872$P26.5420@afrodite.telenet-ops.be> <3efd7eb0$0$147$e4fe514c@dreader9.news.xs4all.nl> <ghTLa.6467$S%1.724622366@hestia.telenet-ops.be>

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: 107324,b305f58fa980c7d7
X-Google-Attributes: gid107324,public
X-Google-Thread: fcea4,b305f58fa980c7d7
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2003-06-30 10:42:49 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!diablo.theplanet.net!news.indigo.ie!feeder.news.heanet.ie!surfnet.nl!newsfeed.wxs.nl!transit.news.xs4all.nl!rhinewceros.xs4all.nl!not-for-mail
From: "Theo" <theo_asma.nothere@hotmail.com>
Newsgroups: be.comp.programming,nl.comp.programmeren
References: <ocYKa.2872$P26.5420@afrodite.telenet-ops.be> <3efd7eb0$0$147$e4fe514c@dreader9.news.xs4all.nl> <ghTLa.6467$S%1.724622366@hestia.telenet-ops.be>
Subject: Re: syntaxfout
Date: Mon, 30 Jun 2003 19:42:45 +0200
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Lines: 19
Message-ID: <3f007697$0$2237$e4fe514c@dreader6.news.xs4all.nl>
NNTP-Posting-Host: 213.84.150.170
X-Trace: 1056994968 dreader6.news.xs4all.nl 2237 213.84.150.170:16514

Reply to Parent Message