MES FLEX -help adding search to an entryfield added to Macola screen

[ddozer]

I am working with one of our developers to add a custom field to PP0301M. He has the code written so that when we manually enter a value it writes back to the appropriate field in the ppordhdr_sql. However, we want to add a Macola search to the field but have not been able to do so. Just linking the search up to the field through screen designer does not do anything. I had him reference doc 17.513.795 in te customer portal but in the doc it states that there should be a "click event" available in the VBA where the code to call the search can be added, but he does not see this as an option for the entry field that we added. Also, when setting the tab order of the screen the entryfield will never set focus. You have to manually click on it and then if you click on the search the focus moves to the next field. I'm not sure if that is related or not. Any insight into what we are doing worng would be greatly appreciated.

 

[dgillz]

You should not add an entry field, you should unhide one of the user defined fields. There will be no special code required to save that data to corresponding field in the ppordfil_sql (there is no ppordhdr_sql table) and you will be able to set the tab order. I do not have time to test this but I am about 95% sure this is your problem.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[ddozer]

Hi, thanks for your response (and sorry for my mistype on the ppordfil_sql table, I think I had POs on the brain at the time). Without getting into a ton of the details we don't want to use a user def field because (and it definately will work with the searches) as a majority of our user fields are already being and what we are doing is writting the value imputed into the entry field to the cus_no field. I know is is against normal Macola functionality and this should be filled in from OE on a pulled item, but we need this data to work with our label printing system. If we use a user def field then we will have to either trigger it into the cus_no or do something in Flex to do an extra copy and move it to the right field. Is there maybe a different way to accomplish this?

Thanks for the help!

 

[dgillz]

Looks like you are stuck with writing flex code. I am 99% sure you cannot set tab order or attach searched to VBA entry only fields. You are going to have to use a user defined field for this.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[ddozer]

Thanks for your help. We ended up having to add a button to the form and call the Macola search from the button then write the returned value to our field. And it looks like you are correct about the tab order. No matter what we tried we couldn't get it set.