Dll function not inserting ths data [modified]

With_problem

i am using this code for inserting the data...and iam using oledb consumer wizard to make connection....can any body point out what is the problem here...it always get user define run time error..."Error inserting the record"...after calling dll function...any help

typedef int (CALLBACK* Set_Quote_DB)(unsigned short**,short*,unsigned short**,unsigned short**,unsigned short**,short*);

void CArielProjectVer2Dlg::OnPriceChangeArielapictrl1(LPCTSTR SessionId, LPCTSTR RequestId, short MarketNo, LPCTSTR Market, LPCTSTR Bid, short BidDirection, LPCTSTR Ask, short AskDirection, LPCTSTR High, LPCTSTR Low, short MarketState, LPCTSTR Timestamp)
{
// TODO: Add your control notification handler code here
// for dll call

HINSTANCE hInstance=LoadLibrary("WartzODLCOM.dll");
Set\_Quote\_DB SetQuote;
SetQuote = (Set\_Quote\_DB)GetProcAddress(hInstance,"setQuoteToDb");


SessID=SessionId;
CurrentRequestId=RequestId;
txtMarket = Market;
 
marketno.Format("%d",MarketNo);
bid\_d.Format("%c",BidDirection);
ask\_d.Format("%c",AskDirection);
marketstate.Format("%d",MarketState);


m\_MainEdit=m\_MainEdit + "" SessionId +  RequestId + marketno ; 
m\_MainEdit=m\_MainEdit + Market  + Bid  + bid\_d +  Ask + ask\_d  High ;
m\_MainEdit=m\_MainEdit + Low +  marketstate +  Timestamp ;

UpdateData(FALSE);
iLineCount=m_EditCtrl.GetLineCount();
m_EditCtrl.LineScroll(iLineCount);

USES\_CONVERSION;
BSTR bsTimeStamp = A2BSTR(Timestamp);
BSTR bsMarket =  A2BSTR(Market);
BSTR bsBid = A2BSTR(Bid);
BSTR bsAsk = A2BSTR(Ask);

// CALLING DLL FUNCTION
HRESULT hResult = SetQuote(&bsTimeStamp,&MarketNo,&bsMarket,&bsAsk,&bsBid,&MarketState);
if(FAILED(hResult))
{
AfxMessageBox(_T("Error inserting record"));
return;
}
else
{
MessageBox(_T("data entered" ));
}

	SysFreeString(bsTimeStamp);
SysFreeString(bsMarket);
SysFreeString(bsBid);
SysFreeString(bsAsk);

FreeLibrary( hInstance );
UpdateData(FALSE);

}

toxcct

please edit your message, and change the <code> tags with <pre>. thanks

Don't know where to start ?
Refer the Forums Guidelines and ask a friend

[VisualCalc 3.0][Flags Beginner's Guide]

Rajesh R Subramanian

toxcct wrote:

posting police

LOL :-D

Nobody can give you wiser advice than yourself. - Cicero ப்ரம்மா

toxcct

hey, that's not funny ! we have posting guidelines[^], but nobody respect them :doh:

Don't know where to start ?
Refer the Forums Guidelines and ask a friend

[VisualCalc 3.0][Flags Beginner's Guide]

Hamid Taebi

toxcct wrote:

nobody respect them

except professional members :)

WhiteSky

ThatsAlok

toxcct wrote: posting police What about Posting Police Gang

"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

toxcct

ThatsAlok wrote:

What about Posting Police Gang

:~ so you think advising people to follow CP rules is that bad ? what about Posting Crap Gang, which is very influent thoses days ? :suss:

Don't know where to start ?
Refer the Forums Guidelines and ask a friend

[VisualCalc 3.0][Flags Beginner's Guide]

Rajesh R Subramanian

toxcct wrote:

what about Posting Crap Gang, which is very influent thoses days ?

I think you're right. There's a real crappy gang set out these days who don't follow the rules.

Nobody can give you wiser advice than yourself. - Cicero ப்ரம்மா

ThatsAlok

toxcct wrote:

:~ so you think advising people to follow CP rules is that bad ?

i am not teasing you buddy... just want to from Posting Police Gang(Group).. what you say?

"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

toxcct

ThatsAlok wrote:

what you say?

i don't get you... :rolleyes:

Don't know where to start ?
Refer the Forums Guidelines and ask a friend

[VisualCalc 3.0][Flags Beginner's Guide]

Eytukan

I think you misunderstood him !

:Gong: 歡迎光臨吐西批 :Gong:

kakan

I think the main reason for this behaviour is this (in general): The obvious choice (without reading the guide lines) is to surround source code with the code tags. Which is wrong(!) :sigh: It's not easy (still, for someone who hasn't read the posting guide lines) to realize that the correct choice is to use the pre tags. The name isn't very descriptive... IMO, a change in the names in the formatting options should make it easier for the posters to do the correct choice.

Alcohol. The cause of, and the solution to, all of life's problems - Homer Simpson

toxcct

kakan wrote:

IMO, a change in the names in the formatting options should make it easier for the posters to do the correct choice

i think this will need a big big change in the CP engine. a better/simpler solution would be to provide a more explicit picture on the buttons which allow to surround a text with one or other html tags...

Don't know where to start ?
Refer the Forums Guidelines and ask a friend

[VisualCalc 3.0][Flags Beginner's Guide]

toxcct

i think so, because i know Alok is a good guy, wanting the best for CP, but still i can't get what he meant :doh:

Don't know where to start ?
Refer the Forums Guidelines and ask a friend

[VisualCalc 3.0][Flags Beginner's Guide]

kakan

I'm sure it would help up the situation. Any difference from today must be an improvement... :)

Alcohol. The cause of, and the solution to, all of life's problems - Homer Simpson