Re: a4gl query through forms

Mike Aubury <[email protected]> Fri, 18 Aug 2023 11:59:56 +0100
Newsgroups gmane.comp.lang.4gl.aubit.general
Message-ID <CAGAq4WFZ_a-d8d-J-J39fwbnPvK=eS6cQ3XGBKMxD-_MLDJNDQ@mail.gmail.com>
--===============2499517167118606513==
Content-Type: multipart/alternative; boundary="0000000000008923770603306eb5"

--0000000000008923770603306eb5
Content-Type: text/plain; charset="UTF-8"

There is "runforms.4ae" - which should be similar, I dont know if it will
work with your postgresql tables as I think it relies on Rowid
functionality which Postgres deprecated (we used OIDs to replicate RowIDs).



On Fri, 18 Aug 2023 at 08:06, Michael Pope <[email protected]> wrote:

> Hello,
>
> We have successfully migrated from Informix 7.20 to Aubit4gl this week and
> we used to use isql's Form query feature but I've found that missing from
> a4gl. Is there a way to get similar functionality? We would like an easy
> way (not SQL) to quickly enter some terms into an existing form like the
> isql -> form -> run feature of informix.
>
> Our data is now in PostgreSQL and the closest thing I've found instead of
> using a4gl is Postbird, but it only allows you to filter on one field at a
> time. pgAdmin is way over the top for us.
>
> Any ideas would be great.
> --
> Regards,
>
> Michael Pope
> _______________________________________________
> Aubit4gl-discuss mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss
>

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

<div dir=3D"ltr">There is &quot;runforms.4ae&quot; - which should be simila=
r, I dont know if it will work with your postgresql tables as I think it re=
lies on Rowid functionality which Postgres deprecated (we used OIDs to repl=
icate RowIDs).<div><br><br></div></div><br><div class=3D"gmail_quote"><div =
dir=3D"ltr" class=3D"gmail_attr">On Fri, 18 Aug 2023 at 08:06, Michael Pope=
 &lt;<a href=3D"mailto:[email protected]">[email protected]</a>&gt;=
 wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px =
0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
 =20

   =20
 =20
  <div>
    <p>Hello,</p>
    <p>We have successfully migrated from Informix 7.20 to Aubit4gl this
      week and we used to use isql&#39;s Form query feature but I&#39;ve fo=
und
      that missing from a4gl. Is there a way to get similar
      functionality? We would like an easy way (not SQL) to quickly
      enter some terms into an existing form like the isql -&gt; form
      -&gt; run feature of informix.</p>
    <p>Our data is now in PostgreSQL and the closest thing I&#39;ve found
      instead of using a4gl is Postbird, but it only allows you to
      filter on one field at a time. pgAdmin is way over the top for us.</p=
>
    <p>Any ideas would be great.<br>
    </p>
    <div>-- <br>
      <div dir=3D"ltr">
        <div>Regards,</div>
        <div><br>
        </div>
        <font size=3D"1">Michael Pope</font><br>
      </div>
    </div>
  </div>

_______________________________________________<br>
Aubit4gl-discuss mailing list<br>
<a href=3D"mailto:[email protected]" target=3D"_blank"=
>[email protected]</a><br>
<a href=3D"https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss" r=
el=3D"noreferrer" target=3D"_blank">https://lists.sourceforge.net/lists/lis=
tinfo/aubit4gl-discuss</a><br>
</blockquote></div>

--0000000000008923770603306eb5--


--===============2499517167118606513==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline


--===============2499517167118606513==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Aubit4gl-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss

--===============2499517167118606513==--