No, I can't do it here, since the facade pattern is a quite large topic and good C++ languaqe knowledge is a pre-requisite. Anyway I may suggest you reading some good C++ books (see this thread [^] for hints), and the GoF's "Design Patterns" one. :) 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]

Dude, you've picked on a univoter. :) “Follow your bliss.” – Joseph Campbell

If you consider that the SysIPAddress32 control is comprised of four Edit controls, those edit controls are sending EN_CHANGE and EN_UPDATE notifications. That may not be an exact answer to your question, but it should give you enough to plow through Spy++ to see exactly what is going on. "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

yes, one suggestion. what's this ResourceString function. Check if there's some event happening that is sending ON_NOTIFY twice. THere can be more than one reason why OnNotify is called..

Send the EM_SETREADONLY [^] message to the edit box. :) 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]

jadhavjitendrar wrote: How to use order by clause in insert into statement AFAIK you cannot do than. However, you may add a counter field to the table and then use it to order data when querying. :) 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]

ORDER BY can be achieved by setting the COLUMN_NAME by which you want to sort the records to the "m_strSort" member of the CDaoRecordset class.

Start with this: INSERT INTO pdpstate(setid)VALUES('0') If that works, add another field/value pair. Continue until syntax error appears. "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

When strAnsi has _T("aaa\nbbb\nccc") then want to make 3 records? Do you mean like this? If then, you must split strAnsi at first and make and execute sql 3 times. For example; TCHAR* strData = strAnsi.GetBuffer(-1); TCHAR* pToken = _tcstok(strAnsi, _T("\n")); while (pToken) { CString sql; sql.Format(_T("INSERT INTO tablename (%s) VALUES('%s')"), setid, pToken); // execute SQL here } strAnsi.ReleaseBuffer(); Well, I dont feel good VALUES('%s') in above sql because of string escaping issue or SQL-injection problems. I usually use prepared statements or parameterized query for this purpose.

I think I answered your query earlier when it was the other way round i.e you wanted to convert mdb into text. You can use the same method of using CFile to read from the text file and then use DAO to write the values in the mdb file. If you are unable to find anything on google, search for DAO MFC which you might have missed as the search string. You need to google first, if you have "It's urgent please" mentioned in your question. ;-)_AnShUmAn_

is it Access or is it MySQL? It can't be both. :) Luc Pattyn Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you. Local announcement (Antwerp region): Lange Wapper? Neen!

What do you want to know? 1) How to use ODBC functionaries? 2) How to use OLE DB functionaries? 3) How to use MFC DB functionaries? 4) How to write SQL script? 5) How to use MS-Access user interface? :-D I know there are 3 different coding ways for database programing in vc++. 1 - using ODBC functions like c style. 2 - using OLE DB functions with ActiveX programing in c or c++ style. 3 - using database class in MFC in c++ style. Check your mind.

The line is wrong: you should replace it with cTestFile.Write(csSetID, csSetID.GetLength() * sizeof(TCHAR)); Anyway, I doubt this is what you really want to do (i.e. Are you trying to write a wide-char text file?)? jadhavjitendrar wrote: So plz give me solution ,it's urgent.. I recall you one of the implicit mechanism of this forum: "urgentz requests go directly inside the recycle bin". :) 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]

And here: 3. If end-of-file goto 6 But then any C[++ | #] coder can optimise that into a thing of beauty...