|
thanks,it really helps.
then can guide me if i want to copy selected records in the list control into another table(in .mdb file) with the column ~field
|
|
|
|
|
See this[^] thread is helpfuls
|
|
|
|
|
hey, how can change these code in CDaoDatabase... thanks
void CReadDBDlg::OnRead()
{
// TODO: Add your control notification handler code here
CDatabase database;
CString SqlString;
CString sCatID, sCategory;
CString sDriver = "MICROSOFT ACCESS DRIVER (*.mdb)";
CString sDsn;
CString sFile = "C:\\Documents and Settings\\common.MIT-SGP\\Desktop\\new\\ReadDB\\Test.mdb";
// You must change above path if it's different
int iRec = 0;
// Build ODBC connection string
sDsn.Format("ODBC;DRIVER={%s};DSN='';DBQ=%s",sDriver,sFile);
TRY
{
// Open the database
database.Open(NULL,false,false,sDsn);
// Allocate the recordset
CRecordset recset( &database );
// Build the SQL statement
SqlString = "SELECT CatID, Category "
"FROM Categories";
// Execute the query
recset.Open(CRecordset::forwardOnly,SqlString,CRecordset::readOnly);
// Reset List control if there is any data
ResetListControl();
// populate Grids
ListView_SetExtendedListViewStyle(m_ListControl,LVS_EX_GRIDLINES);
// Column width and heading
m_ListControl.InsertColumn(0,"Category Id",LVCFMT_LEFT,-1,0);
m_ListControl.InsertColumn(1,"Category",LVCFMT_LEFT,-1,1);
m_ListControl.SetColumnWidth(0, 120);
m_ListControl.SetColumnWidth(1, 200);
// Loop through each record
while( !recset.IsEOF() )
{
// Copy each column into a variable
recset.GetFieldValue("CatID",sCatID);
recset.GetFieldValue("Category",sCategory);
// Insert values into the list control
iRec = m_ListControl.InsertItem(0,sCatID,0);
m_ListControl.SetItemText(0,1,sCategory);
// goto next record
recset.MoveNext();
}
// Close the database
database.Close();
}
CATCH(CDBException, e)
{
// If a database exception occured, show error msg
AfxMessageBox("Database error: "+e->m_strError);
}
END_CATCH;
}
|
|
|
|
|
Before the while loop, initialize x to 0 .
hero1995 wrote: iRec = m_ListControl.InsertItem(0,sCatID,0);
iRec = m_ListControl.InsertItem(x++, sCatID, 0);
hero1995 wrote: m_ListControl.SetItemText(0,1,sCategory);
m_ListControl.SetItemText(iRec, 1, sCategory);
"A good athlete is the result of a good and worthy opponent." - David Crow
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
|
|
|
|
|
See if this is of any help.
"A good athlete is the result of a good and worthy opponent." - David Crow
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
|
|
|
|
|
I am using the IXMLHTTPRequest object to send xml over HTTPS and I need to tell it to use a PKCS#12 certificate held on the C:\ drive. Would someone advise how to associate a PKCS#12 certificate to a IXMLHTTPRequest object.
|
|
|
|
|
I have one VC++ application this application runs perfectly in the release MOde but when tried to compile in Debug mode it gives the following linker error .
Can somebody helps me in finding the solution for this problem ...
Linking...
Microsoft (R) Incremental Linker Version 6.00.8447
Copyright (C) Microsoft Corp 1992-1998. All rights reserved.
gcl52fwD.lib vfw32.lib Psapi.Lib libtiff.lib ippi20.lib ippcv20.lib libjpeg.lib ippj20.lib ipla6l.lib pcMotionMS.lib FlexMS32.lib Wsock32.lib ijl15.lib multicam.lib version.lib libguide.lib " /nologo /subsystem:windows /incremental:no /pdb:Debug/Ser
verD.pdb /map:Debug/ServerD.map /debug /machine:I386 /nodefaultlib:libc.lib /nodefaultlib:libcmt.lib /out:Bin\ServerD.exe /libpath:3RDPARTY\MKL\ia32\lib /libpath:3rdParty\MultiCam\Lib /libpath:3rdParty\ValueMotion\lib\Microsoft /libpath:3RDPARTY\IPP
\stublib /libpath:3RDPARTY\IPP\libtiff\lib /libpath:3RDPARTY\IPP\IJG\LIB /libpath:3rdParty\FlexMotion\lib\Microsoft /libpath:3rdParty\plsuite\lib /libpath:3rdParty\commlib\v6x\v6m /libpath:\Program"
LINK : error : Internal error during SetupPhase
ExceptionCode = C0000005
ExceptionFlags = 00000000
ExceptionAddress = 2E6D6172
NumberParameters = 00000002
ExceptionInformation[ 0] = 00000000
ExceptionInformation[ 1] = 2E6D6172
CONTEXT:
Eax = 004A2490 Esp = 0012FA6C
Ebx = 77C5FCE0 Ebp = 00004000
Ecx = 0012FA68 Esi = 0032ACD6
Edx = 00320600 Edi = 0032AECF
Eip = 2E6D6172 EFlags = 00010216
SegCs = 0000001B SegDs = 00000023
SegSs = 00000023 SegEs = 00000023
SegFs = 0000003B SegGs = 00000000
Dr0 = 0012FA6C Dr3 = 77C5FCE0
Dr1 = 00004000 Dr6 = 0012FA68
Dr2 = 00000000 Dr7 = 00000000
Error executing link.exe.
Tool execution canceled by user.
Thanks in advance
Anamika
If u not found any problem that means you are on the wrong way ..
|
|
|
|
|
hi, can anyone correct these code for me.Thanks
int nSelected = m_myList.GetSelectionMark();
CString strText = m_myList.GetItemText(nSelected, 0);
db.Execute("INSERT INTO Table3 IN 'D:\\copyktt.mdb' SELECT * FROM MyTable6 WHERE Field = strText ");
|
|
|
|
|
|
trang1800 wrote: db.Execute("INSERT INTO Table3 IN 'D:\\copyktt.mdb' SELECT * FROM MyTable6 WHERE Field = strText ");
It should be obvious why this does not work. You are searching for rows where the Field column is equal to "strText" rather than the contents of strText .
Use:
CString strSQL;
strSQL.Format("INSERT INTO Table3 IN 'D:\\copyktt.mdb' SELECT * FROM MyTable6 WHERE Field = %s", strText);
db.Execute(strSQL);
"A good athlete is the result of a good and worthy opponent." - David Crow
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
|
|
|
|
|
my purpose is to copy selected row in a database. Error is: two few parameter.Expected1.what's wrong
void CReadDBDlg::OnButton1()
{
// TODO: Add your control notification handler code here
CString strText;
CString strSQL;
CDaoDatabase db;
db.Open("D:\\copyktt.mdb");
CListCtrl* pListCtrl = (CListCtrl*) GetDlgItem(IDC_ListControl);
ASSERT(pListCtrl != NULL);
POSITION pos = pListCtrl->GetFirstSelectedItemPosition();
if (pos == NULL)
TRACE0("No items were selected!\n");
else
{
while (pos)
{
int nItem = pListCtrl->GetNextSelectedItem(pos);
TRACE1("Item %d was selected!\n", nItem);
// you could do your own processing on nItem here
strText = pListCtrl->GetItemText(nItem,0);
// m_cedit.SetWindowText(strText);
strSQL.Format("INSERT INTO Table6 SELECT * FROM Table3 IN 'C:\\ktt.mdb' WHERE MyField = %s",&strText);
db.Execute(strSQL);
}
}
|
|
|
|
|
sorry,
it's ....%s",strText);
|
|
|
|
|
hero1995 wrote: Error is: two few parameter.
From where?
"A good athlete is the result of a good and worthy opponent." - David Crow
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
|
|
|
|
|
can i create a dynamic two dimensional array like as......
CString str...
for(int i=0;i
|
|
|
|
|
Try using CStringArray .
Regards,
Paresh.
|
|
|
|
|
|
please,when post a code use of
pre
|
|
|
|
|
|
|
usally one calls dynamic an array whose size can grow.
If this is your requirement then have a look to CArray or (even better) std::vector documentation.
If you simply need a two-dimensional array of CString , then you've already done:
int i, j;
CString sMyArray[2][3];
for (i=0; i<2; i++)
{
for (j=0; j<3; j++)
{
sMyArray[i][j]="foo";
}
}
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
|
|
|
|
|
|
How to create .dll and .lib files in a single build in VS2005. Is there any need to include some files for that ? Please help me.
|
|
|
|
|
What's your problem exactly ? Where are you stuck ?
You need to create a dll project (New Project -> 'Visual C++' -> 'Win32' -> 'Win32 PRoject'). Click next and you'll be able to select DLL as application type.
The library file will be generated automatically once you have at least one exported function.
|
|
|
|
|
Hi. Thanks for the reply.
My problem is i am creating a new project in VS2005 from the existing project of VC6.0. It is not able to create the .lib automatically with the dll. I have checked all the settings of the project but could not get success.
So i wanted to know whether any new thing has to be done in VS2005 while converting the old project to create dll ?
|
|
|
|
|
Do you have at least one exported function ( one that is starting with __declspec(dllexport) ) ?
Did you use the conversion wizard to convert from the VC6 project to the VS2005 project ?
|
|
|
|