2. PHPRunner General questions
  3. [SOLVED]  Finalize entries, place timestamp and lock user from system
This topic is locked
[SOLVED]

 Finalize entries, place timestamp and lock user from system

 		8/15/2012 2:59:17 PM
PHPRunner General questions
J
 jmccullough author

I have created a joint purchasing database where vendors log in and bid on certain items. What I need now is that when the vendors have finished placing all of their bids is to have them click on a "Finalize your Bids" button that will:

  1. produce a msgbox warning them that they are about to finalize their bids and will be locked out of the system (and give them the option to cancel or continue).
  2. place a timestamp (date/time) in field in the database of when they finalized their bids (required for awarding bids to who submitted bids earliest)
  3. disable vendor password in Users table so they can't log in again to modify their bids.
    I have this working perfectly in an access database but am at a loss of how to do this in PHPRunner.
    Am working in PHPRunner 6.1
    Any help would be appreciated.
C
 		cgphp 8/15/2012

You can start from here: http://xlinesoft.com/phprunner/docs/inserting_button.htm
J
 		jmccullough author 8/15/2012

Thanks for the reply. I have added the button to my List page and it displays a message but doesn't give the option to "continue or cancel". Also, I'm not sure how to update the record modified field or lock the user out.
C
 		cgphp 8/15/2012

The link above tells you more about button and its functionality. Check the examples at the bottom of the article.
J
 		jmccullough author 8/23/2012



The link above tells you more about button and its functionality. Check the examples at the bottom of the article.
J
 		jmccullough author 8/23/2012

Thank you, I have followed the example and added a button and code to my list page but when I test the button I receive message "sending request to server....." and the fields are not updated.
Sergey Kornilov admin 8/23/2012

Most likely this is some sort of error in buttons OnServer event.
I recommend to check this article for troubleshooting tips:

http://xlinesoft.com/blog/2012/05/16/troubleshooting-custom-buttons-in-phprunner-and-asprunnerpro-applications/