| Carlo Sidari 2005-08-19, 1:27 pm |
| Dear Value VFP developer, here the scenario:
I'm implementing a control access in a Fitness Center app.
The system we have got use a fingerprint reader to grant access to customer.
This reader use a resident program that each time a user touch it,
recognize/does not recognize user's fingerprint.
In any case this program append a record to a predefined MS Access table
(.mdb).
I have a System ODBC that describe this database/table, and I could see
all the record with a remote connection-remote view. End scenario
What I would do is write a light interface that each time a record is
appended pop-up with a message to receptionist (i.e. Carlo Sidari is IN,
or invalid access, or Subscription expired....)
The only way I see, is to write a little class with a timer control that
fires more or less each 0.5 secs requeryng the remote view to see if
there is a new record in the table.
But I'm afraid this solution could be cpu-wasting and
performance-killer.. more, as far the remote view grows, the view
requerying should be heavyer..
The best solution should the viceversa... a trigger that fire each time
a record is appended to the remote view waking-up the message window.
I hope that problem's description it's clear enough...
Thank to all that drop a clue or an opinion...
Carlo Sidari
Italy
|