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 "runforms.4ae" - 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= <<a href=3D"mailto:[email protected]">[email protected]</a>>= 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's Form query feature but I'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 -> form -> run feature of informix.</p> <p>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.</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==--