C / C++ / MFC

26-Sep-06 20:46

See here[^]

WhiteSky

Re: reading outlook.pst

neha.agarwal2726-Sep-06 20:50

neha.agarwal27

26-Sep-06 20:50

i have already seen this code this is simply picking up the folders which are exsisting there in the pst file my problem is that i want to read deleted items to (that r deleted from deleted items to).is there any type of check or flag bit which is placed infront of deleted folder.or its id is deleted

Re: reading outlook.pst

David Crow27-Sep-06 3:10

David Crow

27-Sep-06 3:10

Can you use Outlook automation?

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

what this code is doing?

With_problem26-Sep-06 20:28

26-Sep-06 20:28

Can anybody here explain me wht this code is doing.Thanks

<br />
	  CDaoDatabase database;<br />
	  CDaoRecordset recordset(&database);<br />
	  CString lpszFile = "c:\\Database.mdb";<br />
	  database.Create(lpszFile);<br />
	  database.Open(lpszFile);<br />
	  CString SqlCmd = "CREATE TABLE MYTable.mdb (MarketNo VARCHAR(2),MarketName VARCHAR(8),Bid VARCHAR(10),Ask VARCHAR(10),MarketState VARCHAR(2))";<br />
      database.Execute(SqlCmd);<br />
      recordset.Open(AFX_DAO_USE_DEFAULT_TYPE,"SELECT * FROM MyTable",0);<br />
	  database.Execute("INSERT INTO MyTable(MarketNo)");<br />
      database.Execute("INSERT INTO MyTable(MarketName)");<br />
	  database.Execute("INSERT INTO MyTable(Bid)");<br />
	  database.Execute("INSERT INTO MyTable(Ask)");<br />
	  database.Execute("INSERT INTO MyTable(MarketState)");<br />
	  recordset.AddNew();<br />
	  recordset.SetFieldValue("MarketNo","a");<br />
      recordset.SetFieldValue("MarketName",Market);<br />
      recordset.SetFieldValue("Bid","b");<br />
	  recordset.SetFieldValue("Ask","c");<br />
	  recordset.SetFieldValue("MarketState","d");<br />
      recordset.Update();<br />
      recordset.MoveNext();<br />
      recordset.AddNew();<br />

Hamid_RT26-Sep-06 20:39

26-Sep-06 20:39

It seems that it open a access database and create a table with 5 cols and then read all records of MyTable and insert datas to these cols

WhiteSky

With_problem26-Sep-06 20:59

26-Sep-06 20:59

i also think so..then why it is not creating database table with 5 col....and inserting data in that...do you have any idea.....

Hamid_RT27-Sep-06 8:24

27-Sep-06 8:24

And when you create your database why use open and also MoveNext you dont have any records except one

WhiteSky

With_problem26-Sep-06 21:00

26-Sep-06 21:00

i also think so..then why it is not creating database table with 5 col....and inserting data in that...do you have any idea.....or can you say hoe to c mytable

Hamid_RT26-Sep-06 22:10

26-Sep-06 22:10

CDaoDatabase database;
CDaoRecordset recordset(&database);
CString lpszFile = "c:\\Database2.mdb";
database.Create(lpszFile);
//database.Open(lpszFile);
CString SqlCmd = "CREATE TABLE MYTable (MarketNo VARCHAR(2),MarketName VARCHAR(8),Bid VARCHAR(10),Ask VARCHAR(10),MarketState VARCHAR(2))";
database.Execute(SqlCmd);
recordset.Open(AFX_DAO_USE_DEFAULT_TYPE,"SELECT * FROM MyTable",0);
database.Execute("INSERT INTO MyTable values('a','Market','b','c','d')");
//database.Execute("INSERT INTO MyTable(MarketName)");
//database.Execute("INSERT INTO MyTable(Bid)");
//database.Execute("INSERT INTO MyTable(Ask)");
//database.Execute("INSERT INTO MyTable(MarketState)");
recordset.AddNew();
recordset.SetFieldValue("MarketNo","2a");
recordset.SetFieldValue("MarketName","2Market");
recordset.SetFieldValue("Bid","2b");
recordset.SetFieldValue("Ask","2c");
recordset.SetFieldValue("MarketState","2d");
recordset.Update();
//recordset.MoveNext();
recordset.AddNew();

