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.

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.

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

i am using MFC window so is there a way to retrieve directly from the database itself?

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

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?

is there any simpler way?

I have read up on this and tried but dun seems to get what i want to achieve.. there are some errors.

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

Instead of using the void main, I have integrate my 2 MFC to become one.. so it works perfectly fine.. ;)

Hi, Thanks for the help given.;) dReaMerzZ

Hi, thanks for the help given dReaMerzZ

Hi, Thanks for ur help and advice dReaMerzZ

Hi, Thanks for ur help. dReaMerzZ

Hi, Thanks a lot for ur advice. dReaMerzZ

hi, With what u have mention above, does it means that we cannot include any updates of the GUI codings in the thread function? I have 2 MFC program, can i use just one button to control these 2 MFC? Btw, this 2 MFC is link by a database(Microsoft Access). How can i run this 2 MFC concurrently and continously with just one Start button and will end it once i click on the Exit button. And I tried using thread function with database. But it has some errors on the recordset that i have used. can u advice me on this issue? Thanks lots.. dReaMerzZ

Hi, I have read the article that you gave me and have tried implementing the methods into my program.. however, that are still one error which i hope u could help me.. void CUpdateView::OnUpdatedb() { // TODO: Add your control notification handler code here running = true; AfxBeginThread(run, this); } UINT CUpdateView::run(LPVOID p) { CUpdateView* pView = (CUpdateView*)p; pView->run(); double propa_update = 0.814; double resp_update = 0.205; double link_update = 1.19; do { //get a pointer to the recordset **CUpdateDoc* pDoc = GetDocument();** UseRecordset* pUseRecordset = &pDoc->m_UseRecordset; //Allows the current record to be edited pUseRecordset->Edit(); //increment in the values from the database pUseRecordset->m_propatime = pUseRecordset->m_propatime*propa_update; pUseRecordset->m_respondtime = pUseRecordset->m_respondtime*resp_update; pUseRecordset->m_link = pUseRecordset->m_link*link_update; //Saves the current changes to the database pUseRecordset->Update(); //Reruns the current SQL query to refresh the recordset pUseRecordset->Requery(); }while(check_exit!=0); return 0; } void CUpdateView::OnExit() { running = false; } The part that i have it bold is giving mi the error.. the error message is : 'CUpdateView::GetDocument' : illegal call of non-static member function This problem is it because i have the UINT CUpdateView::run(LPVOID p) declare as static? see declaration of 'GetDocument' My declaration is CUpdateDoc* GetDocument(); in CUpdateView Class

For example, everytime in order for the program to run, we need to build and compile it right? But can we skip this step?

Hi, I have a smiliar problem too. I have 2 MFC using single document interface. I have 2 programs. But on click the button on the first program, can the program prompt out the second window to let it perform its operations? Thanks for ur help in advance dreamerzz

Hi, Thanks for the help given.. I have solved my problems. thanks a million dreamerzz