Updating a User Defined Table

Yahoo Archive
1
Hello Group,



I was wondering if anyone has converted their database from SQL to
Progress or even considered it. We are about to upgrade our server
hardware, which means we have to purchase two new ones, on top of that
Epicor is going to run relatively slower that if it was Progress only.



Mike Tonoyan / Natel EMS

mtonoyan@...


______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________

[Non-text portions of this message have been removed]
2
Hello. I have created a custom tab off the quote entry screen and added a grid that I tied to a UD table view. I have a button that adds quantities to one of the UD fields in the grid. However, this doesn't update the database with the new quantities.

So my question is how can I call the UD01.Update method from the script editor using C#?
3
You can, however if you do things right the grid should do everything for
you.

What version are you on?
If 9+ you can to go Actions or Tools and Wizard then go to Briing in UD
Table as Child go through the wizard and ti will ask you what Keys you
want to relate, say Key1-QuoteNum and Key2=QuoteLine

once youve done this , the script editor will automaticallt be filled with
a TON o code most of which will be for pulling and pushing data into the UD
tables.

After that runs, you should be able to drag a Grid to your Tab and simply
make it a data entry grid, which will generate two events from which you
can call oTrans.Update and GetNewUDXX

Let me know if this is too high level, I am out at Insights but when I get
back I can get you more details.

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Wed, May 9, 2012 at 12:31 PM, altyrocks <alty_rocks@...> wrote:

> **
>
>
> Hello. I have created a custom tab off the quote entry screen and added a
> grid that I tied to a UD table view. I have a button that adds quantities
> to one of the UD fields in the grid. However, this doesn't update the
> database with the new quantities.
>
> So my question is how can I call the UD01.Update method from the script
> editor using C#?
>
>
>


[Non-text portions of this message have been removed]
4
Hi Jose,

Yes, I am running version 9.05.605. I have it working to the point where I can enter data in my UD02 grid and then when I click the button, it will push it to the UD08 grid using this code:

_edvUD08.dataView[_edvUD08.Row]["Number05"] = _edvUD02.dataView[_edvUD02.Row]["Number01"]

This just displays it on the grid however. When I look in the database, the Number05 field still reads the old value of 0. I tried to apply this code:

bool result = _ud08Adapter.Update();

but it returns false so I'm not sure what is going on.

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> You can, however if you do things right the grid should do everything for
> you.
>
> What version are you on?
> If 9+ you can to go Actions or Tools and Wizard then go to Briing in UD
> Table as Child go through the wizard and ti will ask you what Keys you
> want to relate, say Key1-QuoteNum and Key2=QuoteLine
>
> once youve done this , the script editor will automaticallt be filled with
> a TON o code most of which will be for pulling and pushing data into the UD
> tables.
>
> After that runs, you should be able to drag a Grid to your Tab and simply
> make it a data entry grid, which will generate two events from which you
> can call oTrans.Update and GetNewUDXX
>
> Let me know if this is too high level, I am out at Insights but when I get
> back I can get you more details.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Wed, May 9, 2012 at 12:31 PM, altyrocks <alty_rocks@...> wrote:
>
> > **
> >
> >
> > Hello. I have created a custom tab off the quote entry screen and added a
> > grid that I tied to a UD table view. I have a button that adds quantities
> > to one of the UD fields in the grid. However, this doesn't update the
> > database with the new quantities.
> >
> > So my question is how can I call the UD01.Update method from the script
> > editor using C#?
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>