V8 DynamicQuery issues?

Yahoo Archive
1
What version are you on? I am on 8.03.409C.

I also need to add that I declaring:

Dim dynQryAD As DynamicQueryAdapter = New DynamicQueryAdapter(UD01Form)
Dim targetRow as DataRow
Dan Godfrey
(805) 389-1935 x 251


________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ted Koch
Sent: Monday, August 26, 2013 2:55 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] V8 DynamicQuery issues?



Hi Dan,

If I try this I get the error:

For Each table As DataTable in dynQ.DynamicQueryData.Tables

Next

Error: BC30456 - line 560 (910) - 'DynamicQueryData' is not a member of 'Epicor.Mfg.BO.DynamicQuery'.

________________________________
From: Dan Godfrey <dgodfrey@...<mailto:dgodfrey%40a-m-c.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Sent: Friday, August 23, 2013 5:37 PM
Subject: RE: [Vantage] V8 DynamicQuery issues?


I am pretty sure that I got this bit of code from this group.

'//copy all data from QueryDesignData tables to DynamicQueryData tables (only
'for tables that exist in both datasets
Dim targetRow as DataRow
For each Table as DataTable in dynQryAD.DynamicQueryData.Tables
If Table.Rows.Count = 0 Then
For Each sourceRow as DataRow in dynQryAD.QueryDesignData.Tables(table.ToString()).Rows
targetRow = table.NewRow()
targetRow.ItemArray = sourceRow.ItemArray
Table.Rows.Add(targetRow)
Next
End If
Next'For each Table as DataTable in dynQryAD.DynamicQueryData.Tables
dynQryAD.Execute(dynQryAD.DynamicQueryData)

Dan Godfrey
(805) 389-1935 x 251

________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of tkoch77
Sent: Friday, August 23, 2013 1:52 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] V8 DynamicQuery issues?

I using this bit of code below which works fine in E9, I'm wondering what was different in V8 because I am getting the error "Value of type 'Epicor.Mfg.BO.QueryDesignDataSet' cannot be converted to 'Epicor.Mfg.BO.DynamicQueryDataSet'" on the last row below.

Dim QDS As QueryDesignDataSet
QDS = dynQ.GetByID("100-GetQuoteMtl")

QDS.QueryWhereItem(0).RValue = QuoteNum
QDS.QueryWhereItem(1).RValue = QuoteLine

Dim DS As DataSet = dynQ.Execute(QDS)

Thanks,

-Ted

CONFIDENTIALITY NOTICE: The data attached/enclosed may contain information (including technology and technical data) which is subject to the U.S. International Traffic in Arms Regulations (ITAR) or Export Administration Regulations (EAR). This information may not be exported, released, or disclosed to foreign persons either inside or outside the United States without first obtaining the proper U.S. export license or written authorization. In addition, the information and articles described herein are either patented or proprietary, and the copying or reproduction thereof is prohibited without ADVANCED Motion Controls prior written consent. If you are not the intended recipient (or have received this e-mail in error), please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Thank you for your compliance.

[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]
2
I using this bit of code below which works fine in E9, I'm wondering what was different in V8 because I am getting the error "Value of type 'Epicor.Mfg.BO.QueryDesignDataSet' cannot be converted to 'Epicor.Mfg.BO.DynamicQueryDataSet'" on the last row below.

Dim QDS As QueryDesignDataSet
QDS = dynQ.GetByID("100-GetQuoteMtl")

QDS.QueryWhereItem(0).RValue = QuoteNum
QDS.QueryWhereItem(1).RValue = QuoteLine

Dim DS As DataSet = dynQ.Execute(QDS)

Thanks,

-Ted
3
I am pretty sure that I got this bit of code from this group.

'//copy all data from QueryDesignData tables to DynamicQueryData tables (only
'for tables that exist in both datasets
Dim targetRow as DataRow
For each Table as DataTable in dynQryAD.DynamicQueryData.Tables
If Table.Rows.Count = 0 Then
For Each sourceRow as DataRow in dynQryAD.QueryDesignData.Tables(table.ToString()).Rows
targetRow = table.NewRow()
targetRow.ItemArray = sourceRow.ItemArray
Table.Rows.Add(targetRow)
Next
End If
Next'For each Table as DataTable in dynQryAD.DynamicQueryData.Tables
dynQryAD.Execute(dynQryAD.DynamicQueryData)

Dan Godfrey
(805) 389-1935 x 251


