I am little disappointed that no one was answer my question. I think
that it's really simple to run 4GL procedure from within UD form.
I was trying to open a Open4GL session but there is a problem with
namespaces (This is my guess).
Dim ProgressSession As Progress.Open4GL.DynamicAPI.Session = Nothing
I supposed to use a
Imports Progress
but it doesn't exist with some reasons.
Any help will be appreciated.
Grzegorz Szczepañski
--- In vantage@yahoogroups.com, "Grzegorz (phoenix_)" <phoenix_@...>
wrote:
that it's really simple to run 4GL procedure from within UD form.
I was trying to open a Open4GL session but there is a problem with
namespaces (This is my guess).
Dim ProgressSession As Progress.Open4GL.DynamicAPI.Session = Nothing
I supposed to use a
Imports Progress
but it doesn't exist with some reasons.
Any help will be appreciated.
Grzegorz Szczepañski
--- In vantage@yahoogroups.com, "Grzegorz (phoenix_)" <phoenix_@...>
wrote:
>populated
> Robert,
>
> I am still sustaining my previous statement - "This question is not for
> resolving the specific issue. It's for learning purposes". I know the
> things I would like to learn. I don't want to create a several pages
> message without answer. People don't like to read a message if there is
> a lot of text inside. Therefore my idea was to build scenario with
> elements I would like to learn. After that I want to create a *.odt so
> everyone who want to learn the same things as me will be able to use
> this example.
>
> You were mentioned about Epicor Support, usually they answers are like
> below:
> "These questions are consulting/education questions which should be
> chargeable"
>
> I want to do the following things in my scenario:
> 1. The points 1&2 described previously. I don't know if BAQ Search is
> still usefull here?
> 2. Be able to save the DataSet to UD table
> 3. Be able to have button that let me RUN a progress procedure, with
> possibility to pass a parameter to this procedure (query etc)
>
> I hope that my questions are not theoretical/hypothetically anymore :)
> and that you or someone else will be able to help me.
>
> regards
> Grzegorz Szczepañski
>
> Dnia 26-11-2008 o godz. 6:50 Robert Brown napisa³(a):
> >
> > Elementy potencjalnie niebezpieczne zosta³y zablokowane.
> >
> >
> >
> >
> >
> > Grzegorz,
> >
> > Ah... So this IS a real world need and not just "This question is not
> for resolving the specific issue. It's for learning purposes".
> >
> > You don't say in your original email what you are really trying to do
> (or if you did - sorry - I'm just not following it & I don't get it).
> >
> > In general: Your UD Key# fields (perhaps not all) need to be
> with data to enable the joins you need to Part & PartLot. What thosejoin
> needs are, I won't even hazard a guess unless you can describe a real
> scenario.
> >
> > (That's why they are UD tables - so you can design them for use to
> them as YOU need to native tables.)'search
> >
> > Does that answer the hypothetical question hypothetically enough?
> >
> > :) - Sorry it's one am and I'm VERY tired... Just teasing. No offense
> meant so I hope none taken. I'd be happy to take a stab at a better
> answer with more info from you.
> >
> > ????
> >
> > (Still can't believe Epicor support or the knowledge base on their
> website couldn't provide you more definitive resolution ?!?!?)
> >
> > Rob
> >
> > --- On Tue, 11/25/08, phoenix <phoenix_@...> wrote:
> > From: phoenix <phoenix_@...>
> > Subject: Re: [Vantage] Advanced Customization Scenario
> > To: vantage@yahoogroups.com
> > Date: Tuesday, November 25, 2008, 1:33 PM
> >
> > Robert,
> >
> > so the answer is BAQ Search. I was thinking about it. But also I was
> >
> > trying to avoid this :). The reason for it is that the next step will
> >
> > be fill out the Key1, Key2, Key3, Key4 fields with results from
> >testing.
> > form'. How can I connect results from 'search form' with this fields?
> >
> > If you know that please answer and I will update the scenario and I
> >
> > will start creating the *.odt file for the people.
> >
> > Grzegorz Szczepañski
> >
> > Dnia Tue, 25 Nov :14: (PST)
> >
> > Robert Brown <robertb_versa@ yahoo.com> napisa³(a):
> >
> > > No mystery to #2... Can't believe support couldn't provide immediate
> >
> > > resolution.
> >
> > >
> >
> > > Write a BAQ against UD20, Part & PartLot. You will have to manually
> >
> > > specify the column joins and, depending upon how you are using UD20,
> >
> > > determine if the joins should be inner or outer for best effect.
> >
> > >
> >
> > > Make the BAQ shared (and perhaps Global) & save the BAQ after
> >your
> > >
> >
> > > Reopen the BAQ. In the BAQ Search tab of the editor, move all of
> >(BAQ
> > > available (left pane) Available "Like" columns to the right pane
> >need to
> > > Search "Like columns) and resave. (Backup/export to xml for good
> >
> > > measure.)
> >
> > >
> >
> > > In your UD20 app, the BAQ should now be available as a BAQ search in
> >
> > > the search window.
> >
> > >
> >
> > > If you want, make it a named search and make it the defualt search
> >
> > > for your app.
> >
> > >
> >
> > > Rob
> >
> > >
> >
> > > --- On Tue, 11/25/08, tomojmail <phoenix_@wp. pl> wrote:
> >
> > >
> >
> > > From: tomojmail <phoenix_@wp. pl>
> >
> > > Subject: [Vantage] Advanced Customization Scenario
> >
> > > To: vantage@yahoogroups .com
> >
> > > Date: Tuesday, November 25, 2008, 9:32 AM
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > > This question is not for resolving the specific issue. It's for
> >
> > > learning purposes.
> >
> > > Lot of people from this list can have benefits from the answers that
> >
> > > let us resolve the following scenario:
> >
> > >
> >
> > > 1. We are using one of the Epicor.Mfg.BO. UDxx.dll as starting point
> >
> > > of our scenario. The default 'form' have two sheets 'Detail' and
> >
> > > 'List' sheet.
> >
> > >
> >
> > > TIP/RESOLUTION. To be able to use 'UD20 Maintenance Form' you
> >like
> > > use 'Menu Maintenance' application, then ADD 'new menu' with the
> >
> > > following settings:
> >
> > > Program Type - Menu item
> >
> > > Program - Epicor.Mfg.UI. UD20Entry. dll
> >
> > > For the rest of the settings you can choose whatever you need.
> >
> > >
> >
> > > 2. When 'search button' is pressed it opens the 'search form' in
> >
> > > default it consist of all elements from 'UD20 dataView'. I would
> >tables
> > > to change this 'search form' to display the information from 2
> >results' to
> > > joined by my rules (query).
> >
> > > Table1: Part
> >
> > > Table2: PartLot
> >
> > > Colums for displaying: Part.PartDescriptio n, Part.CostMethod,
> >
> > > PartLot.LotNum, PartLot.OnHand
> >
> > > The 'Search Query': Select PT.PartDescription, PT.CostMethod,
> >
> > > PL.LotNum, PL.OnHand from pub.Part as PT join pub.PartLot as PL on
> >
> > > PT.PartNum = PL.PartNum where PT.PartDescription = PARAMETER
> >
> > > The PARAMETER should be a 'Starting At' from 'search form'
> >
> > >
> >
> > > TIP/RESOLUTION. Waiting for answers.
> >
> > > To be able to complete point 2 we need to answer the following:
> >
> > > (please correct me if I am wrong)
> >
> > > A) (UNANSWERED) Create New dataView or assign the 'search
> >dataView
> > > existing fields of 'UD20 dataView' - I prefer to create a new
> >of this
> > > (it will help to learn of creation and manipulation of dataViews)
> >
> > > B) (UNANSWERED) Send somehow a 'Search Query' to database.
> >
> > > C) (UNANSWERED) Aquire results from database and assign them to
> >
> > > columns in 'search form'
> >
> > >
> >
> > > Currently I am waiting for answers for A, B and C. to resolve point
> >
> > > number 2. I will be maintaining the whole scenario. Moreover I will
> >
> > > create a *.doc or *.odt with screenshots with the answers for
> >
> > > particular steps and it will be available from 'files' section
> >cooperate. So
> > > group. To be able to do this I will need a community to
> >http://klik.wp.pl/?adr=http%3A%2F%2Fcorto.www.wp.pl%2Fas%2Fgraaniola.html&sid=569
> > > people - please answer.
> >
> > >
> >
> > > Grzegorz Szczepañski
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
> ----------------------------------------------------
> Fascynuj±cy labirynt Carlosa Ruiza Zafona, autora Cienia wiatru:
> ¶wiat Barcelony, mroczne sekrety i Cmentarz Zapomnianych Ksi±¿ek w
> najnowszej powie¶ci pt. "Gra anio³a"!
>
>