Re: SQL parse error

Article View: borland.public.delphi.database

Article #18

Back to borland.public.delphi.database Previous Next

#18

From: Alfred ten Hoeve
Date: Fri, 25 Jul 2003 01:04

50 lines
3195 bytes

See my previous post.
I think the problem was the : between the fieldname and the fieldtype.

Alfred.


"Dr. Oliver Maas" <o.maas@metrohm.de> schreef in bericht
news:4d1ba0cc.0307240801.1730b3ed@posting.google.com...
> Hi,
>
> are you sure that your SQL syntax is correct?
> I guess one needs a quoted parameter name, theres (in procedure
> TIBSQL.PreprocessSQL) some parsing done about " chars inside the SQL
> string.
> The following is an extract from TIBSQL.PreprocessSQL
>
>
> (...)
>
>           begin
>           { collect the name of the parameter }
>           if iCurParamState = ParamDefaultState then
>           begin
>             if cCurChar = '"' then
>               iCurParamState := ParamQuoteState
>             else if (cCurChar in ['A'..'Z', 'a'..'z', '0'..'9', '_',
> '$']) then
>                 sParamName := sParamName + cCurChar
>             else if FGenerateParamNames then
>             begin
>               sParamName := 'IBXParam' + IntToStr(iParamSuffix);
>               Inc(iParamSuffix);
>               iCurState := DefaultState;
>               slNames.Add(sParamName);
>               sParamName := '';
>             end
>             else
>               IBError(ibxeSQLParseError, [SParamNameExpected]); // <-
> !!
>           end
>           else begin
>             { determine if Quoted parameter name is finished }
>             if cCurChar = '"' then
>             begin
>
> (...)
>
> regards
>
> Oliver

Technical Details

Message-ID: <3f208368$0$8296$4d4ebb8e@news.nl.uu.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer01.lnd.ops.eu.uu.net!bnewsoutpeer01.bru.ops.eu.uu.net!bnewsinpeer01.bru.ops.eu.uu.net!bnewspost00.bru.ops.eu.uu.net!emea.uu.net!news.nl.uu.net!not-for-mail

References:

<3f194299$0$49110$e4fe514c@news.xs4all.nl> <3f19f873$0$8307$4d4ebb8e@news.nl.uu.net> <bfj7s8$bf1$1@news.boerde.de> <3f1eec9a$0$49107$e4fe514c@news.xs4all.nl> <3f1f15f4$0$8304$4d4ebb8e@news.nl.uu.net> <3f1f66de$0$49106$e4fe514c@news.xs4all.nl> <4d1ba0cc.0307240801.1730b3ed@posting.google.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff75c,7a329eac3d9933a8
X-Google-Attributes: gidff75c,public
X-Google-Thread: 10de66,7a329eac3d9933a8
X-Google-Attributes: gid10de66,public
X-Google-Thread: f6386,7a329eac3d9933a8
X-Google-Attributes: gidf6386,public
X-Google-Thread: 115d96,7a329eac3d9933a8
X-Google-Attributes: gid115d96,public
X-Google-ArrivalTime: 2003-07-24 18:10:07 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer01.lnd.ops.eu.uu.net!bnewsoutpeer01.bru.ops.eu.uu.net!bnewsinpeer01.bru.ops.eu.uu.net!bnewspost00.bru.ops.eu.uu.net!emea.uu.net!news.nl.uu.net!not-for-mail
From: "Alfred ten Hoeve" <Alfred.NoSpam@SimpelProg.nl>
Newsgroups: borland.public.delphi.database,borland.public.delphi.database.desktop,borland.public.delphi.database.multi-tier,borland.public.delphi.database.sqlservers
References: <3f194299$0$49110$e4fe514c@news.xs4all.nl> <3f19f873$0$8307$4d4ebb8e@news.nl.uu.net> <bfj7s8$bf1$1@news.boerde.de> <3f1eec9a$0$49107$e4fe514c@news.xs4all.nl> <3f1f15f4$0$8304$4d4ebb8e@news.nl.uu.net> <3f1f66de$0$49106$e4fe514c@news.xs4all.nl> <4d1ba0cc.0307240801.1730b3ed@posting.google.com>
Subject: Re: SQL parse error
Date: Fri, 25 Jul 2003 03:04:01 +0200
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Lines: 52
Message-ID: <3f208368$0$8296$4d4ebb8e@news.nl.uu.net>
NNTP-Posting-Host: 1Cust50.tnt33.rtm1.nld.da.uu.net
X-Trace: 1059095401 news.nl.uu.net 8296 213.116.160.50
X-Complaints-To: abuse@nl.uu.net

Reply to Parent Message