Re: how to copy live paradox tables

"Steven Green" wrote:

nope.. if the app aborts, crashes, etc.. the entry is left open, just like
the lock file (g)

======================

As I indicated, one would have to write code to handle this potential issue.

One way to do this is to have all clients periodically update a timestamp
field in the Logon table (that I mentioned in the previous post) via an Opal
timer (say, every 3 or 5 minutes). This could be handled by your
applications Hidden Desktop Form which most apps have to handle custom
menus.

Now, anyone listed in the Login Table indicating that they are "logged on",
should never have a timestamp which exceeds the difference between now() and
the set timer period. If someone's timestamp does exceed the timer
period, then you know that they are simply no longer logged in (ie; they
"crashed" out of the program).

Upon discovering this error, you would then have your application write the
error to an error log and now that false or miss leading login record can be
safely deleted from the login table.

If the error log file continues to report this error message being produced
by the same person... (ie; you have a problem child) then you need to have a
talk with them.

But this would let you know if its safe to delete any BDE LCK files that
might be hanging around and if its safe to rename the data directory and
copy your data tables.

While this sounds complicated... it really isn't. I believe using a table
in the NET Dir to track who is on line and who isn't... is an important and
handy thing to have for all networked applications. Well worth the time and
effort to devise and implement.

--
....
`·.¸¸.·´¯`·.¸¸.·´¯`·-> rodney


.

Relevant Pages

  • Windows XP crashing after every boot and login
    ... My desktop Windows XP SP2 is crashing after every boot and login attempt. ... Frame IP not in any known module. ... Timestamp: unavailable ... Checksum: ...
    (microsoft.public.windowsxp.help_and_support)
  • Security basics
    ... This year I found out with ssh around you need a good password for your own login name. ... Fixed that problem with a real hard password for karl and root has a changable hard password. ... If I have passwords that are safe for an hour, is not my computer safe from tampering? ...
    (Fedora)
  • Re: [RFC][PATCH 0/9] Network receive deadlock prevention for NBD
    ... in order to make remote storage on a lan work properly. ... then gradually widen the scope of what is safe. ... Just for clarification - it will be completely impossible to login using ... infrequent albeit critical for machine recovery. ...
    (Linux-Kernel)
  • Re: [opensuse] Security
    ... than 5 login with wrong password the system erase all home of this user ... However it's an evidence that if a people is rejected for wrong pass, he didn't enter the system and so the data was safe. ... but I was said that the best place for sensitive data is on non connected/wired computer, ...
    (SuSE)
  • Re: Sessions and closing the browser
    ... A session keeps track of everything and a ... > all values removes this and then the cookie is deleted. ... Instead of yes/no store the timestamp. ... If a new login has been done, ...
    (comp.lang.php)