C / C++ / MFC

shouvik.d wrote:

query="Select * from Book where Name like '%"+name.Left(5)+"%' AND Author LIKE '%"+auth.Left(5)+"%' Order By Ac_No" ; m_pSet->Open(CRecordset::dynaset, (LPCTSTR)query,CRecordset::none);

shouvik.d wrote:

I tried but funniest part is its adding the records instead of sorting them

m_pSet->Open();
m_pSet->m_strSort = "par, par1";
m_pSet->Requery();//use CanRestart, to check if this function can be called

shouvik.d wrote:

But the records are already sorted

m_pSet->Close();		
query = "Select * from Book where Name like '%" + name.Left(5) + "%' AND Author LIKE '%" + auth.Left(5) + "%' Order By Ac_No";		
m_pSet->Open(CRecordset::dynaset, query, CRecordset::none);		
while(! m_pSet->IsEOF())
{			
    name = m_pSet->m_Name;			
    auth = m_pSet->m_Author;			
    Item = m_pSet->m_Ac_No + "\t" + name + "\t" + auth + "\t" + CLibManView::GetStatus(m_pSet->m_Stat);
    lb->AddString(Item);			
    m_pSet->MoveNext();		
}

void CLibManView::OnDblclkBooks() 
{
	CString str;
	lb->GetText(lb->GetCurSel(),str);
    m_pSet->Close();
	query = "Select * from Book where Ac_No='"+str.Left(4)+"'";
	m_pSet->Open(CRecordset::dynaset, (LPCTSTR)query,CRecordset::none);
	if(m_pSet->IsBOF() && m_pSet->IsEOF())
		MessageBox("No records available in the database");
	else
	{
		MessageBox(m_pSet->m_Ac_No+"      "+GetStatus(m_pSet->m_Stat));	
	}
}

Success makes life easier. It doesn't make living easier.

SH UVIK

wrote:

when creating a MDi how do i change the name of the pop up window. it comes with "new". how do i change it?

wrote:

Sender:
Date:6:01 29 Dec '06

wrote:

...the pop up window.