Simple BAQ - Calculated Field - Error Message

I have the guide, it doesn't show how to handle error messages.

On Jun 1, 2012, at 5:41 PM, "Len Hartka" <len.hartka@...> wrote:

> Good Day Patrick:
>
> There is the "ICE tools User guide" ( MUST be 9.05) which can
> either be bought as a book ( 50 maybe $100) or down loaded from EpicWeb.
> Call helpline for help.
>
>
> Len
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Winter, Patrick
> Sent: Friday, June 01, 2012 6:29 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Simple BAQ - Calculated Field - Error Message
>
> Yes logical
>
> On Jun 1, 2012, at 5:03 PM, "Len Hartka" <len.hartka@...
> <mailto:len.hartka%40sunautomation.com> > wrote:
>
> > Good Day:
> >
> > I pasted your string and it worked.
> >
> > If Menu.OptionSubType = 'R' then yes Else no
> >
> >
> > Do you have the "Data Type" as Logical in the upper screen? If
> > "number" it will fail.
> >
> > len.hartka@... <mailto:len.hartka%40sunautomation.com>
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > Of Ted Koch
> > Sent: Friday, June 01, 2012 5:35 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: Re: [Vantage] Simple BAQ - Calculated Field - Error Message
> >
> > If you save the calculated field and test the BAQ it runs.
> >
> > P.S. - If you take Menu.MenuType out of the displayed columns and run
> > check syntax it says syntax ok.
> >
> > ________________________________
> > From: "Winter, Patrick" <pjw@...
> <mailto:pjw%40specialtyscrew.com>
> > <mailto:pjw%40specialtyscrew.com> >
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > Sent: Friday, June 1, 2012 5:25 PM
> > Subject: [Vantage] Simple BAQ - Calculated Field - Error Message
> >
> > All,
> >
> > Simple BAQ, List the reports on the Menu Structure.
> >
> > Menu Table, List Several Fields, All is well.
> >
> > Testing a calculated field.
> >
> > MyTest, Logical yes/no
> >
> > In the Editor I Type:
> >
> > If Menu.OptionSubType = 'R' then yes Else no
> >
> > CHECK SYNTAX
> >
> > Error:
> >
> > Field formant doesn't coincide with database schema for fields:
> >
> > Menu.MenuType current format: X(20), expected x(10)
> >
> > I'm sure to see many more error messages as I plan to hammer BAQs,
> Where
> > does one go to resolve or find more information on such error
> messages?
> >
> > Patrick Winter
> >
> > [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]
> >
> > This e-mail and any attachments may contain proprietary and/or
> confidential information. If you are not the intended recipient, please
> notify the sender immediately by reply e-mail or at 410-472-2900 and
> then delete the message without using, disseminating, or copying this
> message or any portion thereof. With e-mail communications you are urged
> to protect against viruses.
> >
> > [Non-text portions of this message have been removed]
> >
> >
>
> [Non-text portions of this message have been removed]
>
> This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
>
> [Non-text portions of this message have been removed]
>
>


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



Simple BAQ, List the reports on the Menu Structure.

Menu Table, List Several Fields, All is well.



Testing a calculated field.

MyTest, Logical yes/no

In the Editor I Type:

If Menu.OptionSubType = 'R' then yes Else no



CHECK SYNTAX

Error:

Field formant doesn't coincide with database schema for fields:

Menu.MenuType current format: X(20), expected x(10)



I'm sure to see many more error messages as I plan to hammer BAQs, Where
does one go to resolve or find more information on such error messages?



Patrick Winter





[Non-text portions of this message have been removed]
If you save the calculated field and test the BAQ it runs.


P.S. - If you take Menu.MenuType out of the displayed columns and run check syntax it says syntax ok.



________________________________
From: "Winter, Patrick" <pjw@...>
To: vantage@yahoogroups.com
Sent: Friday, June 1, 2012 5:25 PM
Subject: [Vantage] Simple BAQ - Calculated Field - Error Message

All,



Simple BAQ, List the reports on the Menu Structure.

Menu Table, List Several Fields, All is well.



Testing a calculated field.

MyTest, Logical yes/no

In the Editor I Type:

If Menu.OptionSubType = 'R' then yes Else no



CHECK SYNTAX

Error:

Field formant doesn't coincide with database schema for fields:

Menu.MenuType current format: X(20), expected x(10)



I'm sure to see many more error messages as I plan to hammer BAQs, Where
does one go to resolve or find more information on such error messages?



Patrick Winter





