Paradox Community

Items in pnews.paradox-client_server

Subject:Re: Postgresql connection
Date:Sun, 3 Feb 2019 11:27:23 +1100
From:Tom Krieg <REMOVEtomkCAPITALS@sdassociates.com.au>
Newsgroups:pnews.paradox-client_server
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 
file.

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
> 


Copyright © 2004 thedbcommunity.com