|
I am writing a small project using ODBC which can add, delete and edit records in the database, I have accomplished it, but I don't know how to write the code which I can dump the whole database, I need some advices or sample code, Thanks in advance!
|
|
|
|
|
A simple way (if your database is fairly small) would be to just generate a load of insert statements for all the tables in your database. These could then be replayed in bulk to restore a database.
store your internet favourites online - www.my-faves.co.uk
|
|
|
|
|
Does it necessarily need to go to a text file? If not, I've used this code before to backup up a database:
CShellFileOp ShellFileOp;
CDatabase *pDatabase = GetDatabase();
CString strDBNameFrom,
strDBNameTo;
TCHAR szFilename[_MAX_FNAME],
szExt[_MAX_EXT];
BOOL bAPICalled;
ASSERT(! m_rOptionsInfo.m_strBackupFolder.IsEmpty());
strDBNameFrom = pDatabase->GetDatabaseName();
if (! strDBNameFrom.IsEmpty())
{
strDBNameFrom += _T(".mdb");
_splitpath(strDBNameFrom, NULL, NULL, szFilename, szExt);
strDBNameTo.Format(_T("%s\\Backup of %s%s"), m_rOptionsInfo.m_strBackupFolder, szFilename, szExt);
ShellFileOp.AddSourceFile(strDBNameFrom);
ShellFileOp.AddDestFile(strDBNameTo);
ShellFileOp.SetOperationFlags(FO_COPY, AfxGetMainWnd(), FOF_NOCONFIRMATION);
if (ShellFileOp.Go(&bAPICalled) != FALSE)
AfxMessageBox(IDS_MSG_BACKUPSUCCESS);
else
AfxMessageBox(IDS_MSG_BACKUPFAILED);
}
"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen
|
|
|
|
|
there standart sollution for this case via xml export/import file.
the only problem i faced was that i couldn't write blob data to the xml: i write them at the end of xml-file in the specified format to simply identify for which records they belong to.
4apai
There're no impossible tasks. There're tasks that required infinite period of execution time.
|
|
|
|
|
You could always Base64 encode your blobs and store them in the XML node structure....
onwards and upwards...
|
|
|
|
|
hm, what does it mean base64 encode?
do u've a sample?
4apai
There're no impossible tasks. There're tasks that required infinite period of execution time.
|
|
|
|
|
I' using visual C++ to add a feature to my program, that enables the user to right-click on any menu item, and the corresponding topic is opened in a *.chm type manual i have already created.
I don't have any clue on how to do this , or if other programming languages are necessary like XML, Java,, etc. But if anyone can offer any ideas on how to this, please let me know.
Thanks for your time,
Eduardo M. Rey
Ed
|
|
|
|
|
If you can already process the right click on the menu item, then you just need to read about the HTMLHelp function.
You need some scheme to map the menu item identifier to the help topic in your CHM file, of course.
|
|
|
|
|
Thanks for your response, it was very helpful.
Brief, and informative.
Ed
|
|
|
|
|
I am writing a database application, I use the MS ODBC driver for Oracle. I want to view, edit add/delete records on a Oracle database. After I building the executable, there was NO error, but when I ran the EXE, I knew the database had been connected and opened correctly, because the messagebox had been prompted and showing "the database has been opened", but in the next step, an error messagebox prompted, showing the Runtime-Library error. I don't know where is wrong, and need some help, Thanks!
Here is the code for openning the database and table.
CDatabase m_db;
BOOL flag=FALSE;
flag=m_db.Open(_T("OracleDSN"), FALSE,FALSE,_T("ODBC;UID=ADMIN"));
if(flag)
MessageBox("the database has been opened");
else
MessageBox("failed to open the database");
CRecordset m_recordset(&m_db);
m_recordset.Open(CRecordset::forwardOnly, "select * from table_1");
|
|
|
|
|
chocm wrote:
...but in the next step...
Which statement exactly?
chocm wrote:
I don't know where is wrong, and need some help, Thanks!
Simply place a breakpoint on the CRecordset m_recordset(&m_db) statement and single-step through the code from that point.
I notice you are not handling exceptions, especially CDBException. Why? These go a long way in tracking down problems like you are currently experiencing.
"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen
|
|
|
|
|
I have set breakpoint, but it showed no info that is helpful, I still don't know where is wrong.
|
|
|
|
|
But I still get no helplful info by stepping
|
|
|
|
|
Did you (still) get a runtime error? Is it reproducible (at a particular statement)? Did you implement a try/catch block?
"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen
|
|
|
|
|
I’m trying to get a handle to an wrapped ActiveX class like this:
(The ActiveX is running inside AutoCad.)
<br />
_DDataBaseTreeView *pPE;
HRESULT res;<br />
<br />
CLSID clsid;<br />
<br />
CLSIDFromProgID(L"NetModeler.DataBaseTreeView.1", &clsid); <br />
IUnknown *pUnk = NULL;<br />
IDispatch *pDisp = NULL;<br />
<br />
HRESULT hr = GetActiveObject(clsid, NULL, (IUnknown**)&pPE);
<br />
if(SUCCEEDED(hr)) <br />
{<br />
hr = pUnk->QueryInterface(IID_IDispatch, (void**)&pDisp ); <br />
if( SUCCEEDED(hr) )<br />
{<br />
}<br />
<br />
}<br />
<br />
_variant_t var;<br />
<br />
<br />
var = pPE->Func();
What have I missed?
I want to have a handle to an already running ActiveX inside AutoCad.
_____________________________
...and justice for all
APe
|
|
|
|
|
QueryInterface must query the interface it needed:
pUnk->QueryInterface(IID_IAUTOCAD_OR_SMTH_ELSE, (void**)&pDisp);
4apai
There're no impossible tasks. There're tasks that required infinite period of execution time.
|
|
|
|
|
where do I find that:
4apai wrote:
IID_IAUTOCAD_OR_SMTH_ELSE
_____________________________
...and justice for all
APe
|
|
|
|
|
first try to find it via typing ::(Ctrl+space) - this will list all the objects in the current namespace
4apai
There're no impossible tasks. There're tasks that required infinite period of execution time.
|
|
|
|
|
Ok.
Now I, in some way, get it to work with IID_IDispatch... 
_____________________________
...and justice for all
APe
|
|
|
|
|
Hi All,
Could anyone pleae provide me sample application for binarytree creation, search, delete and list all items.
Thanks in Advance.
Be simple and Be sample.
|
|
|
|
|
http://www.google.com.ua/search?hl=uk&ie=UTF-8&q=binary+tree+c%2B%2B+code+sample&meta=
4apai
There're no impossible tasks. There're tasks that required infinite period of execution time.
|
|
|
|
|
Is there any way we can underline some of the items
of a listbox ??
if yes, then how ???
|
|
|
|
|
|
hi davey,
what exactly i want is that,
a listbox which have some of the url's as items
so when i double click that item data i can go
straight away to the web page.
for that i need some of my item data(not all) to be underlined so that it depicts a URL.
bye
|
|
|
|
|
hello,
try handling the NM_CUSTOMDRAW message. This is a lot easier than owner draw. also you can specify which cell to modify.
There some really great tuts around here. Please take a look in the list control topics section.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
