UpdateTableBuffer.p for a ComboBox

Yahoo Archive
1
Back in May I was trying to get this to work and still have not been successful. When the BPM runs it does present the value in the combobox on the Release Tab. But after I hit refresh the value in the field goes away. I have message boxes after the UpdateTableBuffer in the BPM that shows both ttOrderRel.Character04 and OrderRel.Character04 are displaying to the proper value. I set up a quick Crystal Report to see if reading the database directly shows the value and right after the BPM runs Character03 for that Order Release is blank. So even though the messagebox seems to indicate that OrderRel.Character03 is set to the proper value, it is not truly written to the database. The comboboxes are set to choose from 3 static values.

Do I need to do something with what entry value need to be chosen?

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Steven Gotschall
Sent: Monday, May 17, 2010 2:18 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] UpdateTableBuffer.p for a ComboBox

Are you updating both the ttOrderRel and the OrderRel tables with the same values in the post process? Another thing I have found usefull is to trigger the BPM on the PreProcessing and then enable the dependent post process directives. Another thing to check is to make sure you are on the record of the ttOrderRel or ttOrderHed that you expect to be on. I have found that based on the conditions you use, the current record isn't always what you expect it to be.




________________________________
From: Scott Litzau <scott.litzau@...>
To: vantage@yahoogroups.com
Sent: Mon, May 17, 2010 3:01:58 PM
Subject: RE: [Vantage] UpdateTableBuffer.p for a ComboBox


I do have the BPM as a Post Process.

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Steven Gotschall
Sent: Monday, May 17, 2010 11:47 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] UpdateTableBuffer.p for a ComboBox

I don't think your problem has anything to do with the combo boxes. The updatetablebuffer works directly on the field in the table and it doesn't care what type of control you may be bound to it. Your problem sounds more like one I ran into before where the Header is updated and changes to the release in a BPM causes the "record has been modified" message.

Vantage will not "update" a table unless a value has changed. So when you hit the save button and something has changed in the header but not the release, then only the header table gets updated. If in the BPM you modify something in a preprocess release, there is now a difference in what is on the form (temp tables) and what is in the database and Vantage thinks someone else must have updated it.

I have been able to get around this by updating the release in a post process BPM (both the tt temp table and the database table).

________________________________
From: litzer1 <scott.litzau@...>
To: vantage@yahoogroups.com
Sent: Mon, May 17, 2010 10:39:52 AM
Subject: [Vantage] UpdateTableBuffer.p for a ComboBox

I have a BPM that updates a combobox on Order Release from a value in a combobox on Order Header but I am getting the "Record has been modified by another user" error becuase it does not appear thet the UpdateTableBuffer.p works for comboboxes. I tested the BPM using a Text box on Order Releaser and the BPM works without issue.

Anyone know how to have the value of a combobox updated in a BPM.

Thanks,

Scott

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links







[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
2
I have a BPM that updates a combobox on Order Release from a value in a combobox on Order Header but I am getting the "Record has been modified by another user" error becuase it does not appear thet the UpdateTableBuffer.p works for comboboxes. I tested the BPM using a Text box on Order Releaser and the BPM works without issue.

Anyone know how to have the value of a combobox updated in a BPM.

Thanks,

Scott
3
I don't think your problem has anything to do with the combo boxes. The updatetablebuffer works directly on the field in the table and it doesn't care what type of control you may be bound to it. Your problem sounds more like one I ran into before where the Header is updated




________________________________
From: litzer1 <scott.litzau@...>
To: vantage@yahoogroups.com
Sent: Mon, May 17, 2010 10:39:52 AM
Subject: [Vantage] UpdateTableBuffer.p for a ComboBox

Â
I have a BPM that updates a combobox on Order Release from a value in a combobox on Order Header but I am getting the "Record has been modified by another user" error becuase it does not appear thet the UpdateTableBuffer.p works for comboboxes. I tested the BPM using a Text box on Order Releaser and the BPM works without issue.

Anyone know how to have the value of a combobox updated in a BPM.

Thanks,

Scott







[Non-text portions of this message have been removed]
4
I don't think your problem has anything to do with the combo boxes. The updatetablebuffer works directly on the field in the table and it doesn't care what type of control you may be bound to it. Your problem sounds more like one I ran into before where the Header is updated and changes to the release in a BPM causes the "record has been modified" message.

Vantage will not "update" a table unless a value has changed. So when you hit the save button and something has changed in the header but not the release, then only the header table gets updated. If in the BPM you modify something in a preprocess release, there is now a difference in what is on the form (temp tables) and what is in the database and Vantage thinks someone else must have updated it.

I have been able to get around this by updating the release in a post process BPM (both the tt temp table and the database table).





________________________________
From: litzer1 <scott.litzau@...>
To: vantage@yahoogroups.com
Sent: Mon, May 17, 2010 10:39:52 AM
Subject: [Vantage] UpdateTableBuffer.p for a ComboBox

Â
I have a BPM that updates a combobox on Order Release from a value in a combobox on Order Header but I am getting the "Record has been modified by another user" error becuase it does not appear thet the UpdateTableBuffer.p works for comboboxes. I tested the BPM using a Text box on Order Releaser and the BPM works without issue.

Anyone know how to have the value of a combobox updated in a BPM.

Thanks,

Scott







[Non-text portions of this message have been removed]
5
I do have the BPM as a Post Process.

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Steven Gotschall
Sent: Monday, May 17, 2010 11:47 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] UpdateTableBuffer.p for a ComboBox

