|
Hi, all.
a table named Employees, which has one column named "Name" and 3 records, like below:
Name
-----
Mike
Tom
Jacky
now i wanna display one more column named ID, which is a continuous integer, let the result like:
ID Name
------------
5 Mike
6 Tom
7 Jacky
how to write this query can make this result(using ms sql)? thanks a lot.;)
|
|
|
|
|
|
but It don't have a ID column actually, it just has one column "Name".
|
|
|
|
|
You may want to use ALTER TABLE to add the column ID in your table. Then you do a simple SELECT.
Best regards,
Alexandru Savescu
|
|
|
|
|
When i want to shut down my machine (windows 2000) and i run the
ExitWindowsEx(EWX_SHUTDOWN | EWX_FORCE, 0);
function but nothing happens, what am i doing wrong?
|
|
|
|
|
|
Does anyone know of a free or open-source SDK (for Windows) for burning CDs? There are a number of (imho, expensive) commercial solutions available, but I'm looking for something that's free that will let me write data files to a CD-R(W).
Thanks,
/ravi
Let's put "civil" back into "civilization"
http://www.ravib.com
ravib@ravib.com
|
|
|
|
|
Yes. CDRecord (try Google for it, it should be among the first hits).
|
|
|
|
|
Thanks, Mike!
/ravi
Let's put "civil" back into "civilization"
http://www.ravib.com
ravib@ravib.com
|
|
|
|
|
Hi All!
How set Security on a NTFS Folder Programmatically (Admin, SYSTEM - all, USER - read only)
|
|
|
|
|
Try searching MSDN for "NTFS ACL". There's also a sample called SIDCLEAN.C that should put you on the right track.
|
|
|
|
|
How can I disable the close box (the upper-right X) with core Win32 code?
LPCSTR Dutch = "Double Dutch "
|
|
|
|
|
i think thats not possible ! You can just catch, if the user presses this button.
da sonu
|
|
|
|
|
HMENU hSysmenu = GetSystemMenu(hwnd, FALSE);
DeleteMenu ( hSysmenu, SC_CLOSE, MF_BYCOMMAND );
--Mike--
Just released - RightClick-Encrypt - Adds fast & easy file encryption to Explorer
My really out-of-date homepage
Sonork-100.19012 Acid_Helm
|
|
|
|
|
Hi,
I have to find some info like embedded and background pic's paths in HTML files.
The one way is to read the HTML page from file into a CString and use lots of CString::Find's and if's.
Is there any other way?
Thanks for your feedback
R.
|
|
|
|
|
See the LinkChecker demo in my Web Resource Provider article.
/ravi
Let's put "civil" back into "civilization"
http://www.ravib.com
ravib@ravib.com
|
|
|
|
|
I have an Wizard unmanaged VC++ app that I am using VS.NET to debug. I run the app and all my intented code is preform the wizard is shown, it works, and closes. But I was looking in the output window for something else and I saw the first-change exception text. I couldn't track for the code I add to the app that could cause the exception so should I treat it as a warning or continue to find the problem.
|
|
|
|
|
About 12 ours ago I posted a question on MFC dialogs. Someone answered me but I had no time to read the message. Not I cannot find it any more? Search does not find my name, etc.
|
|
|
|
|
Nobody. It's still here.
/ravi
Let's put "civil" back into "civilization"
http://www.ravib.com
ravib@ravib.com
|
|
|
|
|
hello to all of u
i want to find some text from the text file how should i handle this. which of the classes are available in vc6 and methods used in file reading or writing .please tell me about all classes and methods and where for different cases these can be used .
thanks for taking part in this
bye
muni
|
|
|
|
|
CStdioFile for file reading
CString::Find for searching
open file
while not found
read a string, search it
repeat
-c
Being just contaminates the void. --Robyn Hitchcock
|
|
|
|
|
hi fellows,
how r u ,i've a problem i.e i want to find link information from html source file i.e
<href =="" "codeproject="" user_new.asp"
now="" i="" want="" to="" search="" <href=""> tag then checking = and quotes and at last i have to store the path in quotes in a string , and likes wise there can be many <href> tags in the document depending upon the links in the page .and then there can be many images' links identified by tag,like wise i have to save the paths specified in the tags which can be many more.
which classes and methods should i use to do it quickly and efficiently because i have to find the links' information of thousands of links.
pls help me ,thanks
well wishes from
waseem
|
|
|
|
|
IF you want to find a string in a file, you can just load the file in a variable with ReadFile and find a substring inside it with strstr.
|
|
|
|
|
This is probably really simple but I cant think how to do it.
I have a dialog which contains a CRichEditCtrl derived member. In the Onkeydown of the edit control I check for F9 which works fine. I want to at this stage update a member of the edit control to contain the value, and inform the parent to ask.
this is really difficult because the child doesnt contain a reference to its parent??? Also what is the damn menthod I call from within the rich edit control to find out the current text?!!!
An example in case i havent explained well:
CMyRichEd::OnKeyDown( char bla bla )
{
if( nchar == vk_f9 ) {
m_PersonsName = // Get contents of text box
// Alert parent somehow to call CMyRichEd::GetPersonsName()
}
}
Any help would be v much appreciated!
Thanks
|
|
|
|
|
GetParent should return the parent window. Doesn't this work for you?
Joaquín M López Muñoz
Telefónica, Investigación y Desarrollo
|
|
|
|