WhiteSky

Steve Echols26-Sep-06 21:09

Steve Echols

26-Sep-06 21:09

abrakadbra wrote:
CString SqlCmd = "CREATE TABLE MYTable.mdb (MarketNo VARCHAR(2),MarketName VARCHAR(8),Bid VARCHAR(10),Ask VARCHAR(10),MarketState VARCHAR(2))";

Try removing the .mdb from your create table statement.

- S
50 cups of coffee and you know it's on!

Steve Echols26-Sep-06 21:20

Steve Echols

26-Sep-06 21:20

Not sure exactly what your're trying to do, but your insert into statements don't look right.

To add records, you can either use insert into statements or recordset's addnew/update, but you don't need to do both.

database.Execute( "INSERT INTO MyTable(MarketNo, MarketName, Bid, Ask, MarketState) VALUES('1', 'myname', '123', '150', 'A')" );

- S
50 cups of coffee and you know it's on!

With_problem26-Sep-06 21:27

26-Sep-06 21:27

ok...but i am not able to c mytable..it is not creating the table..why..

Steve Echols26-Sep-06 21:37

Steve Echols

26-Sep-06 21:37

You might have more luck in the Database Forum http://www.codeproject.com/script/comments/forums.asp?forumid=1725[^], but I don't think Access understands the same column types as SQL (i.e. you might need to change the varchar() to Text or something).

Do you have Access installed? Try creating your database in Access, and then maybe you can figure out the correct create table statement.

- S
50 cups of coffee and you know it's on!

David Crow27-Sep-06 3:13

David Crow

27-Sep-06 3:13

Why not wrap this code in a TRY/CATCH block to see why it is failing?

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

serial communication prog?

Reagan Conservative27-Sep-06 8:32

Reagan Conservative

27-Sep-06 8:32

I seem to remember that you need to register the .mdb (forgot how to do it exactly), but I don't think you are going to have any luck until you register the database with Access. Or have things changed since my last foray into DBs about 5 years ago?

John P.

Sunshine Always26-Sep-06 20:25

Sunshine Always

26-Sep-06 20:25

where can i get sample programs for serial communication using MFC?

Re: serial communication prog?

Hamid_RT26-Sep-06 20:40

Re: serial communication prog?

26-Sep-06 20:40

See Creating a serial communication on Win32 [^]

WhiteSky

Ștefan-Mihai MOGA26-Sep-06 22:51

Ștefan-Mihai MOGA

26-Sep-06 22:51

I recomend you use either Ramon de Klein's Serial library for C++[^] or Ashish Dhar's Serial Communication in Windows[^] Good luck and keep the good coding!

Memory Allocation

Polite Programmer26-Sep-06 20:10

Polite Programmer

26-Sep-06 20:10

Sometimes, while allocating memory in my programs, I get NULL in responce to call of new operator.
Sometimes, when I execute following pair of statements, I get Heap Error.

TCHAR * szText = new TCHAR[iLen * 7] ;
//... Some Code
delete [] szText ; // Causes heap error

Where and what I might be doing wrong?

Polite Programmer

More Object Oriented then C#

Cedric Moonen26-Sep-06 20:10

Cedric Moonen

26-Sep-06 20:10

What is the value of iLen ? And what is the code missing between these two lines. You don't provide any valuable information for us to help you...

Cédric Moonen
Software developer

Charting control [Updated - v1.1]

Polite Programmer26-Sep-06 20:22

Polite Programmer

26-Sep-06 20:22

You are right, not enough information:
Value of iLen is > 0 < 200. Moreover, between the lines, we are just calling string manipulation functions like strlen, strcpy etc. But when the delete []szText is executed, heap corruption message follows....

Polite Programmer

More Object Oriented then C#

Cedric Moonen26-Sep-06 20:28

Cedric Moonen

26-Sep-06 20:28

Can you post the exact code ? We cannot help if you don't provide meaningfull informations.

Cédric Moonen
Software developer

Charting control [Updated - v1.1]

David Crow27-Sep-06 3:16

David Crow

27-Sep-06 3:16

Polite Programmer wrote:
between the lines, we are just calling string manipulation functions like strlen, strcpy etc.

What if these are omitted? Does the problem still exist? If not, it could be that you are writing outside of the allocated memory.

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb