Hi Daniel You need to look in the application event log on the machine running the AOS - you will get more detail about what SQL Server is objecting to.
Hans --- In Axapta-Knowledge-Village@yahoogroups.com, "Daniel Zanni" <[EMAIL PROTECTED]> wrote: > > 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] >