C / C++ / MFC

Re: syntax for calling stored procedure

12-Dec-06 18:16

what is the syntax for calling stored procedure

led mike12-Dec-06 18:30

led mike

12-Dec-06 18:30

is in the documentation at msdn.microsoft.com

"Alot of the people on this forum are incredibly stupid, thinking that the internet is real"
Score: 1.0 in the Soap Box

led mike

Re: syntax for calling stored procedure

David Crow13-Dec-06 7:16

David Crow

13-Dec-06 7:16

abrakadbra wrote:
what is the syntax for calling stored procedure

From?

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

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

Virtual memory usage ? How ?

Sakthiu12-Dec-06 18:16

Sakthiu

12-Dec-06 18:16

Dear All,

I want to use virtual memory more rather than main memory.

I need virual memory usage techniques those can be applied for application that has no user interfaces (Dialogs).

Kindly let me know.

Thanks.

Re: Virtual memory usage ? How ?

CPallini12-Dec-06 19:48

CPallini

12-Dec-06 19:48

Virtual memory usage it's not up to you. OS provides that to applications.
Smile | :)

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.

Re: Virtual memory usage ? How ?

kakan12-Dec-06 20:33

kakan

12-Dec-06 20:33

VirtualAlloc() / VirtualFree() ?
http://msdn2.microsoft.com/en-gb/library/aa366887.aspx[^]

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

RegSetValueEx cant figure it out

locoone12-Dec-06 17:30

locoone

12-Dec-06 17:30

BOOL bRetVal;<br />
    hKey = HKEY_CURRENT_USER;<br />
	path = "Software\\Microsoft\\Windows\\CurrentVersion\\Explorer\\Advanced";<br />
	DWORD data = 1;<br />
	DWORD datas = sizeof(DWORD);<br />
	RegOpenKeyEx(hKey, path, NULL, KEY_QUERY_VALUE, &hKey);<br />
	<br />
	bRetVal = RegSetValueEx(<br />
		hKey, <br />
		"Start_SearchFiles", <br />
		NULL, <br />
		REG_DWORD,<br />
		(CONST BYTE *) data,<br />
		datas<br />
		);<br />
	if (bRetVal == ERROR_SUCCESS)<br />
	{<br />
		MessageBox("set");<br />
	}<br />
	else<br />
	{<br />
		MessageBox("set failed");<br />
	}<br />
	RegCloseKey(hKey);

ive tryed everything i can think of and every time set failed goes off can someone point out what im missing?

Re: RegSetValueEx cant figure it out

«_Superman_»12-Dec-06 18:19

«_Superman_»

12-Dec-06 18:19

I guess it is because you are opening the registry key with KEY_QUERY_VALUE access. This will allow only query and not set.

« Superman »

Re: RegSetValueEx cant read documentation

led mike12-Dec-06 18:27

led mike

12-Dec-06 18:27

locoone wrote:
what im missing?

What you are missing is "reading" the documentation[^]

Parameters

hKey
[in] A handle to an open registry key. The key must have been opened with the KEY_SET_VALUE access right.

led mike

Re: RegSetValueEx cant figure it out

prasad_som12-Dec-06 18:53

12-Dec-06 18:53

locoone wrote:
RegOpenKeyEx(hKey, path, NULL, KEY_QUERY_VALUE, &hKey);

Here you need to set KEY_SET_VALUE , as mentioned earlier.

locoone wrote:
bRetVal = RegSetValueEx(
hKey,
"Start_SearchFiles",
NULL,
REG_DWORD,
(CONST BYTE *) data,
datas
);

You need to pass address of data, instead you have type casted data itself to (CONST BYTE *).
So you call can be modified as,

bRetVal = RegSetValueEx(
hKey, 
"Start_SearchFiles", 
NULL, 
REG_DWORD,
(CONST BYTE *) (&data),//<-- pass address
datas
);

Prasad
Notifier using ATL | Operator new[],delete[][^]

calling function...dll

With_problem12-Dec-06 17:17

12-Dec-06 17:17

//This is dll function which i am calling to insert data

<br />
short setQuoteToDB(BSTR* strDateTimeStamp, short* intMarketNo, BSTR* strMarketName, BSTR* strBid, BSTR* strAsk, short* intMarketState);<br />

// This is function from which i am getting data fom remote server

 <br />
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) <br />

Now when i call this dll function....setQuotetoDB...by passing parameter i got error

<br />
setQuoteToDB(Timestamp,marketno,Market,ask_d,bid_d,marketstate);<br />

What should i do so that i can insert data...in database...any help...

prasad_som12-Dec-06 18:08

12-Dec-06 18:08

abrakadbra wrote:
Now when i call this dll function....setQuotetoDB...by passing parameter i got error

Which error ?

