C / C++ / MFC

why world so cruel for sleep( ) ing..??

9-Aug-04 5:55

Can hackers access our programs easily when using the sleep()? Would it be OK to use sleep() for private programs that will not be released to the public?

TssPrasad8-Aug-04 23:20

TssPrasad

8-Aug-04 23:20

why world so cruel for sleep( ) ing..??

Shiva Prasad8-Aug-04 23:20

Shiva Prasad

8-Aug-04 23:20

Database Records

Neelesh K J Jain8-Aug-04 23:10

Neelesh K J Jain

8-Aug-04 23:10

hello Friends,
I have got a table of following structure
Tran_ID Long Integer
Date Date
Type Text
Tran_Number Number
Amount Double
Quantity Double
Dr Text
Desc Memo

The above table is Created in Ms-Access, The main problem is when i use the Select query by using CRecordset object which is opened
CDatabase db;
db.Open("DSN=Test",0);
CRecordset rs(&db);
CString query;
query="Select * from Trans where Date = '08-06-2004'";
rs.Open(CRecordset::snapshot,_T(query));

I am getting an error, Data type mismatch in criteria when the query is to be executed, but where as When i used any other query which can easily match the text, its getting success, only problem with date,
thanking you,
Neelesh K J Jain.

Re: Database Records

Antti Keskinen8-Aug-04 23:24

Antti Keskinen

8-Aug-04 23:24

Hello Neelesh,

Take the query string, and open up Access (if you have it). Then execute the query as is and see the results. I suspect that there is a syntax error in the SQL statement.

Found here at Code Project, there is an ODBC Query Tool available for download that is extremely effective in creating working ODBC query strings that fetch data correctly. What I mean by this is that it is most probable that the query string you create contains a syntax error. The quotes and double-quotes that are required by some SQL query strings are problematic when it comes to C++.

First, using ODBC Query Tool, create a query string that fetches the data properly. Then copy this string as is into your C++ code. If you need double-quotes, place a forward-slash '/' in front of them on the string, so they are treated properly.

-Antti Keskinen

----------------------------------------------
The definition of impossible is strictly dependant
on what we think is possible.

Re: Database Records

David Crow9-Aug-04 2:52

David Crow

9-Aug-04 2:52

Neelesh K J Jain wrote:
query="Select * from Trans where Date = '08-06-2004'";

You are not taking the time into consideration, nor are you using the # symbol for date types. You'll need something like:

query = "SELECT * FROM Trans WHERE Date BETWEEN #08/06/2004 00:00:00# AND #08/06/2004 23:59:59#";

"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen

Database Records

Neelesh K J Jain8-Aug-04 23:05

Neelesh K J Jain

8-Aug-04 23:05

hello Friends,
I have got a table of following structure

How to call different dialog box on a property sheet clicking on OK buttton?.

Rajesh_K_Sharma8-Aug-04 22:39

Rajesh_K_Sharma

8-Aug-04 22:39

Hi

I made three property pages on a property sheet.
Page1,Page2 and Page3.
A property sheet contains three button (OK, Cancel and Apply Buttons).
I also made three - dialog box.
Dialog1,Dialog2 and Dialog3.

Now ,I would like to do that when we select page1 and click on OK button on
a property sheet then dialog1 should be called.Similarly,when we select page2 and click
on OK button on a property sheet then dialog2 should be called. Similarly on page3.

I wrote some code:-

BOOL CPropertySheet::OnCommand(WPARAM wParam, LPARAM lParam)
{

if (LOWORD(wParam)==IDOK) {
CPage1* page1;
page1=(CPage1*)GetPage(0);
page1->UpdateData(TRUE);
CDialog1 dlg1;
dlg1.DoModal();
page1->UpdateData(TRUE);

CPage2* page2;
page2=(CPage2*)GetPage(1);
page2->UpdateData(TRUE);
CDialog2 dlg2;
dlg2.DoModal();
page2->UpdateData(TRUE);

CPage3* page3;
page3=(CPage3*)GetPage(2);
page3->UpdateData(TRUE);
CDialog3 dlg3;
dlg3.DoModal();
page3->UpdateData(TRUE);

return TRUE;
} else

return CPropertySheet::OnCommand(wParam, lParam);

}

