How to create Updatable BAQ

Yahoo Archive
1
Thanks Chad.
Really appreciate your help.
--- In vantage@yahoogroups.com, "Chad Smith" <csmith@...> wrote:
>
> The Primary Index fields just need to exist in the query. If you're layering a dashboard on top of it, they do not need to be displayed.
>
> As to the other fields that are mandatory, that's up to you. Since you aren't creating new records, the mandatory fields should already be filled in. So really, I'd only include them if they provide some value to the query you are running.
>
> --- In vantage@yahoogroups.com, "Kiran" <saini.kiran17@> wrote:
> >
> >
> > Hi Chad,
> >
> > Finally done as I was ignoring primary index. Now I added n its working now. Thanks for your great support.
> >
> > Its working but I have one doubt. For updating should I add all the mandatory fields & other non- mandatory fields which are mention in Method Directives .
> >
> > I checked all in mandatory fields & other non- mandatory fields in Method Directives . Am I doing this process correctly ?
> >
> > Please suggest.
> >
> > Thanks
> > Kiran
> >
> >
>
2
Hi Friends,

I need help in creating BAQ. I just learnt to create simple BAQ and now I am doing Updatable BAQ . I am using customer table & trying to update it through BAQ.

Does anybody know ? How to do this ?

Thanks for help in advance :-)
3
You need to be using Epicor 9 to have Updatable BAQs. There is a tab in the BAQ designer and and a check box to make the BAQ updatable and allow you to choose the Business Object you need to write your information back to the Database.

In your case I would start with the Business object Customer Entry depending on the fields you wish to update. Remember you can only update one table in a BAQ.

Kent

To: vantage@yahoogroups.com
From: saini.kiran17@...
Date: Thu, 25 Jul 2013 15:20:04 +0000
Subject: [Vantage] How to create Updatable BAQ


























Hi Friends,



I need help in creating BAQ. I just learnt to create simple BAQ and now I am doing Updatable BAQ . I am using customer table & trying to update it through BAQ.



Does anybody know ? How to do this ?



Thanks for help in advance :-)



















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

Yes, I am using 9.05.700. I am new so BAQ & Epicor. So first I learnt to create simple BAQ and now I want to learn updatable BAQ.

I am using customer table for testing and using only 3 fields.

I have confusion in Update tab where there are two sub tabs :

General processing & Update processing ....

can you explain me how to do this step.


Thanks
Kiran
--- In vantage@yahoogroups.com, Kent Rooen <krrooen25@...> wrote:
>
> You need to be using Epicor 9 to have Updatable BAQs. There is a tab in the BAQ designer and and a check box to make the BAQ updatable and allow you to choose the Business Object you need to write your information back to the Database.
>
> In your case I would start with the Business object Customer Entry depending on the fields you wish to update. Remember you can only update one table in a BAQ.
>
> Kent
>
> To: vantage@yahoogroups.com
> From: saini.kiran17@...
> Date: Thu, 25 Jul 2013 15:20:04 +0000
> Subject: [Vantage] How to create Updatable BAQ
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Hi Friends,
>
>
>
> I need help in creating BAQ. I just learnt to create simple BAQ and now I am doing Updatable BAQ . I am using customer table & trying to update it through BAQ.
>
>
>
> Does anybody know ? How to do this ?
>
>
>
> Thanks for help in advance :-)
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
Go to the update tab and select which column(s) you want to be updatable. Go to the Update Processing tab and uncheck advanced bpm then click the Business Object button and select Customer, in the listbox to the right of the button click ttCustomer. Then at the bottom right of the window click Regenerate BPM Directive.




________________________________
From: Kiran <saini.kiran17@...>
To: vantage@yahoogroups.com
Sent: Thursday, July 25, 2013 11:35 AM
Subject: [Vantage] Re: How to create Updatable BAQ



Hi Kent,

Yes, I am using 9.05.700. I am new so BAQ & Epicor. So first I learnt to create simple BAQ and now I want to learn updatable BAQ.

I am using customer table for testing and using only 3 fields.

I have confusion in Update tab where there are two sub tabs :

General processing & Update processing ....

can you explain me how to do this step.


