Error in Sql Statement

Hello,

I have a SQL statement like this

while select localSalesParmTable
join localCustSalesLegalTxt
group by salesId, salesLegalTxtId
where localSalesParmTable.SalesId ==
localCustSalesLegalTxt.SalesId &&
localSalesParmTable.ParmId == this.parmId()

but I need the data usind order by with salesId exactly like this

while select localSalesParmTable
order by salesId
join localCustSalesLegalTxt
group by salesId, salesLegalTxtId
where localSalesParmTable.SalesId ==
localCustSalesLegalTxt.SalesId &&
localSalesParmTable.ParmId == this.parmId()

The Error happens and i get the following message
"Error:Cannot select a record in Sales order - Update table
(SalesParmTable). Sales order: , .
The SQL database has issued an error."

Somebody knows what happens in this case, because for me the select
statement is correct

Regards

Daniel

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

Messages in this topic (1) Reply (via web post) | Start a new topic

.

Hi Daniel,

First of all set the infos detail level to "All" in your user options
so you can see all infolog posted. In your message you're missing
useful SQL error explaintion that could help you.

In your second statement, replace de "order by" for "group by" and
that should resolve your problem.

Good luck.

--- In development-axapta%40yahoogroups.com">development-axaptayahoogroups.com, "Daniel Zanni";
<danielzanni...> wrote:
&gt;
> Hello,
&gt;
> I have a SQL statement like this
>;
> while select localSalesParmTable
> join localCustSalesLegalTxt
> group by salesId, salesLegalTxtId
>; where localSalesParmTable.SalesId ==
> localCustSalesLegalTxt.SalesId &&
> localSalesParmTable.ParmId == this.parmId()
>
> but I need the data usind order by with salesId exactly like this
>;
> while select localSalesParmTable
> order by salesId
> join localCustSalesLegalTxt
> group by salesId, salesLegalTxtId
>; where localSalesParmTable.SalesId ==
> localCustSalesLegalTxt.SalesId &&
> localSalesParmTable.ParmId == this.parmId()
>
> The Error happens and i get the following message
> "Error:Cannot select a record in Sales order - Update table
&gt; (SalesParmTable). Sales order: , .
> The SQL database has issued an error.&quot;
>
> Somebody knows what happens in this case, because for me the
select
> statement is correct
>
> Regards
>
> Daniel
&gt;
>
> [Non-text portions of this message have been removed]
>

Messages in this topic (0) Reply (via web post) | Start a new topic

.