What should I write the code ?

Any help appreciated .

rajesh

Re: How to call different dialog box on a property sheet clicking on OK buttton?.

David Crow9-Aug-04 3:00

David Crow

9-Aug-04 3:00

Something like:

BOOL CPropertySheet::OnCommand( WPARAM wParam, LPARAM lParam )
{ 
    if (IDOK == LOWORD(wParam))
    {
        int nIndex = GetActiveIndex();
        if (0 == nIndex)
        {
            CDialog1 dlg;
            dlg.DoModal();
        }
        else if (1 == nIndex)
        {
            CDialog2 dlg;
            dlg.DoModal();
        }
        else if (2 == nIndex)
        {
            CDialog3 dlg;
            dlg.DoModal();
        }
    }
    ...
}

"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen

OpenScManager()

Anonymous8-Aug-04 22:11

8-Aug-04 22:11

SC_HANDLE SCManager = OpenSCManager(NULL,NULL,SC_MANAGER_ALL_ACCESS);

This function works when i am administrator. but when i run this function as a user(other than administrator), it returns NULL.
why is it so?
can anyone help?

Re: OpenScManager()

Mike Beckerleg9-Aug-04 0:34

Mike Beckerleg

9-Aug-04 0:34

The other users you are using don't have permissions to connect with the SC_MANAGER_ALL_ACCESS level (which gives access to all functionality). You can try opening the manager with a lower level of access that your normal users should have. What do you want to do with the service manager?

Re: OpenScManager()

Anonymous9-Aug-04 1:05

Embedded CDateTimeCtrl in CListCtrl

9-Aug-04 1:05

i want to create a service and start the service.

Re: OpenScManager()

Mike Beckerleg9-Aug-04 1:08

Mike Beckerleg

9-Aug-04 1:08

The MSDN documentation for OpenScManager says "Only processes with Administrator privileges are able to open a database handle used by the CreateService and LockServiceDatabase functions."

mace8-Aug-04 21:53

8-Aug-04 21:53

Hi all,

I have a strange problem with embedding a CDateTimeCtrl in a CListCtrl...

When the control is shown it partly shows the date, it's if the
date gets shifted to the left, so for example if the date is today
it only shows -8-2004 instead of 9-8-2004.

I tried resizing it with different rectangle sizes and different
control styles but nothing seems to do the trick? Confused | :confused:

Any leads on how to solve this strange thingy are greatly appreciated!

Thanks,
mace

David Crow9-Aug-04 3:05

David Crow

9-Aug-04 3:05

mace wrote:
I tried resizing it with different rectangle sizes...

Does this mean you made the column wider?

"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen

mace9-Aug-04 3:38

9-Aug-04 3:38

Well I didn't make the column itself wider, but the control displayed on it.

I tried to make it wider, or higher but none of it helped.
At first I thought I made the control's width to small so I enlarged
it but unfortunately this wasn't the case.

Any further clues?

Thanks,
mace

Anonymous9-Aug-04 5:58

9-Aug-04 5:58

I'm not that good with C++, but you know how most numeric values start of from 0? Perhaps you need to do something similar... e.g, begin date at 0 - I'm not sure if off-setting the date is possible. But if it is, I bet that would be your problem.

mace9-Aug-04 6:27

9-Aug-04 6:27

No the problem is not that the values in the control are not correctly
initialized, moreover that the day-value gets shifted to the left
so it's not visible to the user. If I click on the control and
jump to the left with the cursor the complete value is visible.

But thanks for your suggestion anyway, if you or somebody else
knows another lead I hope to hear it....

Thanks,
mace

mace9-Aug-04 23:43