You’re offline. This is a read only version of the page.
790
I am trying build a report using SRS. I am creating a DataTable using a SQL statement. The SQL after the "if" works but the SQL after the "else" returns no rows. Here is the code in my DataMethod:
public partial class WFSPackingLists [AxSessionPermission(SecurityAction.Assert)] if (PackingListsDS_SalesOrder == "*") The first SQL statement works if I use "*" as my parameter value. But the SQL statement after the "else" never returns anything. I am entering a valid TransrefID. Not sure if it is a problem with my single quotes or the parameter. Can anyone help?
Thanks, Bob
{
[DataMethod(), AxSessionPermission(SecurityAction.Assert)]
public static DataTable GetPackingLists(string PackingListsDS_SalesOrder)
{
DataSet ds;
{
ds = SqlHelper.ExecuteDataset("Server=wfssqlsrv01;Database=AX2009_Carib_Dev;Integrated Security=SSPI",
CommandType.Text, @"SELECT TransRefID, InvoiceID, PackingSlipID, COUNT(1) OVER (PARTITION BY TransRefID) as 'Item Count', StatusIssue, DatePhysical, Qty, COSTAMOUNTPOSTED, DateFinancial, DataareaID
FROM inventtrans WHERE transtype = 0 AND Transrefid > 'SC00000000'
AND packingslipID > 'PS000000' AND StatusIssue IN (1, 2)
ORDER BY TransrefID");
}
else
{
ds = SqlHelper.ExecuteDataset("Server=wfssqlsrv01;Database=AX2009_Carib_Dev;Integrated Security=SSPI",
CommandType.Text, @"SELECT TransRefID, InvoiceID, PackingSlipID, COUNT(1) OVER (PARTITION BY TransRefID) as 'Item Count', StatusIssue, DatePhysical, Qty, COSTAMOUNTPOSTED, DateFinancial, DataareaID
FROM inventtrans WHERE transtype = 0 AND Transrefid > 'SC00000000'
AND packingslipID > 'PS000000' AND StatusIssue IN (1, 2)
AND TransrefID = ' + PackingListsDS_SalesOrder + '
ORDER BY TransrefID");
}
return ds.Tables[0];
}
}
*This post is locked for comments
I have the same question (0)
You are not correctly inserting the value of PackingListsDS_SalesOrder into your SQL Statement. Instead, you are literately searching for the value ' + PackingListsDS_SalesOrder + '
Try
AND TransrefID = (single quote)(double quote) + PackingListsDS_SalesOrder + (double quote)(single quote)
Share
Report
All responses (
Answers (
