C / C++ / MFC

Re: retrive date from ms access file using vc++

10-Jul-08 19:49

i have stored dates in MS ACCESS file
field name is DATE and formate is mm/dd/yyyy

now i want to retirve date from database using vc++
and want to convert date in any other formate

plzzz helppp

_AnsHUMAN_ 10-Jul-08 20:06

_AnsHUMAN_

10-Jul-08 20:06

can't you follow the same thread... Mad | :mad:

do you know about ODBC or database connection classes in C++ Roll eyes | :rolleyes:

Somethings seem HARD to do, until we know how to do them.
Wink | ;-)

_AnShUmAn_

Re: retrive date from ms access file using vc++

ani_ikram10-Jul-08 20:17

10-Jul-08 20:17

i have create connectiong with MS Access database
i know how to retrive/save text vlues from/to table feilds of MS DataBase

but i am unable to get date and convert its formate

for text geting text values from feilds i am using following code:

CDaoDatabase db;
CDaoRecordset recset(&db);
db.Open("patient.mdb");
Sql = "SELECT * FROM patient WHERE (LastName LIKE '"+temp+"*')";
recset.Open(AFX_DAO_USE_DEFAULT_TYPE,Sql,NULL);

while(!recset.IsEOF())
{

recset.GetFieldValue("lastname",var);
Client = (LPCSTR)var.pbstrVal;
b->AddString(Client);
recset.MoveNext();

}

Suspend a thread

anilaabc10-Jul-08 19:44

anilaabc

10-Jul-08 19:44

how can i suspend a thread from some other thread ,i used SuspendThread method but it has no effect .

Stephen Hewitt10-Jul-08 19:52

Stephen Hewitt

10-Jul-08 19:52

Don't use SuspendThread. See here[^] for details.

Steve

Richard Andrew x6410-Jul-08 20:37

Richard Andrew x64

10-Jul-08 20:37

SuspendThread might be failing with an error.

Put this line of code directly after the call to SuspendThread:

DWORD Error = GetLastError();

Then, inspect the Error value to learn what Win32 error occured.

You can look up the error code in the program "errlook" provided with the platform SDK.

“Cannot find REALITY.SYS...Universe Halted.”

~ God on phone with Microsoft Customer Support

Roger Stoltz10-Jul-08 21:38

Roger Stoltz

10-Jul-08 21:38

In addition to Stephen's reply, you can read about the same problem here[^].

The only sane place to suspend a thread is from the thread itself.
Use may use an event or a volatile declared boolean, or a user message if it's a UI-thread, to instruct the thread to suspend itself.

"It's supposed to be hard, otherwise anybody could do it!" - selfquote
"High speed never compensates for wrong direction!" - unknown

Re: What is ldexpl in .net?

pallaka10-Jul-08 22:39

pallaka

10-Jul-08 22:39

you can use AfxEndThread()
or
KillThread()

or you can send a notification to a thread to exit

What is ldexpl in .net?

threemp310-Jul-08 19:36

threemp3

10-Jul-08 19:36

Hi guys

Does anybody know what the equivalent of ldexpl() is in C#.Net?

Any pointers would be appreciated.
Thanks.

Richard Andrew x6410-Jul-08 20:53

Richard Andrew x64

10-Jul-08 20:53

You might try asking in the C# forum.

“Cannot find REALITY.SYS...Universe Halted.”

~ God on phone with Microsoft Customer Support

Generating XML file output?

nisha0000010-Jul-08 18:41

nisha00000

10-Jul-08 18:41

Hi i have one doubt regarding how to generate XML file output for example;

main()
{
int Array_sample[];
for(int i=0;i<=10;i++)
   {
      Array_sample[i]=i;
      std::cout<<Array_sample[i]<<std::endl;
//This is generating output but i want to write this output only print in
  // XML file how do that???
   }
return 0;
}

Thanks and Regards

Nisha

enhzflep10-Jul-08 18:56

enhzflep

10-Jul-08 18:56

#include <iostream>
#include <c++/3.4.5/fstream>

using namespace std;

int main()
{
int Array_sample[10];
fstream myOutput;

myOutput.open("test.xml", fstream::out);

myOutput<<"<?xml version=\"1.0\" encoding=\"Windows-1252\"?>"<<endl;
myOutput<<"<numbers>"<<endl;
for(int i=0;i<=10;i++)
{
Array_sample[i]=i;
myOutput<<"\t<item>"<<Array_sample[i]<<"</item>"<<endl;
}
myOutput<<"</numbers>"<<endl;
myOutput.close();

return 0;
}

[EDIT:] screwed-up the quotation marks. They're fixed now.

nisha0000010-Jul-08 19:16

nisha00000

10-Jul-08 19:16

you are simply writing in console print XML senerio ...i want to generate one external XML file

AndreFratelli10-Jul-08 19:27

AndreFratelli

10-Jul-08 19:27

No .. he is actually writing to a "test.xml" file.. not stdout

myOutput.open("test.xml", fstream::out);

regards

Fratelli

set date formate in vc++ plzzzzzz help

enhzflep10-Jul-08 19:29

enhzflep

10-Jul-08 19:29

I'd normally be more polite, but you sir nisha0000, are a donkey!

It creates test.xml as it's output. For ****'s sake - try actually compiling it.

ani_ikram10-Jul-08 18:09

10-Jul-08 18:09

how to check date formate in vc++
how to set date formate in vc++

_AnsHUMAN_ 10-Jul-08 19:02

_AnsHUMAN_

10-Jul-08 19:02

ani_ikram wrote:
how to check date formate in vc++

GetDateFormat()

ani_ikram wrote:
how to set date formate in vc++

Something like this:

CDateTimeCtrl* pCtrl = (CDateTimeCtrl*) GetDlgItem(IDC_DATETIMEPICKER1);
ASSERT(pCtrl != NULL);
pCtrl->SetFormat(_T("MM-dd-yy"));

//Also check COleDateTime::SetFormat

Somethings seem HARD to do, until we know how to do them.
Wink | ;-)

_AnShUmAn_

ani_ikram10-Jul-08 19:47

10-Jul-08 19:47

i have stored dates in MS ACCESS file
field name is DATE and formate is mm/dd/yyyy

now i want to retirve date from database using vc++
and want to convert date in any other formate

plzzz helppp

pallaka10-Jul-08 22:43

pallaka

10-Jul-08 22:43

CTime tmObj = pCQScanData->GetTime();
sprintf_s(szTime, "%02d:%02d:%02d",
tmObj.GetHour(), tmObj.GetMinute(), tmObj.GetSecond() );

David Crow11-Jul-08 3:00

David Crow

11-Jul-08 3:00

See this article. Date fields are extracted from an Access database and then formatted for display.

"Love people and use things, not love things and use people." - Unknown

"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne