On 8/6/2013 1:04 PM, Tim Frost wrote:
> I can change a string or value in the biolife table, hit return to fix it, click commit, and see the XML file timestamp update.  And usually, the data in the XML file is updated to match.  But sadly not always. After a while the data in the browser is updated, and the file is rewritten, but with no change to the data in the file. If I decide to persist with the XML solution, I will do some more experimentation with different browsers and run the module code in an elevated delphi debugger to try to work out what is going on.  It may be some sort of browser issue.  And I will start a separate thread if I still have a problem.

I can't say i noticed any issues with updates but then again i did not
do tons of testing and everything is on LAN so network connection always
works

Once "gotcha" if you would is that  everything is async and data is
loosely coupled - TDataSet in the EWB app (browser) is a copy of data
from the server without any "live" link between them.

Changes made during a transaction are reflected in local tdataset but
only make it to server if you commit and the post is actually processed
on the server.

Hence dealing with network connection failures and such is needed even
more than when writing delphi DB apps. Check out the OnCommitError on
TDatabase as well as GetTransactions method.

Raul

Tim,

<< On the other hand, Tim may have persuaded me to purchase ElevateDB, and
certainly to try it!  And if not, I may take him up on his offer to look at
what might be wrong with using SQLite and ODBC.  I accept that it is more
than likely to be an issue not connected with EWB. >>

Just a quick note on EDB:  I'm working very hard on getting a Linux version
of the EDB PHP Extension done by next week as part of the porting project
for EDB (Linux and MacOS).  I'm first doing Linux because a) EDB had most of
the Linux support done already, and b) it is really needed as an option for
existing customers in order to get an EWB application up-and-running quickly
on low-cost hosting providers like HostGator, etc.  Once it's done, anyone
can deploy an EWB<->EDB application on such a web host with minimal PHP
scripting required since the EDB PHP extension will handle all of the JSON
for the datasets, similarly to the dataset adapters that we provide for EWB
Server modules.

Once I'm done, we'll probably do another promotion for the EDB PHP Extension
and I think we're considering bundling it with EWB also.

Tim Young
Elevate Software
www.elevatesoft.com

<< Just a quick note on EDB:  I'm working very hard on getting a Linux version
of the EDB PHP Extension done by next week as part of the porting project
for EDB (Linux and MacOS).  I'm first doing Linux because a) EDB had most of
the Linux support done already, and b) it is really needed as an option for
existing customers in order to get an EWB application up-and-running quickly
on low-cost hosting providers like HostGator, etc.  Once it's done, anyone
can deploy an EWB<->EDB application on such a web host with minimal PHP
scripting required since the EDB PHP extension will handle all of the JSON
for the datasets, similarly to the dataset adapters that we provide for EWB
Server modules.

Once I'm done, we'll probably do another promotion for the EDB PHP Extension
and I think we're considering bundling it with EWB also.  >>

That's fantastic news, at least for me.  Thanks Tim!

- Steve