|
Does nobody know how to do this? 
|
|
|
|
|
Try here[^].
"Oh, I'm sick of doing Japanese stuff! In jail we had to be in this dumb kabuki play about the 47 Ronin, and I wanted to be Oshi, but they made me Ori!"
|
|
|
|
|
Hi,
I need to do some calculations but firstly, i need to extract values from the database and store it inside the array.
double para3[12] = {90.1, 75.2, 60.3, 91.2, 74.5, 61.2, 89.9, 74.8, 59.8, 91.4, 76.2, 60.6};
The above is method i use is hardcoding the values that i need inside the array but because i might need to add on more values to it, i can easily retrieve from the database instead of hard-coding.
Hope u can help me.. Thanks a million
dReaMerzZ
|
|
|
|
|
Read up on the CDatabase and CRecordset classes. They allow for easy access to many data sources, including, but not limited to, databases.
"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)
|
|
|
|
|
I have read up on this and tried but dun seems to get what i want to achieve.. there are some errors.
|
|
|
|
|
dreamerzz wrote:
I have read up on this...
So this article was of no help?
dreamerzz wrote:
there are some errors.
And those are?
"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)
|
|
|
|
|
DAMAGE: after Client block (#74) at 0x00432C50
i have tried a lot of other methods, when i compile it, there is no error but when i wan to build, it show me this dialog box
|
|
|
|
|
dreamerzz wrote:
when i compile it, there is no error but when i wan to build, it show me this dialog box
Are you differentiating between a compile and a build? If so, I can only assume that you mean build to be both a compile and a link. Yes?
"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)
|
|
|
|
|
sorry for the confusion.
There is a build and execute. When i build, there is no error and no warning. but when i execute, it show me the dialog box
|
|
|
|
|
Have you single-stepped through the code to see which is the offending statement? Up until you know the statement in question, we can't be of much help.
"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)
|
|
|
|
|
You can also use MFC template class CArray if you've ever tried your hands on templates. All I can assure you is that its not that difficult at all.
Gurmeet
BTW, can Google help me search my lost pajamas?
My Articles: HTML Reader C++ Class Library, Numeric Edit Control
|
|
|
|
|
is there any simpler way?
|
|
|
|
|
Using a CArray (or STL vector) is far easier than trying to get the data from a database. There will be examples aplenty on codeproject
However, if you really want to use a database, what database do you have - MS Access?
You don't say whether you're using MFC or just doing straight C++. If MFC then probably the easiest method is to use the DAO classes. Though this might be an old-fashioned way of going about it these days. You could use ADO but, if I recall, MFC does not have native ADO classes - though it's still possible to use it. the point is that these methods are all somewhat more elaborate than using a database.
Kevin
|
|
|
|
|
i am using MFC but don't have to show the values out, just need to store into array and calculate an end result we i want to acheive.
so using CArray is the only solution and easiest?
|
|
|
|
|
dreamerzz wrote:
so using CArray is the only solution...
No, of course not. It's just one of many implementations. From what information you've provided, it sounds like you simply need to store the numbers in a text file. Then you could process them with something like:
CStdioFile file("", CFile::modeRead);
CString strLine;
int nSum = 0,
nLineCount = 0;
while (file.ReadString(strLine) != FALSE)
{
nSum += atoi(strLine);
nLineCount++;
}
TRACE("The sum is %d\nThe average is %f\n", nSum, (double) nSum / nLineCount);
"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)
|
|
|
|
|
i am using MFC window so is there a way to retrieve directly from the database itself?
|
|
|
|
|
Yes, using the CDatabase and CRecordset classes.
"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)
|
|
|
|
|
ok. I think this is also the very last ans i would get. Although i don't really know how to go abt it. but still thanks for all the help that u have given.. thanks.
|
|
|
|
|
dreamerzz wrote:
Although i don't really know how to go abt it
In one of my earlier posts, I provided a link to a "how to" article. Once you go through those steps, not just glancing over them, you'll have a working example. Here are some others:
http://www.codeproject.com/database/#ODBC
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vctutor98/html/_gs_creating_a_new_database_application.asp
http://msdn.microsoft.com/library/en-us/vctutor98/html/_gs_about_step_1.asp?frame=true
"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)
|
|
|
|
|
Yes there is. Using the new operator. At run-time, find out the number of records, and then allocate an array long enough to hold values you want to retrieve. For example, assuming that you've 50 records, the code will look like this:
LONG lRecCount = 50; <font color=green>
double *pdblValues = new double[lRecCount + 1];
for(LONG i = 0; i < lRecCount; i++)
pdblValues[i] = <font color=green>collect value from the field here</font>;
One more thing, don't forget to delete[] pdblValue after you are finished with it.
Hope that helps,
Gurmeet
BTW, can Google help me search my lost pajamas?
My Articles: HTML Reader C++ Class Library, Numeric Edit Control
|
|
|
|
|
Hi,
I have tried out the coding that you have given me. but i dun seems to get the results also.. Anyway, thanks for the help given.
|
|
|
|
|
Can you please provide us with some code of how you are doing this. It may be that you are doing something wrong in your code.
Gurmeet
BTW, can Google help me search my lost pajamas?
My Articles: HTML Reader C++ Class Library, Numeric Edit Control
|
|
|
|
|
Gurmeet S. Kochar wrote:
double *pdblValues = new double[lRecCount + 1];
Why the extra one?
"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)
|
|
|
|
|
to evry programmer,
i am developing dervice and want ot know how service detct that some user has log on into the computer.
ppls tell me abt it , i am grave need of it
thanking you whosoever help me!!!!
Alok Gupta
visit me at http://alok.stormpages.com
|
|
|
|
|
are you looking for PWLX_NOTIFICATION_INFO ?
It's not a bug, it's an undocumented feature.
suhredayan@omniquad.com
messenger :suhredayan@hotmail.com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
