Your desire sounds like a good application for using a UD table that could act as the extended data bridge to give you what you want across all the applications and native datasets involved.
There would undoubtedly end up being some field value redundancy that might upset RDB purists - but so what (if it gets you the result you want).
Rob
There would undoubtedly end up being some field value redundancy that might upset RDB purists - but so what (if it gets you the result you want).
Rob
--- On Wed, 3/25/09, brychanwilliams <brychanwilliams@...> wrote:
From: brychanwilliams <brychanwilliams@...>
Subject: [Vantage] Re: Calling Specific Dataset
To: vantage@yahoogroups.com
Date: Wednesday, March 25, 2009, 4:46 AM
Hi Rob,
Yeb, understand. I am coding and using tools to pull data through but in this example I am not altering the data in the progress db I am just adding to the preconfigured datasets/views. Due to the way we use vantage most of the time the inbuilt data tools in customisation won't do so there is amount of coding to pull through and create new data on the fly. I understand that in epicor 9 the functionality exists for users to create like columns on the fly?
This would be great for us to have one dataset that you could call all the time. In our case, we use projects quite heavily but not in the 'Vantage' way. So for example in projects there is a data set called ProjectPO. This holds very little info. but if I could modify this then I could use this dataset in the purchasing routines to compare to budgets etc. I can do this through programming per form / method but just adds another level... and also would provide some speed benefits.
Thanks again.
--- In vantage@yahoogroups .com, Robert Brown <robertb_versa@ ...> wrote:
>
>
> I wouldn't advise modifying data tables at the Progress of SQL level. You'd just be giving Epicor an out to not provide support.
>
> With VB, you can certainly create your own temp data table arrays on the fly (in the client app) that can be a construct from numerous data sources (FKV's Subtable Views, native views, UD tables linked in via code, and even ODBC/SQL derived data).
>
> The array data (once built) can then be displayed in an ultragrid. It is all hand written code though... The (lame) customization wizard will not aid you in doing it at all. Microsoft's TechNet almost assuredly has solid (& free - effectively public domain) code examples of how to do this.
>
> Rob
>
>
>
> --- On Tue, 3/24/09, brychanwilliams <brychanwilliams@ ...> wrote:
>
> From: brychanwilliams <brychanwilliams@ ...>
> Subject: [Vantage] Re: Calling Specific Dataset
> To: vantage@yahoogroups .com
> Date: Tuesday, March 24, 2009, 11:23 AM
>
>
>
>
>
>
> Hi Rob,
>
> Thanks found it through the BLT , so should be ok but thanks for the quick response. Do you know whether it is possible through the BLT to modify data sets. There is a tip on epicweb that mention this when using dashboard with a uD table in it to join up the ud table. IT would be very useful as I use alot of customisation, alot from this group to either extend existing ultragrids or create to datasources within the ui. I was just wondering if you can get the blt to modify datasets then this would help greatly. Assuming that the datasets are affectively views....
>
> --- In vantage@yahoogroups .com, Robert Brown <robertb_versa@ ...> wrote:
> >
> >
> > The application is likely using a view of the true table. Sometimes these views are true one-to-one relatable to the true tables but often they are not. (They are compound views from multiple tables, temp table data, or a limited subset of the true single table.)
> >
> > Put on Tracing and make a change to Project related field values for a record. That will reveal the actaul table & field name(s) and the BO method(s) invoked.
> >
> > Rob
> >
> > --- On Tue, 3/24/09, brychanwilliams <brychanwilliams@ ...> wrote:
> >
> > From: brychanwilliams <brychanwilliams@ ...>
> > Subject: [Vantage] Calling Specific Dataset
> > To: vantage@yahoogroups .com
> > Date: Tuesday, March 24, 2009, 9:56 AM
> >
> >
> >
> >
> >
> >
> > Hi,
> >
> > In the project tracker form there is a dataset called Project PO. Is it possible to call this from another form using business objects. Tried looking around the zdatas etc but without any luck. Just wondering if someone could point me in the right direction,
> >
> > Thanks
> >
>