I am running Paradox version 11.0.0.411 with MySQL ODBC driver 3.51. I have
modified by refresh rate setting to 5 seconds. When I open a MySQL table
(File,Open,Table) in Paradox should I not be able to see data updates
occurring through other means? My web runs PHP/MySQL combo and updates the
table I have open in Paradox but I don't see the updates unless I close the
table and open it back up. I am opening with File,Open,Table... no OPAL.

RobbK wrote:

No, not in a MySQL table. Refresh only works for file shared Paradox tables
(and I assume dBase tables).

When you start editing a MySQL record in a tableframe, it will grab the most
recent version of the record. It won't actually lock it (at least, not in a
table version of MySQL that doesn't support locking/transactions).
Otherwise closing and reopening will get the latest updates.

I've had problems in testing trying to interactively edit a MySQL remote
table from a Table->Open directly.

--
Larry DiGiovanni
Digico, Inc.
IT Consulting and Staffing Solutions
www.digicoinc.com
Check out www.thedbcommunity.com for Paradox resources.

Thanks Larry. I too have had problems interactively editing MySQL tables in
Paradox. Too often Paradox won't allow edits due to phantom locks. I'm not
concerned about the editing at this point but was hoping I could get around
the constant opening and closing of tables to see the latest view. I may
just resort to one of the widely available MySQL table viewers. Just can't
get away from good ol Paradox!

"Larry DiGiovanni" <nospam (AT) nospam (DOT) com> wrote

If you want to monitor a log table or something, you could write a quick and
dirty form bound to a local table that you populate once on init and
thereafter on a timer event by running explicit SQL against the remote
database. This way you can control the sort order, the number of records
returned, etc.

--
Larry DiGiovanni
Digico, Inc.
IT Consulting and Staffing Solutions
www.digicoinc.com
Check out www.thedbcommunity.com for Paradox resources.

Maybe you can try the forcerefresh command?

You could put it in a timer or on a "Refresh"-button.

This is what the help files say:

"On an SQL server, a call to forceRefresh forces a read from the server.
This is the only way to get a refresh from the server. forceRefresh only
works on an SQL table if the table has a unique index."

Haven't tested it myself.

Anders

Anders Jonsson wrote:

Me either. Largely due to my aversion to addressing remote tables in
TCursors or Table objects. Comments from guys like you and Jeff have me
wondering if this isn't somehow just pathological on my part. :-)

--
Larry DiGiovanni
Digico, Inc.
IT Consulting and Staffing Solutions
www.digicoinc.com
Check out www.thedbcommunity.com for Paradox resources.

:-)

Not to worry, I never address remote tables in ui.objects. I still use
tCursors sometimes, but I try to do as much with explicit SQL as possible.

Speaking of which, we recently had a demo from a new member in our Swedish
paradox user group - Swebug. He demonstrated a rather big app that he
converted from Paradox to Oracle a few years back. His customer requiered
that the app should be possible to run both against Paradox table and an
Oracle backend. The conversion was done just by switching the aliases and a
few minor modifications!!

He was probably happy he didn't read this NG back then! :-)

Anders

Anders Jonsson wrote:

It's easy to write such an app. Treat the shared data as a data store,
fetch rows for interactive data entry into local tables, lock the remote
rows, then update when done.

Now, starting with a Paradox app where shared data is accessed directly in
forms is a different story. :-)

I would actually have a lot questions for him. Was there any collateral
info from the demo that could be shared and/or would you put us in touch?

--
Larry DiGiovanni
Digico, Inc.
IT Consulting and Staffing Solutions
www.digicoinc.com
Check out www.thedbcommunity.com for Paradox resources.

Yes indeed and I think that was his case!

It was just a short 30 minutes demo with a couple of code snipets which were
non really related to the choice of database.

I will send him a mail tomorrow and ask if he will be kind to post something
here or in the client-server part of pnews.


Anders