none
Ads returns only few records RRS feed

  • Question

  • Hi,
    I am trying to get the record from the Advantage Database server using c#.
    AdsCommand macsCmd = new AdsCommand(); 
    AdsExtendedReader macsReader; macsCmd.Connection = sCon; statusGrid.Rows[i].Cells[0].Value = odHeadReader[1].ToString(); statusGrid.Rows[i].Cells[1].Value = odHeadReader[0].ToString(); macsCmd.CommandText = "SELECT STATUS,[ORDER] FROM WHORDHD where OCUSTREF like '"+odHeadReader[1].ToString()+"%'"; macsReader = macsCmd.ExecuteExtendedReader(); if (macsReader.HasRows) { macsReader.Read(); statusGrid.Rows[i].Cells[2].Value = macsReader[0].ToString(); statusGrid.Rows[i].Cells[3].Value = macsReader[1].ToString(); } i++;
    The problem is its only return some record not all of them. If I run the same query on the database directly for the record not found , I get the results. The
    macsReader.HasRows
    returns false for most of the records, can any one help is there any bug in .netdataprovider for Advanatge database.
    Thanks
    Thursday, July 2, 2009 3:16 PM

Answers

All replies