From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00
	autolearn=unavailable autolearn_force=no version=3.4.4
Path: 
 eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: Simon Wright <simon@pushface.org>
Newsgroups: comp.lang.ada
Subject: Re: Prepared_Statement :(
Date: Sat, 24 Nov 2018 20:00:12 +0000
Organization: A noiseless patient Spider
Message-ID: <lyva4m2qlv.fsf@pushface.org>
References: <ce530325-6c40-458f-bd51-b5f03eebe02e@googlegroups.com>
	<ptbb8s$1g72$1@gioia.aioe.org>
	<9468b0a5-19bd-4057-a0d8-f84ed0425188@googlegroups.com>
	<e75fd330-c195-498b-a776-86f23541aae7@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain
Injection-Info: reader01.eternal-september.org;
 posting-host="82df4e36ca3ac674d31223ff26201ea7";
	logging-data="7355"; mail-complaints-to="abuse@eternal-september.org";
	posting-account="U2FsdGVkX18KwqMkadxPG9OuBsU+fZljlZ3U1Rqjp/c="
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.1 (darwin)
Cancel-Lock: sha1:LK7h5rYIYXK5YYLiOuMsJk2H9Wo=
	sha1:c8fVWJtQwvPmN7vYx17G+dCcJCo=
Xref: reader01.eternal-september.org comp.lang.ada:54887
Date: 2018-11-24T20:00:12+00:00
List-Id: <comp.lang.ada>

briot.emmanuel@gmail.com writes:

>> > >        Conn   : Database_Connection := Build_Database_Connection;
>
> You only show part of your code, this always makes things difficult.
> I don't know how you build the connection, but my guess is that you
> actually build a sqlite connection, not postgresql.
>
> "?" is how sqlite represents parameters. Postgresql uses $1, $2,... So
> the query is not working.
>
> https://www.postgresql.org/docs/10/sql-prepare.html

But that doesn't explain a compiler error report pointing at the middle
of a string!

OH! OH! OH! it's not a compiler error at all! (or if it is, it's when
the DBC compiles the prepared statement).

OP, it helps if you post the exact error message in context.