|
Hi All,
This is my second post regarding the problem.i haven't got its solution yet.
I am using access automation. Please Guide How can I Get number of tables & names in a database using access automation?
I just want to figure out number of tables & table names in an access database.is it possible using access automation.How?
i don't know if it is possible using database connectivity since i don't intend to do anything with data or data fields in the tables.
I am using vc++ 6.0,access-2000.
Please Help!!
Regards,
Ankush Mehta
Ankush Mehta
|
|
|
|
|
Hello.
I feel I must respond, since noone else does. 
I'm not in any way DB expert, but I have a faint memory that a real expert once told me that all table and column names are stored in a special "system" DB table.
I'm not sure if this is true for all DB's, but it might me worth investigating.
Good luck.
Kakan
|
|
|
|
|
Ankush Mehta wrote: This is my second post regarding the problem.i haven't got its solution yet.
No wonder about it. Your problem statement is not clear.
Ankush Mehta wrote: don't know if it is possible using database connectivity
If you do not connect to the database, how do you plan to get information about the database?
Ankush Mehta wrote: How can I Get number of tables
//No. of tables.
CDaoDatabase::GetTableDefCount();
//Information about tables, including table names
CDaoDatabase::GetTableDefInfo();
Regards,
Rajesh R. Subramanian
You have an apple and me too. We exchange those and We have an apple each.
You have an idea and me too. We exchange those and We have two ideas each.
|
|
|
|
|
Thanks Rajesh,
i was just trying to use access automation(functionality provided by access to manipulate access without making any connection) to achieve that.However, couldn't find an answer to that.
Thanks,
Ankush Mehta
Ankush Mehta
|
|
|
|
|
Hi All,
// Build the SQL statement
SqlString = "SELECT Name FROM MsysObjects where type = 1 AND (Left([Name],4) <> \"Msys\") AND (Left([Name],1) <> \"~\")";
// Execute the query
recset.Open(CRecordset::forwardOnly,SqlString,CRecordset::readOnly);
I have found this piece of info. MsysObjects table contain all the info about tables, queries,reports in access database.
when i try to query MsysObjects table "Access is denied". I don't know where is it located & also it is undocumented. How can i query MsysObjects table?
Please Help!
Regards,
Ankush Mehta
Ankush Mehta
|
|
|
|
|
I am working with MFC to read the file system and populate all directories, subdirectories and files in a tree. I am using a recursive function to do it. When this function finds a directory, it calls itself for searching that directory for its inner directories and files. I included objects of HTREEITEM as root and TVINSERTITEM as tvInsert in CFileSysDlg.
I wrote following code to populate the tree
int CFileSysDlg::FindFiles(HANDLE fp, unsigned long ino, unsigned long itable_blkno)<br />
{<br />
HTREEITEM newitem = root;
if (file_type == 2)
{<br />
tvInsert.hParent = root; <br />
tvInsert.hInsertAfter = NULL;<br />
tvInsert.item.mask = TVIF_TEXT;
tvInsert.item.pszText = (LPSTR)file_name;<br />
newitem = pCtrl->InsertItem(&tvInsert);<br />
FindFiles(fp, inodeno, itable_blkno); <br />
}<br />
else<br />
{<br />
if (file_type == 1)
{<br />
hPA = pCtrl->InsertItem(TVIF_TEXT,(LPSTR)file_name, 0, 0, 0, 0, 0,newitem, NULL);<br />
}<br />
}<br />
}
Problem is that it shows me directories and subdirectories at the same level.
Please tell me how can i correct it. Please reply me as soon as possible
Thanks
We Believe in Excellence
-- modified at 5:39 Thursday 1st December, 2005
|
|
|
|
|
Hello Auueel.
The standard way to solve this problem is to use a variable which holds an "indent level number".
For every directory found, increment the "indent level number" variable. For every directory you back out of, decrement the "indent level number" variable.
Then use the "indent level number" variable when you display an item.
Kakan
|
|
|
|
|
Hello
Mr. Kakan
I got your point but my problem is different. Check sample directory structure.
root
dir
innerdir
files of innerdir
..
..
but my program is showing parent of dir and innerdir as root while parent of innerdir is dir. How can i solve this problem.
We Believe in Excellence
|
|
|
|
|
Hello again.
I'm not familiar with the tree control, but as far as I know, you have to create the braches (and leafs) yourself, true?
If that´s the case, then the value of the indent level variable will tell you how many braches you have to create.
Or am I totally missing the point?
regards
Kakan
|
|
|
|
|
Hi again.
Please remove your new post, else someone will be offended.
It's best to keep our conversation in this thread.
Kakan
|
|
|
|
|
I have DLL library and .h file but it has been created in Borland
and i can not use its .lib file. And only thing, DLL exports is one class.
So I am lost.
Does somebody know how to do run-time dynamic linking for
such library - how to reach its class?
Or is there any way or program to create(generate) proper .lib for MSDEV,
just from DLL and H file?
Thankx lot
viliam
|
|
|
|
|
viliam wrote: Does somebody know how to do run-time dynamic linking for
such library - how to reach its class?
you can do Runtime Linking of A function.. For class it is not possible as you don't address of a function till your object of class is created
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers,
Alok Gupta
VC Forum Q&A :- I/ IV
|
|
|
|
|
Hi,
I'm looking for ways to to paste Windows Clipboard content into MSHTML including images. I've come to the conclusion that using RTF from the Clipboard and converting that to HTML is the only sensible way to tackle this. Any other ideas most welcome.
So I'm looking for code to convert RTF to HTML. It must do images and support all of the most common RTF stuff. I prefer to get the source, but failing that a DLL would do.
I've googled and there are commercial components which are all pretty pricey, especially if you want source.
Suggestions, tips, pointers???
Neville Franks, Author of Surfulater www.surfulater.com "Save what you Surf" and ED for Windows www.getsoft.com
|
|
|
|
|
You could try these people[^]. They do a full RTF editor, and RTF to/from HTML conversion tools as well. We used a version of this in the past, and you can get source as well as a DLL. Still not cheap though.
|
|
|
|
|
Thanks Graham. I had come across that. As you say a bit pricey though. I use their SpellTime product in ED4W.
Neville Franks, Author of Surfulater www.surfulater.com "Save what you Surf" and ED for Windows www.getsoft.com
|
|
|
|
|
Hi
I want to converet a bitmap file to a Indexed-palatte bitmap
How can I do this?
Thanks
Every new thing you learn,Gives you a new personality.
|
|
|
|
|
Hi,
I have a form view class derived from CFormView. In this class I have a thread which does some processing for every 30 seconds and generates a status message which is of type CString. I need to show this message in the Status Bar. From within the form view class I am calling a method names UpdateOnlineStatusMessage in the Frame Window class which updates the status bar.
void UpdateOnlineStatusMessage(CString strMsg)
{
PANEINFOEX pex;
pex.iIndex = 0;
pex.strText = strMsg;
pex.iFlags = SBP_ID | SBP_TEXT;
m_wndStatusBar.SetPaneInfoEx(&pex);
}
Here m_wndStatusBar member that represents the status bar in the FrameWindow calss. I am getting an assertion while trying to access m_wndStatusBar member.
Can anyone please help me to solve this.
Thanks
Madhavi.
|
|
|
|
|
ledallam wrote: Here m_wndStatusBar member that represents the status bar in the FrameWindow calss.
Could you please show us! How do you connect the StatusBar member of MainFrame with m_wndStatus? i believe that the root cause of problem...
you can try this too ->
CMainFrame* pMain = (CMainFrame*)AfxGetMainWnd();
if(pMain)
{
PANEINFOEX pex;
pex.iIndex = 0;
pex.strText = strMsg;
pex.iFlags = SBP_ID | SBP_TEXT;
pMain->STATUSBAR_MEMBER-> or . SetPaneInfoEx(&pex);
}
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers,
Alok Gupta
VC Forum Q&A :- I/ IV
|
|
|
|
|
The status bar is a member of mainfrme class itself and the function that updated the status bar is also in the main frame, so I use it directly. I'll call the function that updates the status bar from my form view calss
|
|
|
|
|
ledallam wrote: PANEINFOEX pex;
pex.iIndex = 0;
pex.strText = strMsg;
pex.iFlags = SBP_ID | SBP_TEXT;
m_wndStatusBar.SetPaneInfoEx(&pex);
Are you using your custom CStatusBar Class. as i couldn't found SetPaneInfoEx and PANEINFOEX in My Local MSDN Copy (APril2004)!
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers,
Alok Gupta
VC Forum Q&A :- I/ IV
|
|
|
|
|
Yes I am using custom CStatusBar Class.
|
|
|
|
|
ledallam wrote: Yes I am using custom CStatusBar Class.
Then Please list the code of that Custom Function
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers,
Alok Gupta
VC Forum Q&A :- I/ IV
|
|
|
|
|
|
Dear Friends,
I got the solution.
I just run E:\Program Files\Microsoft Visual Studio .NET 2003\Vc7\bin\vcvars32.bat before compiling that c++ project.
It sets all required env variables and other things, now my c++ code get compiled from the command line.
Thanks to all my friends who try to help me.
Sachin Gedam
(Software Engg.)
Pune India
|
|
|
|
|
In WinXP SP2, there is a service called "DCOM server process launcher" run via svchost.exe. Today I noticed in Process Explorer that there is a "iexplore.exe" process running as a child of this svchost.exe, and tracking back how I started this instance of Internet Explorer, I had clicked on "2 new email messages" in the MSN Messenger (6.2). This is very interesting and I dont know why internet explorer does not show up as a child process of MSN Messenger itself. Anyone any ideas?
I was curious, I then attached windbg to this svchost.exe and put a breakpoint on NtCreateProcessEx, and you know what, the breakpoint is hit even if I start IE from the Windows Explorer shortcuts. Infact, the breakpoint is hit for every process that I start from windows explorer. The difference, however, is that the process is still created as a child of explorer.exe and not as a child of svchost.exe when I start from Windows explorer.
The questions I have are:
1. How exactly does this DCOM server process launcher work?
2. How do you communicate with it to start a new process?
3. What decides on who is going to launch the new process? svchost or calling process?
I'm not sure if this is good forum to ask this question, if it is not and you know an alternate forum, please let me know.
thanks!
--s
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
