I'm so stubit guys. You were right i forgot to define the constructor outside the class. It works fine now cheers everyone. Appreciate ur help

antonaras wrote: if i use the string.replace("&nbs"," ") it doesn't work What dosn't work? Does the compiler/linker complain? Is an exception thrown? Do any replacements happen? "The largest fire starts but with the smallest spark." - David Crow "Judge not by the eye but by the heart." - Native American Proverb

jhwurmbach wrote: You really got a obsession there, right? :) Yup!  It is what separates the wheat from the chaff... :)    Peace! -=- James If you think it costs a lot to do it right, just wait until you find out how much it costs to do it wrong! Avoid driving a vehicle taller than you and remember that Professional Driver on Closed Course does not mean your Dumb Ass on a Public Road! DeleteFXPFiles & CheckFavorites (Please rate this post!)

Viorel. wrote: I think the loop is required. You're right. I spoke prematurely. :-O Sorry about that. "The largest fire starts but with the smallest spark." - David Crow "Judge not by the eye but by the heart." - Native American Proverb

antonaras wrote: ...when i post the message my spaces where removed. Use ampersand nbsp; in your post. "The largest fire starts but with the smallest spark." - David Crow "Judge not by the eye but by the heart." - Native American Proverb

antonaras wrote: can i convert integers and doubles to _bstr_t; Just assign them: double d; int x; _bstr_t str; str = d; str = (long) x; "The largest fire starts but with the smallest spark." - David Crow "Judge not by the eye but by the heart." - Native American Proverb

antonaras wrote: _bstr_t strSQLstatment=command.c_str(); Set a breakpoint here. What is the value of command? "The largest fire starts but with the smallest spark." - David Crow "Judge not by the eye but by the heart." - Native American Proverb

antonaras wrote: command+=",Pos="+strtest;//when i write pos="valField4; i get compilation error Have you tried: command += ",Pos="; command += valField4; "The largest fire starts but with the smallest spark." - David Crow

antonaras wrote: Hi again guys a simple guestion how can i convert(assighn) a variable of type _bstr_t to string _bstr_t hi("alok");  std::string str((LPCTSTR)hi) ; "Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow cheers, Alok Gupta VC Forum Q&A :- I/ IV Support CRY- Child Relief and You

antonaras wrote: printf("%d - %s\n",(LPCSTR)valField1,valField2,valField3,valField5); This should be: printf("%d - %s\n", valField2, (LPCSTR) valField1); "The largest fire starts but with the smallest spark." - David Crow

YEAH is Working Thanks men I'm getting so close Thanks Thanks Thanks:-D:-D

antonaras wrote: SARATH can u pls write again the include files that i need to use the code was cut off They're there: #include <afxwin.h> // MFC core and standard components #include <afxext.h> // MFC extensions "The largest fire starts but with the smallest spark." - David Crow

This isn't pretty, nor is it optimal, but it covers the basics; You'll want to reindent the code, :) and I do things a little differently, by using raw interfaces when importing. Where there is a call to doQuery, you can put so UI in there to ask for & validate a query field. This is a bit rough in places, normally I use OLE DB rather than ADO, but it works. You'll need to change the name of the data source (obviously). The trick is to create the parameter and associate it with the command object. You can then use Execute to get a recordset, and having done that, you can ask the recordset to requery without needing the command object (once you've changed the parameter value. Add a different call to doQuery with a different string below the first one, and you'll see what I mean. The advantage over straight SQL text building is that in many cases, the SQL needs to be parsed only once, which is handy for complex queries, and in addition, it protects you from some nasty so-and-so from performing a SQL injection attack. (Yes, it was asking a bit much, but I had a spare 10 minutes at lunchtime[local time]) #include <windows.h> #include <tchar.h> #include <ole2.h> #import "c:\Program Files\Common Files\System\ADO\msado15.dll" \ no_namespace rename("EOF", "EndOfFile") raw_interfaces_only #include <stdio.h> #include <conio.h> void printRows(_Recordset* pRstTemp) { VARIANT_BOOL bEOF; // Ensure at top of recordset. pRstTemp->MoveFirst(); // If EOF is true, then no data and skip print loop. pRstTemp->get_EndOfFile(&bEOF); if (bEOF) { _tprintf(_T("\tRecordset empty\n")); } else { // Define temporary strings for output conversions. // Initialize to first record's values. _bstr_t bstrTitle; _bstr_t bstrType; // Enumerate Recordset and print from each. while(!bEOF) { // Convert variant string to convertable string type. FieldsPtr spFields; FieldPtr spField; long nFields; pRstTemp->get_Fields(&spFields); spFields->get_Count(&nFields); for(long f = 0; f < nFields; f++) { BSTR t = NULL; spFields->get_Item(_variant_t(f), &spField); _variant_t v; spField->get_Value(&v); spField->get_Name(&t); if (v.vt != VT_NULL) { v.ChangeType(VT_BSTR); #ifdef _UNICODE _tprintf(_T("%20.20s: %s\n"), (LPCWSTR)t, (LPCWSTR)v.bstrVal); #else _tprintf(_T("%20.20S: %S\n"), (LPCWSTR)t, (LP

string strsql; sprintf(strsql, "SELECT * FROM Table1 WHERE Name='%s'", token); pCommand->CommandText =strsql;

i think the program will throw a exception,you can look at the exception for finding out the error informtion.

This might be helpful: http://www.codeproject.com/database/WittmerADO.asp[^] -- modified at 17:30 Tuesday 30th May, 2006

I thought that's what I'd said, but did not explicitly make the point, so thanks for pointing it out. Good practice is to keep as much as possible out of loops - just look at the different code produced with and without optimisations turned on :) Steve S Developer for hire

Ok Thanks again WhiteSky You 've been very helpfull i'll try some of the code samples from the liks that you gave me and i hope i get them right this time. I never thought that connecting to a DB with visual c++ will be that hard Thanks again.