________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of tkoch77
Sent: Friday, August 23, 2013 1:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] V8 DynamicQuery issues?



I using this bit of code below which works fine in E9, I'm wondering what was different in V8 because I am getting the error "Value of type 'Epicor.Mfg.BO.QueryDesignDataSet' cannot be converted to 'Epicor.Mfg.BO.DynamicQueryDataSet'" on the last row below.

Dim QDS As QueryDesignDataSet
QDS = dynQ.GetByID("100-GetQuoteMtl")

QDS.QueryWhereItem(0).RValue = QuoteNum
QDS.QueryWhereItem(1).RValue = QuoteLine

Dim DS As DataSet = dynQ.Execute(QDS)

Thanks,

-Ted



CONFIDENTIALITY NOTICE: The data attached/enclosed may contain information (including technology and technical data) which is subject to the U.S. International Traffic in Arms Regulations (ITAR) or Export Administration Regulations (EAR). This information may not be exported, released, or disclosed to foreign persons either inside or outside the United States without first obtaining the proper U.S. export license or written authorization. In addition, the information and articles described herein are either patented or proprietary, and the copying or reproduction thereof is prohibited without ADVANCED Motion Controls prior written consent. If you are not the intended recipient (or have received this e-mail in error), please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Thank you for your compliance.


[Non-text portions of this message have been removed]
4
>>what was different in V8
I wonder if this thread might help?

http://tech.groups.yahoo.com/group/vantage/message/115367

--- In vantage@yahoogroups.com, "tkoch77" <tkoch77@...> wrote:
>
> I using this bit of code below which works fine in E9, I'm wondering what was different in V8 because I am getting the error "Value of type 'Epicor.Mfg.BO.QueryDesignDataSet' cannot be converted to 'Epicor.Mfg.BO.DynamicQueryDataSet'" on the last row below.
>
> Dim QDS As QueryDesignDataSet
> QDS = dynQ.GetByID("100-GetQuoteMtl")
>
> QDS.QueryWhereItem(0).RValue = QuoteNum
> QDS.QueryWhereItem(1).RValue = QuoteLine
>
> Dim DS As DataSet = dynQ.Execute(QDS)
>
> Thanks,
>
> -Ted
>
5
Hi Dan,

If I try this I get the error:

For Each table As DataTable in dynQ.DynamicQueryData.Tables

Next

Error: BC30456 - line 560 (910) - 'DynamicQueryData' is not a member of 'Epicor.Mfg.BO.DynamicQuery'.




________________________________
From: Dan Godfrey <dgodfrey@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Friday, August 23, 2013 5:37 PM
Subject: RE: [Vantage] V8 DynamicQuery issues?


I am pretty sure that I got this bit of code from this group.

  '//copy all data from QueryDesignData tables to DynamicQueryData tables (only
  'for tables that exist in both datasets
  Dim targetRow as DataRow
  For each Table as DataTable in dynQryAD.DynamicQueryData.Tables
  If Table.Rows.Count = 0 Then
    For Each sourceRow as DataRow in dynQryAD.QueryDesignData.Tables(table.ToString()).Rows
      targetRow = table.NewRow()
      targetRow.ItemArray = sourceRow.ItemArray
      Table.Rows.Add(targetRow)
    Next
  End If
  Next'For each Table as DataTable in dynQryAD.DynamicQueryData.Tables
  dynQryAD.Execute(dynQryAD.DynamicQueryData)

Dan Godfrey
(805) 389-1935 x 251


________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of tkoch77
Sent: Friday, August 23, 2013 1:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] V8 DynamicQuery issues?



I using this bit of code below which works fine in E9, I'm wondering what was different in V8 because I am getting the error "Value of type 'Epicor.Mfg.BO.QueryDesignDataSet' cannot be converted to 'Epicor.Mfg.BO.DynamicQueryDataSet'" on the last row below.

Dim QDS As QueryDesignDataSet
QDS = dynQ.GetByID("100-GetQuoteMtl")

QDS.QueryWhereItem(0).RValue = QuoteNum
QDS.QueryWhereItem(1).RValue = QuoteLine

Dim DS As DataSet = dynQ.Execute(QDS)

Thanks,

-Ted



