I'm running QB Enterprise MFG & Wholesale 2007, QODBC v7, and ASP classic.

My problem is that sales orders are not shwoing up in a query. My query is as follows:

For i = 1 To Request.QueryString("p").Count
  qString = qString & "'" & Request.QueryString("p")(i) & "'"
  if i < Request.QueryString("p").Count then
    qString = qString & ","
  end if
Next
sSQL = "SELECT SalesOrderLine.TxnDate, SalesOrderLine.SalesOrderLineQuantity, SalesOrderLine.SalesOrderLineRate, Item.Name, Item.SalesDesc, Item.PurchaseCost " _
  &  "FROM SalesOrderLine NOSYNC, Item NOSYNC " _
  &  "WHERE SalesOrderLine.SalesOrderLineItemRefListID = Item.ListID " _
  &    "AND SalesOrderLine.CustomerRefListID = '" + Request.QueryString("company") + "' " _
  &    "AND Item.Name IN (" & qString & ") " _
  &  "ORDER BY Item.Name, SalesOrderLine.TxnDate DESC"

QB shows sales orders that do not appear in this query, some invoiced, some partially invoiced and some open.  Since this query does not pay attention to the openness of the SO, it should have trapped all.  I have reloated all data to the optimizer before running.

Any ideas on this?

Thanks,
Andrew

Check your query by changing:

  &  "FROM SalesOrderLine NOSYNC, Item NOSYNC "

to:

  &  "FROM SalesOrderLine UNOPTIMIZED, Item UNOPTIMIZED "

If that brings them up, do a complete rebuild of the SalesOrderLine optimizer table by running:

sp_optimizefullsync SalesOrderLine

Hi Tom,

Thanks for the reply.  If I change the query to unoptimized as suggested, the sales orders come up.  I executed the sp_optimizefullsync SalesOrderLine as suggested.  The sales orders still do not come up with the nosync option. 

VB Demo 32 said the sp_optimizefullsync SalesOrderLine executed successfully.  If that is the case shouldn't the sales orders shown up with nosync?

Thanks,
Andrew