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.
- posted
13 years ago