Thanks
Kiran
--- In vantage@yahoogroups.com, Kent Rooen <krrooen25@...> wrote:
>
> You need to be using Epicor 9 to have Updatable BAQs. There is a tab in the BAQ designer and and a check box to make the BAQ updatable and allow you to choose the Business Object you need to write your information back to the Database.
>Â
> In your case I would start with the Business object Customer Entry depending on the fields you wish to update. Remember you can only update one table in a BAQ.
>Â
> Kent
>Â
> To: vantage@yahoogroups.com
> From: saini.kiran17@...
> Date: Thu, 25 Jul 2013 15:20:04 +0000
> Subject: [Vantage] How to create Updatable BAQ
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>Â
>
>
>
>Â
>
>
>Â Â
>Â Â Â
>Â Â Â
>Â Â Â Hi Friends,
>
>
>
> I need help in creating BAQ. I just learnt to create simple BAQ and now I am doing Updatable BAQ . I am using customer table & trying to update it through BAQ.
>
>
>
> Does anybody know ? How to do this ?
>
>
>
> Thanks for help in advance :-)
>
>
>
>
>
>
>Â Â
>Â Â Â
>
>Â Â
>Â Â
>
>
>
>
>
>
>Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â
>
> [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]
6
Hi Ted,

Thanks for your response. I did same thing. I am getting following error :

Table: , Level:, Type: 3, RowID: 2, Text: Program:bo/Customer/Customer.p Method:Pre108_A1_execute Message:Customer telephone number is needed


I am just using CustId & Address field so why I am getting this error.
& second question Do I need to do something in
Update->General properties .......except selecting Updatable fields ??




--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> Go to the update tab and select which column(s) you want to be updatable. Go to the Update Processing tab and uncheck advanced bpm then click the Business Object button and select Customer, in the listbox to the right of the button click ttCustomer. Then at the bottom right of the window click Regenerate BPM Directive.
>
>
>
>
> ________________________________
> From: Kiran <saini.kiran17@...>
> To: vantage@yahoogroups.com
> Sent: Thursday, July 25, 2013 11:35 AM
> Subject: [Vantage] Re: How to create Updatable BAQ
>
>
>
> Hi Kent,
>
> Yes, I am using 9.05.700. I am new so BAQ & Epicor. So first I learnt to create simple BAQ and now I want to learn updatable BAQ.
>
> I am using customer table for testing and using only 3 fields.
>
> I have confusion in Update tab where there are two sub tabs :
>
> General processing & Update processing ....
>
> can you explain me how to do this step.
>
>
> Thanks
> Kiran
> --- In vantage@yahoogroups.com, Kent Rooen <krrooen25@> wrote:
> >
> > You need to be using Epicor 9 to have Updatable BAQs. There is a tab in the BAQ designer and and a check box to make the BAQ updatable and allow you to choose the Business Object you need to write your information back to the Database.
> >Â
> > In your case I would start with the Business object Customer Entry depending on the fields you wish to update. Remember you can only update one table in a BAQ.
> >Â
> > Kent
> >Â
> > To: vantage@yahoogroups.com
> > From: saini.kiran17@
> > Date: Thu, 25 Jul 2013 15:20:04 +0000
> > Subject: [Vantage] How to create Updatable BAQ
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >Â
> >
> >
> >
> >Â
> >
> >
> >Â Â
> >Â Â Â
> >Â Â Â
> >Â Â Â Hi Friends,
> >
> >
> >
> > I need help in creating BAQ. I just learnt to create simple BAQ and now I am doing Updatable BAQ . I am using customer table & trying to update it through BAQ.
> >
> >
> >
> > Does anybody know ? How to do this ?
> >
> >
> >
> > Thanks for help in advance :-)
> >
> >
> >
> >
> >
> >
> >Â Â
> >Â Â Â
> >
> >Â Â
> >Â Â
> >
> >
> >
> >
> >
> >
> >Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â
> >
> > [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]
>
7
This is a BPM you have as a pre-process on Customer.Update. Looks like it expects to have a phone number populated.
Review you BPM.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Kiran
Sent: 25 July 2013 17:08
To: vantage@yahoogroups.com
Subject: [Vantage] Re: How to create Updatable BAQ



Hi Ted,

Thanks for your response. I did same thing. I am getting following error :

