|
You can declare three columns on Select statement
|
|
|
|
|
"SELECT city,city1,city2 FROM data1"
this is posible?
Bravoone
|
|
|
|
|
Select city,name From Authors
---------
Select * From Authors (I believe its not good because if we have 100,000 records how many time to reads them?)
---------
Select col1 from Authors Where number in('123','000')
---------
Select col1 From authors Where title LIKE '%book%'
|
|
|
|
|
Bravoone_2006 wrote: SELECT city,city1,city2 FROM data1"
this is posible?
yes, if city, city1 and city2 are columns of the table data1 (which is badly named if so).
BTW, your problem is a SQL question, not related to C/C++ at all, so you should have asked the SQL forum
|
|
|
|
|
Or rather, Bravoone should spend an hour with reading chapter one from any SQL book...
Alcohol. The cause of, and the solution to, all of life's problems - Homer Simpson
|
|
|
|
|
This is not the problem i read it but all i want is to retrieve 3 columns not all columns from my table but i dont now how ?!
Bravoone
|
|
|
|
|
You already got a number of answers to your question.
What else do you want? Someone to write your entire application for you?
Alcohol. The cause of, and the solution to, all of life's problems - Homer Simpson
|
|
|
|
|
Not the entire aplication just answer to my question and if you dont now ...!
just this SELECT statement !!!!!
Bravoone
|
|
|
|
|
kakan wrote: Someone to write your entire application for you?
This has been discussed ad nauseam.
"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15
"Judge not by the eye but by the heart." - Native American Proverb
|
|
|
|
|
Because the program is in visual c++ ... man ! is so hard to believe that -> CDialog is a class from visual c++ CRecordset is a class from visual c++ ! hoo !
ok CRecordset::Open(CRecordset::snapshot,"SELECT... what? and how?");
i will wait your answer !
Bravoone
|
|
|
|
|
I wrote four examples for you
|
|
|
|
|
Bravoone_2006 wrote: ,"SELECT... what? and how?"
DO YOU READ YOU PREVIOUS ANSWERS ?
|
|
|
|
|
I guess its in long with previous his program
|
|
|
|
|
Now I write a server program and use strcpy,strcat to generate a log info. I wonder whether these functions are thread-safe. Does anybody test them under multi-thread environment?
yangyi
|
|
|
|
|
Even if they are, the logging function has just one file open for writing...
My advice is to use a mutex for the entire logging function.
Then you won't have to bother at all. And the resulting file will come out just fine.
Alcohol. The cause of, and the solution to, all of life's problems - Homer Simpson
|
|
|
|
|
Iam beginnar in VC++.
I want to take two edit boxes on a Dialog.
one for USERNAME and Another For Password.
How to take user name From user and how do i store and validate ?
Same For password also ?
plz help me.
|
|
|
|
|
For password you must set Password to true on preperty window of editbox and you can declare two variables for your controls and use of m_Edit.GetWindowText(...) for read of editbox
|
|
|
|
|
Thanks for ur Response Any links regarding this.
|
|
|
|
|
Krishnatv wrote: Any links regarding this.
GetWindowText()
"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15
"Judge not by the eye but by the heart." - Native American Proverb
|
|
|
|
|
Hi all:
I have encountered a problem. My program have two levels of executables, the start.exe at the root which will start some others executables reside in "Setup" folder, I've included those necessary CRT libs into "Setup" folder. And things went well until I run the program under other machine, when I launch start.exe I was prompted "the application failed to initialize properly (0xc0150002)..." but when copy "Microsoft.VC80.CRT.manifest" and "msvcr80.dll" to root things start to works again, so far I have no clue as to why this is happening.
|
|
|
|
|
LiYS wrote: reside in "Setup" folder
Executables looks for dependent dlls in SYSTEM folder, current directory.
In your case dependent dlls are not present in either of them. You have to consider that while installation.
|
|
|
|
|
i want to include /GS compile option in my project can anybody help me where should i include it
|
|
|
|
|
You need to use option /O1 or /O2 .
Go to Project settings-->C/C++-->Optimizations-->Optimizations-->Minimize size or MaxiMize Speed
See decription of /O2 amd /O1 in MSDN .
|
|
|
|
|
while running my project i am getting error
"unhandled execption in text.exe :0xC0000005": access violation"
After going through net i came to know that if i use /GS in my project the problem will be solved...
from this link
http://weblogs.asp.net/gad/archive/2004/03/23/94996.aspx[^]
Can you ple help me more further...pls
|
|
|
|
|
With_problem wrote: "unhandled execption in text.exe :0xC0000005": access violation"
It is not necessary that buffer overrun causes it. Possibly you are doing some other thing wrong.
If possible, code snippet would help to solve the problem.
|
|
|
|