CONFIDENTIALITY NOTICE: The data attached/enclosed may contain information (including technology and technical data) which is subject to the U.S. International Traffic in Arms Regulations (ITAR) or Export Administration Regulations (EAR). This information may not be exported, released, or disclosed to foreign persons either inside or outside the United States without first obtaining the proper U.S. export license or written authorization. In addition, the information and articles described herein are either patented or proprietary, and the copying or reproduction thereof is prohibited without ADVANCED Motion Controls prior written consent. If you are not the intended recipient (or have received this e-mail in error), please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Thank you for your compliance.


[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
This doesn't work either, I get an error saying:

 Error: BC30311 - line 563 (913) - Value of type 'Epicor.Mfg.BO.QueryDesignDataSet' cannot be converted to 'Epicor.Mfg.BO.DynamicQueryDataSet'.

for

Dim dynQ As New DynamicQueryAdapter(QuoteForm)
Dim QDS As QueryDesignDataSet
              Â
dynQ.GetByID("100-GetQuoteMtl")
              Â
QDS = dynQ.QueryDesignData

563 - Dim DS As DataSet = dynQ.Execute(QDS)




________________________________
From: b_ordway <bruce.d.ordway@...>
To: vantage@yahoogroups.com
Sent: Monday, August 26, 2013 1:43 PM
Subject: [Vantage] Re: V8 DynamicQuery issues?


>>what was different in V8
I wonder if this thread might help?

http://tech.groups.yahoo.com/group/vantage/message/115367

--- In vantage@yahoogroups.com, "tkoch77" <tkoch77@...> wrote:
>
> I using this bit of code below which works fine in E9, I'm wondering what was different in V8 because I am getting the error "Value of type 'Epicor.Mfg.BO.QueryDesignDataSet' cannot be converted to 'Epicor.Mfg.BO.DynamicQueryDataSet'" on the last row below.
>
>Â Â Â Â Â Â Â Â Dim QDS As QueryDesignDataSet
>Â Â Â Â Â Â Â Â QDS = dynQ.GetByID("100-GetQuoteMtl")
>Â Â Â Â
>Â Â Â Â Â Â Â Â QDS.QueryWhereItem(0).RValue = QuoteNum
>Â Â Â Â Â Â Â Â QDS.QueryWhereItem(1).RValue = QuoteLine
>Â Â Â Â
>Â Â Â Â Â Â Â Â Dim DS As DataSet = dynQ.Execute(QDS)
>
> Thanks,
>
> -Ted
>




------------------------------------

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
Change the types to match what its asking for.. change it from a
DesigndatSet to a DynamicQuery DataSet


*Jose C Gomez*
*Software Engineer*
*
*
*
*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 Mon, Aug 26, 2013 at 6:09 PM, Ted Koch <tkoch77@...> wrote:

> **
>
>
> This doesn't work either, I get an error saying:
>
> Error: BC30311 - line 563 (913) - Value of type
> 'Epicor.Mfg.BO.QueryDesignDataSet' cannot be converted to
> 'Epicor.Mfg.BO.DynamicQueryDataSet'.
>
> for
>
> Dim dynQ As New DynamicQueryAdapter(QuoteForm)
> Dim QDS As QueryDesignDataSet
>
> dynQ.GetByID("100-GetQuoteMtl")
>
> QDS = dynQ.QueryDesignData
>
> 563 - Dim DS As DataSet = dynQ.Execute(QDS)
>
> ________________________________
> From: b_ordway <bruce.d.ordway@...>
> To: vantage@yahoogroups.com
> Sent: Monday, August 26, 2013 1:43 PM
> Subject: [Vantage] Re: V8 DynamicQuery issues?
>
>
>
> >>what was different in V8
> I wonder if this thread might help?
>
> http://tech.groups.yahoo.com/group/vantage/message/115367
>
> --- In vantage@yahoogroups.com, "tkoch77" <tkoch77@...> wrote:
> >
> > I using this bit of code below which works fine in E9, I'm wondering
> what was different in V8 because I am getting the error "Value of type
> 'Epicor.Mfg.BO.QueryDesignDataSet' cannot be converted to
> 'Epicor.Mfg.BO.DynamicQueryDataSet'" on the last row below.
> >
> > Dim QDS As QueryDesignDataSet
> > QDS = dynQ.GetByID("100-GetQuoteMtl")
> >
> > QDS.QueryWhereItem(0).RValue = QuoteNum
> > QDS.QueryWhereItem(1).RValue = QuoteLine
> >
> > Dim DS As DataSet = dynQ.Execute(QDS)
> >
> > Thanks,
> >
> > -Ted
> >
>
> ------------------------------------
>
>
> 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]