Looking for the old forum?

For topics posted before June 2015, please click here to visit the old support forum. Post your questions in this forum if you have any questions.

Support Forums
PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 22 Feb 2016 07:34 PM by  Dblackmon
Question about editing data
 1 Replies
You are not authorized to post a reply.
Author Messages

New Member

New Member

22 Feb 2016 07:34 PM
    I have built an interface to directly interact with the FlexBooking Table to allow my to better sort and filter the data, and at times modify some of the data fields quickly. I noticed that if I modify the data of an event it will no longer show up as an available event in the list to the general public. However if I go into the FlexEvent module and select Manage Events I can open the same one I edited outside of your module and not make a single change and just click "Update" and it will show back up in the list.

    I have compared the data before and after and the only difference is the fact your module updates the last modified date column, and I don't when I manually change it. Am I missing something becasue I would not have though this would make a difference.

    Basic Member

    Basic Member

    27 Feb 2016 11:05 PM
    I have 2 proposals:

    1, instead of make the changes by your own sql scripts, you can try to call the FlexEventUpdate procedure to update the record you wish to update.

    2, show me the sql scripts you use used to update the record. and tell me which columns are modified, so I can try to reproduce it locally.
    You are not authorized to post a reply.

    Copyright © 2005-2013 BizModules Contact us