Table: , Level:, Type: 3, RowID: 2, Text: Program:bo/Customer/Customer.p Method:Pre108_A1_execute Message:Customer telephone number is needed

I am just using CustId & Address field so why I am getting this error.
& second question Do I need to do something in
Update->General properties .......except selecting Updatable fields ??

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Ted Koch <tkoch77@...<mailto:tkoch77@...>> wrote:
>
> Go to the update tab and select which column(s) you want to be updatable. Go to the Update Processing tab and uncheck advanced bpm then click the Business Object button and select Customer, in the listbox to the right of the button click ttCustomer. Then at the bottom right of the window click Regenerate BPM Directive.
>
>
>
>
> ________________________________
> From: Kiran <saini.kiran17@...<mailto:saini.kiran17@...>>
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Sent: Thursday, July 25, 2013 11:35 AM
> Subject: [Vantage] Re: How to create Updatable BAQ
>
>
>
> Hi Kent,
>
> Yes, I am using 9.05.700. I am new so BAQ & Epicor. So first I learnt to create simple BAQ and now I want to learn updatable BAQ.
>
> I am using customer table for testing and using only 3 fields.
>
> I have confusion in Update tab where there are two sub tabs :
>
> General processing & Update processing ....
>
> can you explain me how to do this step.
>
>
> Thanks
> Kiran
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Kent Rooen <krrooen25@> wrote:
> >
> > You need to be using Epicor 9 to have Updatable BAQs. There is a tab in the BAQ designer and and a check box to make the BAQ updatable and allow you to choose the Business Object you need to write your information back to the Database.
> >
> > In your case I would start with the Business object Customer Entry depending on the fields you wish to update. Remember you can only update one table in a BAQ.
> >
> > Kent
> >
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > From: saini.kiran17@<mailto:saini.kiran17@>
> > Date: Thu, 25 Jul 2013 15:20:04 +0000
> > Subject: [Vantage] How to create Updatable BAQ
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Hi Friends,
> >
> >
> >
> > I need help in creating BAQ. I just learnt to create simple BAQ and now I am doing Updatable BAQ . I am using customer table & trying to update it through BAQ.
> >
> >
> >
> > Does anybody know ? How to do this ?
> >
> >
> >
> > Thanks for help in advance :-)
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > [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/.<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]
>



[Non-text portions of this message have been removed]
8
We are on 9.05.700C and I have done several of these. What I have found is that on the update process tab all the experssion fields shown in the grid need to be filled in on right column. if you have blanks the easiest way I have found to have these fill in it to go back to the display tab and add those fields to the display. once in a while I have to manually fill in one of these fields with a constant like "current company" or the like.

Then repeat the steps that Ted states to refresh the update processing tab and regenerate the BPM.

Brad Boes
Metalworks


