|Subject:||Re: Postgresql connection
|Date:||Sun, 3 Feb 2019 11:27:23 +1100
|From:||Tom Krieg <REMOVEtomkCAPITALS@sdassociates.com.au>
Yes, you still need the BDE. HOWEVER, if you design everything
correctly, you can have a library that handles the calls to the SQL
database, use pass-through SQL (i.e. don't use the pgSQL database in
TCursors or the data model) and use SQL to extract subsets of the
database to local (priv) tables for forms, reports etc etc. There is an
easy way to display records (extracted from a SQL database to priv) in a
tableframe and trap datapost or dataunlock, format an UPDATE query and
send that to the database. So if users update a record in a TF, the
update is immediately pushed to the pgSQL server. If you think it
through carefully you will have a quick and efficient database that has
none of the Paradox limitations, index problems or RI problems. Also,
users do not need to have localshare=TRUE and don't need to share a NET
Better still, if you put all your business logic, update logic and
extract logic in functions, the database server handles those for you.
Just use Paradox for display windows, the GUI and reports.
Mark Bannister wrote on 3/02/2019 3:27 AM:
> So, I can't completely get rid of BDE then? Everything still goes
> through BDE?
> On 2/1/2019 7:22 PM, Tom Krieg wrote:
>> If your BDE isn't configured to create ODBC aliases automatically,
>> then yes.
>> Mark Bannister wrote on 2/02/2019 9:39 AM:
>>> I'm confused.
>>> I've seen a few posts about using postgresql but am unclear about the
>>> role of the BDE.
>>> I created a System ODBC connection to my postsgres server.
>>> Now do I have to create an alias in the BDE....?
>>> Mark B