Is there a documented way to fully enter a transaction through only SQL statements? I'm currently loading information from an online store into the Transactions on Hold table and then having an auto-it script pull up the order and run it through. It is 99% effective but sometimes messes up and has to be restarted. Also, though I originally had it running in a virtualized enviornment, it was extremely slow at times and now requires a standalone PC to run. It would be nice if I could just run all of the SQL statements that would full enter the transaction as if I had hit the tender button at the POS. If anyone has any ideas for this please let me know.
Enter Transaction through SQL
Sep 23, 2010
1 Replies
Is there a documented way to fully enter a transaction through only SQL statements? I'm currently loading information from an online store into the Transactions on Hold table and then having an auto-it script pull up the order and run it through. It is 99% effective but sometimes messes up and has to be restarted. Also, though I originally had it running in a virtualized enviornment, it was extremely slow at times and now requires a standalone PC to run. It would be nice if I could just run all of the SQL statements that would full enter the transaction as if I had hit the tender button at the POS. If anyone has any ideas for this please let me know.
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required