--- In vantage@yahoogroups.com, "Kiran" <saini.kiran17@...> wrote:
>
>
> Hi Ted,
>
> Thanks for your response. I did same thing. I am getting following error :
>
> Table: , Level:, Type: 3, RowID: 2, Text: Program:bo/Customer/Customer.p Method:Pre108_A1_execute Message:Customer telephone number is needed
>
>
> I am just using CustId & Address field so why I am getting this error.
> & second question Do I need to do something in
> Update->General properties .......except selecting Updatable fields ??
>
>
>
>
> --- In vantage@yahoogroups.com, Ted Koch <tkoch77@> wrote:
> >
> > Go to the update tab and select which column(s) you want to be updatable. Go to the Update Processing tab and uncheck advanced bpm then click the Business Object button and select Customer, in the listbox to the right of the button click ttCustomer. Then at the bottom right of the window click Regenerate BPM Directive.
> >
> >
> >
> >
> > ________________________________
> > From: Kiran <saini.kiran17@>
> > To: vantage@yahoogroups.com
> > Sent: Thursday, July 25, 2013 11:35 AM
> > Subject: [Vantage] Re: How to create Updatable BAQ
> >
> >
> >
> > Hi Kent,
> >
> > Yes, I am using 9.05.700. I am new so BAQ & Epicor. So first I learnt to create simple BAQ and now I want to learn updatable BAQ.
> >
> > I am using customer table for testing and using only 3 fields.
> >
> > I have confusion in Update tab where there are two sub tabs :
> >
> > General processing & Update processing ....
> >
> > can you explain me how to do this step.
> >
> >
> > Thanks
> > Kiran
> > --- In vantage@yahoogroups.com, Kent Rooen <krrooen25@> wrote:
> > >
> > > You need to be using Epicor 9 to have Updatable BAQs. There is a tab in the BAQ designer and and a check box to make the BAQ updatable and allow you to choose the Business Object you need to write your information back to the Database.
> > >Â
> > > In your case I would start with the Business object Customer Entry depending on the fields you wish to update. Remember you can only update one table in a BAQ.
> > >Â
> > > Kent
> > >Â
> > > To: vantage@yahoogroups.com
> > > From: saini.kiran17@
> > > Date: Thu, 25 Jul 2013 15:20:04 +0000
> > > Subject: [Vantage] How to create Updatable BAQ
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >Â
> > >
> > >
> > >
> > >Â
> > >
> > >
> > >Â Â
> > >Â Â Â
> > >Â Â Â
> > >Â Â Â Hi Friends,
> > >
> > >
> > >
> > > I need help in creating BAQ. I just learnt to create simple BAQ and now I am doing Updatable BAQ . I am using customer table & trying to update it through BAQ.
> > >
> > >
> > >
> > > Does anybody know ? How to do this ?
> > >
> > >
> > >
> > > Thanks for help in advance :-)
> > >
> > >
> > >
> > >
> > >
> > >
> > >Â Â
> > >Â Â Â
> > >
> > >Â Â
> > >Â Â
> > >
> > >
> > >
> > >
> > >
> > >
> > >Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â
> > >
> > > [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]
> >
>
9
Updateable Queries also require that you have all the fields from the Primary Index included in the query. For the Customer table, this would be Company and CustNum. If those fields don't exist in your query, you'll have problems performing the update.

You can use the Data Dictionary Viewer to find the Primary Index for a given table, but it's hidden by default, so you'll have to perform a customization or personalization to show it.

--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> Go to the update tab and select which column(s) you want to be updatable. Go to the Update Processing tab and uncheck advanced bpm then click the Business Object button and select Customer, in the listbox to the right of the button click ttCustomer. Then at the bottom right of the window click Regenerate BPM Directive.
>
>
>
>
> ________________________________
> From: Kiran <saini.kiran17@...>
> To: vantage@yahoogroups.com
> Sent: Thursday, July 25, 2013 11:35 AM
> Subject: [Vantage] Re: How to create Updatable BAQ
>
>
>
> Hi Kent,
>
> Yes, I am using 9.05.700. I am new so BAQ & Epicor. So first I learnt to create simple BAQ and now I want to learn updatable BAQ.
>
> I am using customer table for testing and using only 3 fields.
>
> I have confusion in Update tab where there are two sub tabs :
>
> General processing & Update processing ....
>
> can you explain me how to do this step.
>
>
> Thanks
> Kiran
> --- In vantage@yahoogroups.com, Kent Rooen <krrooen25@> wrote:
> >
> > You need to be using Epicor 9 to have Updatable BAQs. There is a tab in the BAQ designer and and a check box to make the BAQ updatable and allow you to choose the Business Object you need to write your information back to the Database.
> >Â
> > In your case I would start with the Business object Customer Entry depending on the fields you wish to update. Remember you can only update one table in a BAQ.
> >Â
> > Kent
> >Â
> > To: vantage@yahoogroups.com
> > From: saini.kiran17@
> > Date: Thu, 25 Jul 2013 15:20:04 +0000
> > Subject: [Vantage] How to create Updatable BAQ
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >Â
> >
> >
> >
> >Â
> >
> >
> >Â Â
> >Â Â Â
> >Â Â Â
> >Â Â Â Hi Friends,
> >
> >
> >
> > I need help in creating BAQ. I just learnt to create simple BAQ and now I am doing Updatable BAQ . I am using customer table & trying to update it through BAQ.
> >
> >
> >
> > Does anybody know ? How to do this ?
> >
> >
> >
> > Thanks for help in advance :-)
> >
> >
> >
> >
> >
> >
> >Â Â
> >Â Â Â
> >
> >Â Â
> >Â Â
> >
> >
> >
> >
> >
> >
> >Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â
> >
> > [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]
>
10
Hi Chad,

