Re: Dialog box, passing parameter fails

--00000000000028af4305932d71cf
Content-Type: text/plain; charset="UTF-8"

On Fri, Sep 20, 2019, 8:20 PM [email protected] <[email protected]>
wrote:

> Hi, I am using Postgresql 9.5 as server and Libreoffice BASE 5.2.4 to
> connect to the server.
>
> The code SQL must be sent directly and not be interpreted by Libo Base
> because there are some complex syntax (functions, variables, ...).
>
> Also, I need passing parameters to control some ranges. ex:  dates.
>
> But, postgresql can not understand passing parameters with either ? or :
> syntax which open a dialog box.
>
> eg: select * from agenda where date= ?
>
> The execution of code ode fails in direct mode.
>
> What are solutions ? cant postgresql bypass some parts of the code  where
> I put parameters request ?
>
> Thank you
>

Can you get your sql code to work from psql command line? Seems like maybe
it's just syntax? Send a complete sql statement including parameters that
is failing..

Steve

>

--00000000000028af4305932d71cf
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div><br><br><div class=3D"gmail_quote"><div dir=3D"ltr" =
class=3D"gmail_attr">On Fri, Sep 20, 2019, 8:20 PM <a href=3D"mailto:intmai=
[email protected]">[email protected]</a> &lt;<a href=3D"mailto:intmail01@gmai=
l.com">[email protected]</a>&gt; wrote:<br></div><blockquote class=3D"gma=
il_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-lef=
t:1ex">
 =20

   =20
 =20
  <div text=3D"#000000" bgcolor=3D"#FFFFFF">
    <div class=3D"m_2275504839066132110js-editable-content">
      <p>Hi, I am using Postgresql 9.5 as server and Libreoffice BASE
        5.2.4 to connect to the server.</p>
      <p>The code SQL must be sent directly and not be interpreted by
        Libo Base because there are some complex syntax (functions,
        variables, ...).</p>
      <p>Also, I need passing parameters to control some ranges. ex:=C2=A0
        dates.<br>
      </p>
      <p>But, postgresql can not understand passing parameters with
        either ? or : syntax which open a dialog box.<br>
      </p>
      <p>eg: select * from agenda where date=3D ?</p>
      <p>The execution of code ode fails in direct mode.</p>
      <p>What are solutions ? cant postgresql bypass some parts of the
        code=C2=A0 where I put parameters request ?</p>
      <p>Thank you<br></p></div></div></blockquote></div></div><div dir=3D"=
auto"><br></div><div dir=3D"auto">Can you get your sql code to work from ps=
ql command line? Seems like maybe it&#39;s just syntax? Send a complete sql=
 statement including parameters that is failing..=C2=A0</div><div dir=3D"au=
to"><br></div><div dir=3D"auto">Steve=C2=A0</div><div dir=3D"auto"><div cla=
ss=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 =
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div text=3D"#000000" bgc=
olor=3D"#FFFFFF"><div class=3D"m_2275504839066132110js-editable-content"><p=
>
      </p>
    </div>
  </div>

</blockquote></div></div></div>

--00000000000028af4305932d71cf--