General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
The posting program does not have any settings that allow for just deleting a record. In fact, It will not do anything until it has exclusive use. It will display a message at the bottom of the form "waiting for exclusive use" Once it has exclusive use it will post the records to the business system, making adjustments as needed. And then it will purge the records in the table.
The posting program runs on my server and it is always on. I think it operates on a timer and checks periodically to see if new records have been added and if they have it tries to post.
My foxpro application sits on workstations around our shop, There are 16 of these workstations. Each workstation has a laser barcode wand where employees clockin in and out of jobs. That is the only function of these 16 PC's, collecting barcode data.
An employee clocks off of a job, I do validation make adjustments etc... then I hand off the data to the posting table. My application makes an entry via insert. Then closes the table. Once the table is closed the posting program takes it from there.
Unless every station closes the table when it gets done, nothing will get posted.
It's like I need to be able to close that table on all those machines from a remote location. And then do my posting. I would need that level of control to make it work.
My application runs slow when processing multiple entries. It's just a guess that this opening and closing is the culprit.
Sounds like im stuck with the speed issue, it's more important that the data is posted asap. Otherwise the SPC data is not up to date.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only