Finally done as I was ignoring primary index. Now I added n its working now. Thanks for your great support.

Its working but I have one doubt. For updating should I add all the mandatory fields & other non- mandatory fields which are mention in Method Directives .

I checked all in mandatory fields & other non- mandatory fields in Method Directives . Am I doing this process correctly ?

Please suggest.

Thanks
Kiran



--- In vantage@yahoogroups.com, "Chad Smith" <csmith@...> wrote:
>
> Updateable Queries also require that you have all the fields from the Primary Index included in the query. For the Customer table, this would be Company and CustNum. If those fields don't exist in your query, you'll have problems performing the update.
>
> You can use the Data Dictionary Viewer to find the Primary Index for a given table, but it's hidden by default, so you'll have to perform a customization or personalization to show it.
>
> --- In vantage@yahoogroups.com, Ted Koch <tkoch77@> wrote:
> >
> > Go to the update tab and select which column(s) you want to be updatable. Go to the Update Processing tab and uncheck advanced bpm then click the Business Object button and select Customer, in the listbox to the right of the button click ttCustomer. Then at the bottom right of the window click Regenerate BPM Directive.
> >
> >
> >
> >
> > ________________________________
> > From: Kiran <saini.kiran17@>
> > To: vantage@yahoogroups.com
> > Sent: Thursday, July 25, 2013 11:35 AM
> > Subject: [Vantage] Re: How to create Updatable BAQ
> >
> >
> >
> > Hi Kent,
> >
> > Yes, I am using 9.05.700. I am new so BAQ & Epicor. So first I learnt to create simple BAQ and now I want to learn updatable BAQ.
> >
> > I am using customer table for testing and using only 3 fields.
> >
> > I have confusion in Update tab where there are two sub tabs :
> >
> > General processing & Update processing ....
> >
> > can you explain me how to do this step.
> >
> >
> > Thanks
> > Kiran
> > --- In vantage@yahoogroups.com, Kent Rooen <krrooen25@> wrote:
> > >
> > > You need to be using Epicor 9 to have Updatable BAQs. There is a tab in the BAQ designer and and a check box to make the BAQ updatable and allow you to choose the Business Object you need to write your information back to the Database.
> > >Â
> > > In your case I would start with the Business object Customer Entry depending on the fields you wish to update. Remember you can only update one table in a BAQ.
> > >Â
> > > Kent
> > >Â
> > > To: vantage@yahoogroups.com
> > > From: saini.kiran17@
> > > Date: Thu, 25 Jul 2013 15:20:04 +0000
> > > Subject: [Vantage] How to create Updatable BAQ
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >Â
> > >
> > >
> > >
> > >Â
> > >
> > >
> > >Â Â
> > >Â Â Â
> > >Â Â Â
> > >Â Â Â Hi Friends,
> > >
> > >
> > >
> > > I need help in creating BAQ. I just learnt to create simple BAQ and now I am doing Updatable BAQ . I am using customer table & trying to update it through BAQ.
> > >
> > >
> > >
> > > Does anybody know ? How to do this ?
> > >
> > >
> > >
> > > Thanks for help in advance :-)
> > >
> > >
> > >
> > >
> > >
> > >
> > >Â Â
> > >Â Â Â
> > >
> > >Â Â
> > >Â Â
> > >
> > >
> > >
> > >
> > >
> > >
> > >Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â
> > >
> > > [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]
> >
>
11
The Primary Index fields just need to exist in the query. If you're layering a dashboard on top of it, they do not need to be displayed.

As to the other fields that are mandatory, that's up to you. Since you aren't creating new records, the mandatory fields should already be filled in. So really, I'd only include them if they provide some value to the query you are running.

--- In vantage@yahoogroups.com, "Kiran" <saini.kiran17@...> wrote:
>
>
> Hi Chad,
>
> Finally done as I was ignoring primary index. Now I added n its working now. Thanks for your great support.
>
> Its working but I have one doubt. For updating should I add all the mandatory fields & other non- mandatory fields which are mention in Method Directives .
>
> I checked all in mandatory fields & other non- mandatory fields in Method Directives . Am I doing this process correctly ?
>
> Please suggest.
>
> Thanks
> Kiran
>
>