|
Hi all the guru, I am currently using ODBC to access MS SQL. Can anybody tell me how to get number of columns if given table name? Thanks thanks thanks!!!
vivi
|
|
|
|
|
Try Desc "tablename" query. Get the recordcount from the recordset. The count you get is the column count.
|
|
|
|
|
Vikram,
You need to be careful if you are suggesting to use CRecordset's GetRecordCount() function. According to MSDN, this function only returns the number of seen records in the set. So, right after opening the set, the function will return only 1. You would want to execute another SQL query that counts the records in the resulting set using the COUNT aggregate, or (more inefficiently) loop through the recordset with CRecordset, and then call GetRecordCount().
If your suggestion did not depend upon CRecordset, this, of course, doesn't matter.
Sincerely,
Alexander Wiseman
Est melior esse quam videri
It is better to be than to seem
|
|
|
|
|
I was also told the same thing that you just said, but was told to use MoveLast, then MoveFirst, and the count should be right. 
If it's broken, I probably did it
bdiamond
|
|
|
|
|
Hmm, that's interesting. I've never tried that, but MSDN says this:
[MSDN]
Caution The record count is maintained as a "high water mark," the highest-numbered record yet seen as the user moves through the records. The total number of records is only known after the user has moved beyond the last record. For performance reasons, the count is not updated when you call MoveLast. To count the records yourself, call MoveNext repeatedly until IsEOF returns nonzero. Adding a record via CRecordset:AddNew and Update increases the count; deleting a record via CRecordset::Delete decreases the count.
[/MSDN]
It might work, though that paragraph seems to mention it specifically.
Sincerely,
Alexander Wiseman
Est melior esse quam videri
It is better to be than to seem
|
|
|
|
|
I've never seen that before, so thanks!! BTW, when I was told this it was in reference to an ADO recordset object I was using in VB; don't know if that makes any difference.
If it's broken, I probably did it
bdiamond
|
|
|
|
|
If you have MSDN I would also suggest searching for the file "catsets.h". This is a bunch of CRecordset-derived classes that allow you to use a table name to get the names, types, and everything else you want to know about the columns. There's also ones to list all the tables, stored procedures,queries, views, primary keys, foreign keys, etc. Hope this helps!!
If it's broken, I probably did it
bdiamond
|
|
|
|
|
Hi!!! How am I be able to Get all URLs placed in the History Folder?! I have a Code here but it has an Error in its Include (unexpected end of file...)... Im trying to find another way... thanks in advance!!! 
|
|
|
|
|
Liger_Zero_X wrote:
How am I be able to Get all URLs placed in the History Folder?!
One way, among others, would be the CFileFind class.
Liger_Zero_X wrote:
I have a Code here but it has an Error...
And that error would be ??
"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen
|
|
|
|
|
Hello,
I have stumbled across one odd (in the very least) situation.
According to what MSDN makes reference to, almost all pos/size changing methods understand left/top as the topmost coordinates and right/bottom as the width/height. But that doesn't work in my programs, for some reason, as right/bottom are understood as screen coordinates and not as width/height.
Should I be doing any coordinate mapping of some sort? What am I missing out here?
David
Example:
In MSDN:
CWnd::MoveWindow
void MoveWindow( int x, int y, int nWidth, int nHeight, BOOL bRepaint = TRUE );
void MoveWindow( LPCRECT lpRect, BOOL bRepaint = TRUE );
Parameters
x Specifies the new position of the left side of the CWnd.
y Specifies the new position of the top of the CWnd.
nWidth Specifies the new width of the CWnd.
nHeight Specifies the new height of the CWnd.
bRepaint Specifies whether CWnd is to be repainted. If TRUE, CWnd
receives aWM_PAINT message in its OnPaint message handler as usual. If this
parameter is FALSE, no repainting of any kind occurs. This applies to the
client area, to the nonclient area (including the title and scroll bars),
and to any part of the parent window uncovered as a result of Cwnd’s move.
When this parameter is FALSE, the application must explicitly invalidate or
redraw any parts of CWnd and parent window that must be redrawn.
lpRect The CRect object or RECT structure that specifies the new size and position.
|
|
|
|
|
Technicaly, if you want to move your windows inside another window then you should perform some mapping. However, why don't you post some code so everyone can see what you mean?
// Afterall, I realized that even my comment lines have bugs
If the sun were to blow up, it would take us 7-8 minutes to realize it.
|
|
|
|
|
If you are working with CRects, use the Width and Height members respectively. Otherwise, deduct the left coord from the right and the top from the bottom, and you'll get the height and width. You might also want to check SetWindowPos, where you can select SWP_NOSIZE to just move the control.
There is otherwise no need for any coordinate manipulations.
|
|
|
|
|
Johan Rosengren wrote:
If you are working with CRects, use the Width and Height members respectively.
So you mean, width/height only apply to CRect objects?
Johan Rosengren wrote:
Otherwise, deduct the left coord from the right and the top from the bottom, and you'll get the height and width.
That's exactly what I have been doing...
I was just confused with the information you can find in MSDN -- they make no mention (or actually little) to CRect objects, but instead to (LP)RECT structures; they mention width/heights of rects and NOT coordinates; ...
This is why I thought you didn't really need to use screen coordinates -- after all you do. (isn't it?)
Thanks for the replies, everyone.
David
|
|
|
|
|
dNimrod#X wrote:
Johan Rosengren wrote:
If you are working with CRects, use the Width and Height members respectively
Width and Height of CRect are calculated by subtracting the coordinates and they do not represent the actual coordinates of the rectangle. So you shouldn't use them directly as coordinates in your MoveWindow function.
Width and Height in CWnd::MoveWindow() are coordinates, not sizes. CRect is similar to RECT struct. You initialize these two with coordinates, not sizes. MoveWindow API takes coordinates (not sizes) as parameters and CWnd::MoveWindow encapsulates this function. I hope this is not confusing you because as I am reading it now I am starting to have second thoughts about my explanations.
// Afterall, I realized that even my comment lines have bugs
If the sun were to blow up, it would take us 7-8 minutes to realize it.
|
|
|
|
|
Toni78 wrote:
I hope this is not confusing you because as I am reading it now I am starting to have second thoughts about my explanations.
You should  From MSDN, on MoveWindow:
nWidth
Specifies the new width of the <code>CWnd</code>.
nHeight
Specifies the new height of the <code>CWnd</code>.
It is the height and width, not the coordinates.
|
|
|
|
|
Johan Rosengren wrote:
It is the height and width, not the coordinates.
Yes, you are so right. Sorry, for the confusion that I created.
// Afterall, I realized that even my comment lines have bugs
If the sun were to blow up, it would take us 7-8 minutes to realize it.
|
|
|
|
|
dNimrod#X wrote:
So you mean, width/height only apply to CRect objects?
Yes, RECT is a simple structure
Here you have an example of moving a control using MFC:
CRect rect;
m_ctrl.GetWindowRect( rect );
ScreenToClient( rect );
m_ctrl.MoveWindow( rect.left - 10, rect.top - 10, rect.Width(), rect.Height() );
|
|
|
|
|
How do i find whether a file is present in a directory or not?
|
|
|
|
|
/* Check for existence */
if( (_access( "filename, with full path", 0 )) != -1 )
{
//file exists
}
This will do the trick for you
|
|
|
|
|
will the same trick work to find the existence of a directory
|
|
|
|
|
Why people never take a look at the msdn before asking something? In 90% of the time, you will have the answer in less than 1 min. Like in this case...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vclib/html/_crt__access.2c_._waccess.asp
Mangez des gnous!
|
|
|
|
|
use api PathFileExist() this will help you above cause
-----------------------------
"I Think It will Work"
Formerly Known As "Alok The Programmer" at CP
-----------------------------
Alok Gupta
visit me at http://www.thisisalok.tk
|
|
|
|
|
I'm working on an MDI application. Now, I have this side bar which displays certain information about a document. Each time I switch to a different document I handle the view change message in the corresponding view and from there I update the sidebar.
This worked great. But some new feature in the program demands I put in an extra view for each document/frame (a CListView to be exact). In the toolbar the user can switch between these views.
Now the problem arises, that once the view changes, I get a new message in the sidebar saying the document has switched, whereas in real, the document hasn't switched at all. I was wondering whether there would be a different way to detect if the user went to a different document
|
|
|
|
|
hi,
how i include status bar in model or moduless dialog box(Child Window).plz help me.
Thank you.
nevis
|
|
|
|
|
Can't you do it like this?
Make a CStatusBar member in your dialog
In OnInitDialog() call m_wndStatusBar.Create( this)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
