C / C++ / MFC Discussion Boards

How to update a field in an DB using MFC

moh.hijjawi9-Oct-09 4:20

9-Oct-09 4:20

Hi all,
I am new in MFC. $Shucks | :-\$

I am struggling with one of my system's modules which is I need to edit filed's value in the data source depending on some variables.

My problem is I stuck with Recordset type because I making the editting via SQL statment and the following which are I done so far:

CDatabase DBDecaying;

CString SqlRulesDecaying;

CString sDriver("MICROSOFT ACCESS DRIVER (*.mdb)");
CString sDsn;
CString ssDSN("ODBC;DRIVER={%s};DSN='';DBQ=%s");
CString sFile("c:\\DB\\db.mdb");

sDsn.Format(ssDSN, sDriver, sFile);

DBDecaying.Open(NULL,false,false,sDsn);

CRecordset RecSetRulesDecaying( &DBDecaying );

int X=2,Y=3;
double NewActiLevel = 0;

SqlRulesDecaying.Format(_T("update Rules set RActiLevel=%f where CNum=%d and
RNum=%d"),NewActiLevel,X,Y);

RecSetRulesDecaying.Open(CRecordset::forwardOnly,SqlRulesDecaying,CRecordset::??????);

Regarding the first parameter I tried snapshot,dynaset and dynamic instead of forwardonly. nothing happens.

So what I should put insted of ???? I tried (Update,Can Update,..) but I had syntax errors.

So please any help will be appreciated.

Best regards.

Re: How to update a field in an DB using MFC

David Crow9-Oct-09 4:48

David Crow

9-Oct-09 4:48

moh.hijjawi wrote:
Regarding the first parameter I tried snapshot,dynaset and dynamic instead of forwardonly. nothing happens.

Since CRecordset::forwardOnly is a read-only recordset, that would be the one to not choose. Any of the others should work.

moh.hijjawi wrote:
So what I should put insted of ????

CRecordset::none should be sufficient.

"Old age is like a bank account. You withdraw later in life what you have deposited along the way." - Unknown

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

Re: How to update a field in an DB using MFC

moh.hijjawi9-Oct-09 5:33

moh.hijjawi

9-Oct-09 5:33

First of all thank you.

I did like you mentioned but i have an error which is "Attempt to open a table failed- there is no columns to retrieve were specified" and I sure that the sql it is OK;

please any help

Re: How to update a field in an DB using MFC

David Crow9-Oct-09 5:38

David Crow

9-Oct-09 5:38

Have you tried:

CString sDriver("MICROSOFT ACCESS DRIVER (*.mdb)");
CString ssDSN("ODBC;DRIVER={%s};DSN='';DBQ=%s");
CString sFile("c:\\DB\\db.mdb");
  
CString sDsn;
sDsn.Format(ssDSN, sDriver, sFile);
  
int X=2,Y=3;
double NewActiLevel = 0; 
  
CString SqlRulesDecaying;
SqlRulesDecaying.Format(_T("update Rules set RActiLevel=%f where CNum=%d and RNum=%d"),NewActiLevel,X,Y); 
  
CDatabase DBDecaying;
DBDecaying.Open(NULL,false,false,sDsn);
DBDecaying.ExecuteSQL(SqlRulesDecaying);

Re: How to update a field in an DB using MFC

moh.hijjawi9-Oct-09 5:46

moh.hijjawi

9-Oct-09 5:46

Now it works fine. so there is no need for recordset statement.

Thank you very much indeed Smile | :)

Searching item in second column list control using find function

Le@rner9-Oct-09 2:37

Le@rner

9-Oct-09 2:37

Hi all,

I have a Report style list control an i want to search an item inside that list control using Find function.

My problem is i want to search that item in second column.

LVFINDINFO info;
int nIndex = 0;
info.flags = LVFI_STRING;
info.psz = FirstRun;
while ((nIndex = g_index->FindItem(&info)) != -1)
{
	g_index->DeleteItem(nIndex);
}

This code searches value in first column only.

How can i do this...

To accomplish great things, we must not only act, but also dream;
not only plan, but also believe.

Re: Searching item in second column list control using find function

David Crow9-Oct-09 3:37

David Crow

9-Oct-09 3:37

How about:

for (int x = 0; x < g_index.ItemCount(); x++)
{
    CString strText = g_index.GetItemText(x, col);
    if (strText == FirstRun)
    {
        g_index->DeleteItem(x);
        break;
    }
}

How to remove C4389

KASR19-Oct-09 0:26

KASR1

9-Oct-09 0:26

The following code genarates C4389 warning.
How to remove this?

int main()
{
int a = 9;
unsigned int b = 10;
if (a == b) // C4389
return 0;
else
return 0;
};

Re: How to remove C4389

sashoalm9-Oct-09 0:30

sashoalm

9-Oct-09 0:30

use

unsigned int a = 9;
unsigned int b = 10;

int a = 9;
int b = 10;

There is sufficient light for those who desire to see, and there is sufficient darkness for those of a contrary disposition.
Blaise Pascal

Re: How to remove C4389

transoft9-Oct-09 2:41

transoft

9-Oct-09 2:41

#pragma warning( disable : 4389 )

BG color for popup dialogs

hellogany8-Oct-09 23:16

hellogany

8-Oct-09 23:16

Hi
i want to set BG color for DoModal Dialogs .

can any one suggest me...

i.e i have 2 dialogs , say dg1,dg2.

when i click a button in dg1, dg2 dialog appears.i need to set the bg for dg2...

Thanks in advance

Regards
Gany

Re: BG color for popup dialogs [modified]

Hristo-Bojilov8-Oct-09 23:58

Hristo-Bojilov

8-Oct-09 23:58

Hope this helps. Smile | :)