I don't think your problem has anything to do with the combo boxes. The updatetablebuffer works directly on the field in the table and it doesn't care what type of control you may be bound to it. Your problem sounds more like one I ran into before where the Header is updated and changes to the release in a BPM causes the "record has been modified" message.

Vantage will not "update" a table unless a value has changed. So when you hit the save button and something has changed in the header but not the release, then only the header table gets updated. If in the BPM you modify something in a preprocess release, there is now a difference in what is on the form (temp tables) and what is in the database and Vantage thinks someone else must have updated it.

I have been able to get around this by updating the release in a post process BPM (both the tt temp table and the database table).





________________________________
From: litzer1 <scott.litzau@...>
To: vantage@yahoogroups.com
Sent: Mon, May 17, 2010 10:39:52 AM
Subject: [Vantage] UpdateTableBuffer.p for a ComboBox


I have a BPM that updates a combobox on Order Release from a value in a combobox on Order Header but I am getting the "Record has been modified by another user" error becuase it does not appear thet the UpdateTableBuffer.p works for comboboxes. I tested the BPM using a Text box on Order Releaser and the BPM works without issue.

Anyone know how to have the value of a combobox updated in a BPM.

Thanks,

Scott







[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
6
Are you updating both the ttOrderRel and the OrderRel tables with the same values in the post process? Another thing I have found usefull is to trigger the BPM on the PreProcessing and then enable the dependent post process directives. Another thing to check is to make sure you are on the record of the ttOrderRel or ttOrderHed that you expect to be on. I have found that based on the conditions you use, the current record isn't always what you expect it to be.




________________________________
From: Scott Litzau <scott.litzau@...>
To: vantage@yahoogroups.com
Sent: Mon, May 17, 2010 3:01:58 PM
Subject: RE: [Vantage] UpdateTableBuffer.p for a ComboBox

Â
I do have the BPM as a Post Process.

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Steven Gotschall
Sent: Monday, May 17, 2010 11:47 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] UpdateTableBuffer.p for a ComboBox

I don't think your problem has anything to do with the combo boxes. The updatetablebuffer works directly on the field in the table and it doesn't care what type of control you may be bound to it. Your problem sounds more like one I ran into before where the Header is updated and changes to the release in a BPM causes the "record has been modified" message.

Vantage will not "update" a table unless a value has changed. So when you hit the save button and something has changed in the header but not the release, then only the header table gets updated. If in the BPM you modify something in a preprocess release, there is now a difference in what is on the form (temp tables) and what is in the database and Vantage thinks someone else must have updated it.

I have been able to get around this by updating the release in a post process BPM (both the tt temp table and the database table).

________________________________
From: litzer1 <scott.litzau@...>
To: vantage@yahoogroups.com
Sent: Mon, May 17, 2010 10:39:52 AM
Subject: [Vantage] UpdateTableBuffer.p for a ComboBox

I have a BPM that updates a combobox on Order Release from a value in a combobox on Order Header but I am getting the "Record has been modified by another user" error becuase it does not appear thet the UpdateTableBuffer.p works for comboboxes. I tested the BPM using a Text box on Order Releaser and the BPM works without issue.

Anyone know how to have the value of a combobox updated in a BPM.

Thanks,

Scott

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links







[Non-text portions of this message have been removed]