[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/.%c2%a0
(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]
Good Day:

I pasted your string and it worked.

If Menu.OptionSubType = 'R' then yes Else no


Do you have the "Data Type" as Logical in the upper screen? If
"number" it will fail.




len.hartka@...


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ted Koch
Sent: Friday, June 01, 2012 5:35 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Simple BAQ - Calculated Field - Error Message




If you save the calculated field and test the BAQ it runs.

P.S. - If you take Menu.MenuType out of the displayed columns and run
check syntax it says syntax ok.

________________________________
From: "Winter, Patrick" <pjw@...
<mailto:pjw%40specialtyscrew.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Friday, June 1, 2012 5:25 PM
Subject: [Vantage] Simple BAQ - Calculated Field - Error Message

All,

Simple BAQ, List the reports on the Menu Structure.

Menu Table, List Several Fields, All is well.

Testing a calculated field.

MyTest, Logical yes/no

In the Editor I Type:

If Menu.OptionSubType = 'R' then yes Else no

CHECK SYNTAX

Error:

Field formant doesn't coincide with database schema for fields:

Menu.MenuType current format: X(20), expected x(10)

I'm sure to see many more error messages as I plan to hammer BAQs, Where
does one go to resolve or find more information on such error messages?

Patrick Winter

[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]






This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


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

On Jun 1, 2012, at 5:03 PM, "Len Hartka" <len.hartka@...> wrote:

> Good Day:
>
> I pasted your string and it worked.
>
> If Menu.OptionSubType = 'R' then yes Else no
>
>
> Do you have the "Data Type" as Logical in the upper screen? If
> "number" it will fail.
>
> len.hartka@...
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Ted Koch
> Sent: Friday, June 01, 2012 5:35 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Simple BAQ - Calculated Field - Error Message
>
> If you save the calculated field and test the BAQ it runs.
>
> P.S. - If you take Menu.MenuType out of the displayed columns and run
> check syntax it says syntax ok.
>
> ________________________________
> From: "Winter, Patrick" <pjw@...
> <mailto:pjw%40specialtyscrew.com> >
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Sent: Friday, June 1, 2012 5:25 PM
> Subject: [Vantage] Simple BAQ - Calculated Field - Error Message
>
> All,
>
> Simple BAQ, List the reports on the Menu Structure.
>
> Menu Table, List Several Fields, All is well.
>
> Testing a calculated field.
>
> MyTest, Logical yes/no
>
> In the Editor I Type:
>
> If Menu.OptionSubType = 'R' then yes Else no
>
> CHECK SYNTAX
>
> Error:
>
> Field formant doesn't coincide with database schema for fields:
>
> Menu.MenuType current format: X(20), expected x(10)
>
> I'm sure to see many more error messages as I plan to hammer BAQs, Where
> does one go to resolve or find more information on such error messages?
>
> Patrick Winter
>
> [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]
>
> This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
>
> [Non-text portions of this message have been removed]
>
>


[Non-text portions of this message have been removed]
Thanks that helps me understand what's going on.

On Jun 1, 2012, at 4:37 PM, "Ted Koch" <tkoch77@...> wrote:

> If you save the calculated field and test the BAQ it runs.
>
> P.S. - If you take Menu.MenuType out of the displayed columns and run check syntax it says syntax ok.
>
> ________________________________
> From: "Winter, Patrick" <pjw@...>
> To: vantage@yahoogroups.com
> Sent: Friday, June 1, 2012 5:25 PM
> Subject: [Vantage] Simple BAQ - Calculated Field - Error Message
>
> All,
>
> Simple BAQ, List the reports on the Menu Structure.
>
> Menu Table, List Several Fields, All is well.
>
> Testing a calculated field.
>
> MyTest, Logical yes/no
>
> In the Editor I Type:
>
> If Menu.OptionSubType = 'R' then yes Else no
>
> CHECK SYNTAX
>
> Error:
>
> Field formant doesn't coincide with database schema for fields:
>
> Menu.MenuType current format: X(20), expected x(10)
>
> I'm sure to see many more error messages as I plan to hammer BAQs, Where
> does one go to resolve or find more information on such error messages?
>
> Patrick Winter
>
> [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]
>
>


[Non-text portions of this message have been removed]
Good Day Patrick:

There is the "ICE tools User guide" ( MUST be 9.05) which can
either be bought as a book ( 50 maybe $100) or down loaded from EpicWeb.
Call helpline for help.


Len



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Winter, Patrick
Sent: Friday, June 01, 2012 6:29 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Simple BAQ - Calculated Field - Error Message




Yes logical

On Jun 1, 2012, at 5:03 PM, "Len Hartka" <len.hartka@...
<mailto:len.hartka%40sunautomation.com> > wrote:

> Good Day:
>
> I pasted your string and it worked.
>
> If Menu.OptionSubType = 'R' then yes Else no
>
>
> Do you have the "Data Type" as Logical in the upper screen? If
> "number" it will fail.
>
> len.hartka@... <mailto:len.hartka%40sunautomation.com>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Ted Koch
> Sent: Friday, June 01, 2012 5:35 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: Re: [Vantage] Simple BAQ - Calculated Field - Error Message
>
> If you save the calculated field and test the BAQ it runs.
>
> P.S. - If you take Menu.MenuType out of the displayed columns and run
> check syntax it says syntax ok.
>
> ________________________________
> From: "Winter, Patrick" <pjw@...
<mailto:pjw%40specialtyscrew.com>
> <mailto:pjw%40specialtyscrew.com> >
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Sent: Friday, June 1, 2012 5:25 PM
> Subject: [Vantage] Simple BAQ - Calculated Field - Error Message
>
> All,
>
> Simple BAQ, List the reports on the Menu Structure.
>
> Menu Table, List Several Fields, All is well.
>
> Testing a calculated field.
>
> MyTest, Logical yes/no
>
> In the Editor I Type:
>
> If Menu.OptionSubType = 'R' then yes Else no
>
> CHECK SYNTAX
>
> Error:
>
> Field formant doesn't coincide with database schema for fields:
>
> Menu.MenuType current format: X(20), expected x(10)
>
> I'm sure to see many more error messages as I plan to hammer BAQs,
Where
> does one go to resolve or find more information on such error
messages?
>
> Patrick Winter
>
> [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]
>
> This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.
>
> [Non-text portions of this message have been removed]
>
>

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






This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


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