PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → Oracle Native Driver and Syncing of Data (PreSales Question)
Oracle Native Driver and Syncing of Data (PreSales Question)
Débuté par Brent Siler, 05 jan. 2005 18:44 - 1 réponse
#1
Posté le 05 janvier 2005 - 18:44
We are looking to build an application for our field reps and would like to utilize the Hyper File database for the remote users but need to sync their data back to corporate running Oracle RDBMS on Linux.

Question: Can the Hyper File Database be replicated back to an oracle database using the WinDev Native Oracle Driver? or Does it have to be Hyper File to Hyper File?

Could someone provide me their experience and overview if they have had to tackle this same type of problem?
#2
Posté le 07 janvier 2005 - 13:30
A limitation of Windev is that you can cannot use two connections at a time
in a query or update multiple tables in on query.
For example joining your local HF table to the corrsponding remote database
table in a join won't work and then slect all with a timestamp difference
won't work.

You will have to write the code to read the data from HF, check to see if it
needs to be synchronised remotely and then update, delete or insert the data
into the remote database. It works but requires more code. Regarding the
Native Access Oracle performance I can't comment.

With Native Access Progress i noticed a huge performance difference in
favour of Ms Access using ODBC. But this driver is relatively new for PcSoft
and the issue has been reported and will hopefully be adressed. Windev will
give you a full RAD tool with lots of good examples.

Fred

"Brent Siler" <brents@expworld.com> wrote in message
news:41dc0f0f@news.pcsoft.fr...


We are looking to build an application for our field reps and would like
to utilize the Hyper File database for the remote users but need to sync
their data back to corporate running Oracle RDBMS on Linux.

Question: Can the Hyper File Database be replicated back to an oracle
database using the WinDev Native Oracle Driver? or Does it have to be
Hyper File to Hyper File?

Could someone provide me their experience and overview if they have had to
tackle this same type of problem?


→ Revenir à WINDEV 2024