Prasad
Notifier using ATL | Operator new[],delete[][^]

With_problem12-Dec-06 18:09

12-Dec-06 18:09

setQuoteToDB' : cannot convert parameter 1 from 'const char *' to 'unsigned short ** '

prasad_som12-Dec-06 18:25

12-Dec-06 18:25

You are passing LPCTSTR in place of BSTR*.
Convert LPCTSTR to BSTR by using

USES_CONVERSION;
BSTR b =A2BSTR(lpszText);//lpszText is LPCSTR

and pass it address to wherever BSTR* is required.

Prasad
Notifier using ATL | Operator new[],delete[][^]

With_problem12-Dec-06 18:31

12-Dec-06 18:31

Can you tell me more clearly...by writing one converting data type...i am very thankful to you

prasad_som12-Dec-06 18:42

12-Dec-06 18:42

abrakadbra wrote:
setQuoteToDB(Timestamp,marketno,Market,ask_d,bid_d,marketstate

This call would go like,

USES_CONVERSION;
BSTR bsTimeStamp = A2BSTR(Timestamp);
BSTR bsMarket =  A2BSTR(Market);
BSTR bsBid = A2BSTR(Bid);
BSTR bsAsk = A2BSTR(Ask);
setQuoteToDB(&bsTimeStamp,&marketno,&bsMarket,&bsAsk,&bsBid,&marketstate);
// in above call <code>short*</code> parameter will go as it is
SysFreeString(bsTimeStamp);
SysFreeString(bsMarket);
SysFreeString(bsBid);
SysFreeString(bsAsk);

Prasad
Notifier using ATL | Operator new[],delete[][^]

With_problem12-Dec-06 18:54

12-Dec-06 18:54

I am really thankful for your effort....i am trying to solve this from past 20 days

but now i am getting error for
'setQuoteToDB' : cannot convert parameter 2 from 'class CString *' to 'short *'

How to solve this....pls

With_problem12-Dec-06 18:57

12-Dec-06 18:57

I have define
1)marketno and market state as CString to format(marketno.Format("%d",MarketNo);
2)marketstate.Format("%d",MarketState);

With_problem12-Dec-06 19:36

12-Dec-06 19:36

you are not going to hlp me anymore????pls help me.... Frown | :(

prasad_som12-Dec-06 20:26

12-Dec-06 20:26

To make others solve your problem, you need to give complete/clear problem definition.
You can convert CString to BSTR using CString::AllocSysString().

Prasad
Notifier using ATL | Operator new[],delete[][^]

With_problem12-Dec-06 20:42

12-Dec-06 20:42

This is the complete code i am using and geeting error for marketno,and marketstate
setQuoteToDB' : cannot convert parameter 2 from 'unsigned short ** ' to 'short *'

<br />
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) <br />
{<br />
	// TODO: Add your control notification handler code here<br />
	      SessID=SessionId;<br />
	      CurrentRequestId=RequestId;<br />
	      txtMarket = Market;<br />
<br />
        //  declaration of vaiable for marketno and market state as CString<br />
        	marketno.Format("%d",MarketNo);<br />
	        bid_d.Format("%c",BidDirection);<br />
        	ask_d.Format("%c",AskDirection);<br />
	        marketstate.Format("%d",MarketState);<br />
    <br />
<br />
    m_MainEdit=m_MainEdit + "<Price Change>"  + SessionId + RequestId + marketno ; <br />
    m_MainEdit=m_MainEdit +  Market +  Bid  + bid_d +  Ask +ask_d + High ;<br />
    m_MainEdit=m_MainEdit + Low  marketstate + Timestamp + "\r\n";<br />
<br />
	UpdateData(FALSE);<br />
	iLineCount=m_EditCtrl.GetLineCount();<br />
	m_EditCtrl.LineScroll(iLineCount);<br />
    <br />
	USES_CONVERSION;<br />
	BSTR bsmarketno = marketno.AllocSysString();<br />
	BSTR bsTimeStamp = A2BSTR(Timestamp);<br />
	BSTR bsMarket =  A2BSTR(Market);<br />
	BSTR bsBid = A2BSTR(Bid);<br />
	BSTR bsAsk = A2BSTR(Ask);<br />
    <br />
	setQuoteToDB(&bsTimeStamp,&bsmarketno,&bsMarket,&bsAsk,&bsBid,&marketstate);<br />
<br />
	SysFreeString(bsTimeStamp);<br />
	SysFreeString(bsMarket);<br />
	SysFreeString(bsBid);<br />
	SysFreeString(bsAsk);<br />
	<br />
<br />

Error:

<br />
setQuoteToDB' : cannot convert parameter 2 from 'unsigned short ** ' to 'short *'<br />

prasad_som12-Dec-06 21:56