[EDIT]

Here is another sample how to change MFC common dialog BG color.

Life is a stage and we are all actors!

modified on Friday, October 9, 2009 6:35 AM

Re: BG color for popup dialogs

Anish C.V9-Oct-09 1:04

Anish C.V

9-Oct-09 1:04

Override the

HBRUSH CXDlg::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor)

and return a suitable colour brush which will be used for BG color of the dialog.

Anish C.V

http://www.iedetech.com

[Message Deleted]

Mogamboo_Khush_Hua8-Oct-09 22:51

Mogamboo_Khush_Hua

8-Oct-09 22:51

[Message Deleted]

Re: problem in string searching

minkowski8-Oct-09 22:56

minkowski

8-Oct-09 22:56

Hi,

Have a look here

http://www.cppreference.com/wiki/string/start[^]

HTH

Re: problem in string searching

Jijo.Raj8-Oct-09 23:10

Jijo.Raj

8-Oct-09 23:10

Hello,

Have a look into case insensitive string[^] as well.

Best Regards,
Jijo.

_____________________________________________________

http://weseetips.com[^] Visual C++ tips and tricks. Updated daily.

Re: problem in string searching

CPallini8-Oct-09 23:50

CPallini

8-Oct-09 23:50

What are you trying to do? Do you want to find, given two strings, a common subtring?
Please elaborate.
Smile | :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke

[My articles]

question on using kdbg

minkowski8-Oct-09 22:17

minkowski

8-Oct-09 22:17

Hi,

Hope this question is relevant to this forum. Would like to know how to set a break point in kdbg in a .cpp file that is not in the same directory as the exe (such that I cannot see the source code in the debugger where I wish to set the breakpoint).

Thanks for any information.

Problem with CreateProcessAsUser( ) ? [modified]

Kushagra Tiwari8-Oct-09 21:23

Kushagra Tiwari

8-Oct-09 21:23

Hello ALL,

In one of my applications running under local user account, I need to spawn a process internally from system account.I was using OpenProcessToken () and was trying to collect token of winlogon.exe running under system account and was specifying flag as TOKEN_ALL_ACCESS but this fails.

Also if I specify the FLAG as TOKEN_QUERY then I get the handle but then trying to CreateProcesswithUser resulted in Error "Access is denied". Can some body suggest me a solution through which I can spawn a new process through SYSTEM account when my process itself is running through a user account .

Regards,
Kushagra

I hate to code but I luv to develop Smile | :)

modified on Friday, October 9, 2009 3:29 AM

Re: Problem with CreateProcessAsUser( ) ?

Rajesh R Subramanian8-Oct-09 21:35

Rajesh R Subramanian

8-Oct-09 21:35

Kushagra Tiwari wrote:
I was using OpenProcessToken () and was trying to collect token of winlogon.exe running under system account and was specifying flag as TOKEN_ALL_ACCESS but this fails.

The API documentation states that you could call GetLastError()[^] to get extended information on the reason for failure. Have you tried that?

It is a crappy thing, but it's life -^ Carlo Pallini

Re: Problem with CreateProcessAsUser( ) ?

Kushagra Tiwari8-Oct-09 21:43

Kushagra Tiwari

8-Oct-09 21:43

I got "Access is denied" (using getlasterror())error while trying to call openprocesstoken as I already mentioned. But some how I want to spawn a process through system account while my base process is running under user account.

Kushagra

Question regarding excel files

Le@rner8-Oct-09 21:04

Le@rner

8-Oct-09 21:04

Hi all,

i have a excel files,

i want to divide into known number of small files.

for example::
if original excel file have 10000 rows,and we want to divide it in 6 parts.
its means create 6 files those have 10000/6 row in each file.

but the serial of copying data in small file not according to serial it must be on random basis.

means 10000/6==1666.67

any 1666 row of original file write in any other excel file.

please tell me how can i do this.

if possible please provide me any example.

thanks in advance.

Re: Question regarding excel files

Rajesh R Subramanian8-Oct-09 21:33

Rajesh R Subramanian

8-Oct-09 21:33

You could use BasicExcel - A Class to Read and Write to Microsoft Excel[^] to deal with excel files (I'm not sure if it supports the 2007 format files, but works with older ones).

The math part, of course, you should do it.

It is a crappy thing, but it's life -^ Carlo Pallini

Re: Question regarding excel files

kilt8-Oct-09 23:12

kilt

8-Oct-09 23:12

Useless.
Simply copy one of the numerous Microsoft COM samples to parse Excel files

Re: Question regarding excel files

Rajesh R Subramanian9-Oct-09 1:11

Rajesh R Subramanian

9-Oct-09 1:11

It isn't "useless". Someone has put their efforts into it.

If you have something "useful" to say, say it to the OP by replying to his message.

It is a crappy thing, but it's life -^ Carlo Pallini

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.