|
Hi All
I have a problem to use command "describe tablename" in mfc vc++."Describe tablename" is working well in oracle SQl plus.
Here is code
_ConnectionPtr m_pConn;
_RecordsetPtr pRecordset;
m_pConn->Open (_bstr_t ("Provider=OraOLEDB.Oracle;PLSQLRSet=1;Data Source=orcl"),_bstr_t ("system"), _bstr_t ("password"), adModeUnknown);
pCommand->ActiveConnection = m_pConn;
CString fileddetail="describe supplier";
pRecordset=m_pConn->Execute(_bstr_t(fileddetail), 0, adCmdText);
Error is here
OraOLEDB Error: -2147217900 ORA-00900: invalid SQL statement IDispatch error #3092
Connection part is working well.
I know some member told me this is a DBA forum question why you post here.But one thing describe or DESC command is working well in oracle.So i think it's a question of MFC VC++.
Please help me
|
|
|
|
|
The Error messages means there is not this accout in the security database.Please check out the database accout name is right or wrong,espicaly look at using space in string or not.
|
|
|
|
|
Hi,
What is the difference between hash_map and hash_multimap?
Can you please help me in implementing hash_multimap in VS 2008 (for C++) with
Key as const char*
Value as Class (some class say mycalss).
After implementation how to insert the values?
Thanks,
nandu
|
|
|
|
|
hash_map[^] & hash_multimap[^]. You will find an example for using hash_multimap in the link provided. On similar lines you can use the key as const char*
You need to google first, if you have "It's urgent please" mentioned in your question.
 _AnShUmAn_
|
|
|
|
|
1) I tried the below and got the error:
ommb.h(398) : error C2065: 'hash' : undeclared identifier
#include <hash_map>
#include //maha
using namespace std; //maha
using namespace stdext; //maha
struct eqstr
{
bool operator()(const char* s1, const char* s2) const
{
return strcmp(s1, s2) == 0;
}
};
typedef hash_multimap<const char*,="" int,="" hash<const="" char*="">, eqstr> map_type;
void lookup(const map_type& Map, const char* str)
{
cout << str << ": ";
pair<map_type::const_iterator, map_type::const_iterator=""> p =
Map.equal_range(str);
for (map_type::const_iterator i = p.first; i != p.second; ++i)
cout << (*i).second << " ";
cout << endl;
}
2) then i tried changing the type def to
typedef hash_multimap <const char*,="" ccommnode*,="" eqstr=""> test; and below is the error:
error C2903: 'rebind' : symbol is neither a class template nor a function template
C:\Program Files\Microsoft Visual Studio 9.0\VC\include\xhash(148) : see reference to class template instantiation 'stdext::_Hmap_traits<_Kty,_Ty,_Tr,_Alloc,_Mfl>' being compiled
with
[
_Kty=const char *,
_Ty=CCommNode *,
_Tr=functorHashString,
_Alloc=functorEqualStrings,
_Mfl=true
]
C:\Program Files\Microsoft Visual Studio 9.0\VC\include\hash_map(182) : see reference to class template instantiation 'stdext::_Hash<_Traits>' being compiled
with
[
_Traits=stdext::_Hmap_traits<const char="" *,ccommnode="" *,functorhashstring,functorequalstrings,true="">
Can any please help me where i am going wrong.
Thanks,
Nandu
|
|
|
|
|
Hi,
How to split column header in different lines in list control?
Thanks
|
|
|
|
|
|
Hi all,
i want to write a program in which i want to establish connectivity with database(sql server 2005).
i am not getting where to start from, if anybody please provide me with some link our tutorials to start with... it will be of great help...
Thanks in advance
To accomplish great things, we must not only act, but also dream;
not only plan, but also believe.
|
|
|
|
|
See here[^],here[^] and here[^]
Also Please check Database[^] section of CP. There you will find plenty of articles about database connectivity.
I hope it helps.
Regards,
Sandip.
|
|
|
|
|
|
I have a very basic question to ask. I'm not able to find out if the OnReceive() function of the CAsyncSocket class will always be called automatically when a message is sent by the client OR do we have to write code such that the function is called everytime a message is sent?
|
|
|
|
|
liz3 wrote: I'm not able to find out if the OnReceive() function of the CAsyncSocket class will always be called automatically when a message is sent by the client OR do we have to write code such that the function is called everytime a message is sent?
If you have established a connection with the client, the OnReceive() function will be called automtically called when the client sends you a message.
|
|
|
|
|
yes.. u r rite!!!
|
|
|
|
|
thankyou. But it is not called just the first time right?
I mean, client and server establish the connection, client sends a msg to the server. Then, the OnReceive() function is called. But after that, for subsequent msgs sent by the client, will the OnReceive() function be called automatically?
|
|
|
|
|
Yes see OnReceive() on MSDN[^]: Notifies this socket that there is data in the buffer for it to retrieve by calling Receive.
|
|
|
|
|
ok, thankyou all for ur help
|
|
|
|
|
Hi,
i have this assignment and i would like some help with it please. It is my first assignment ever in c++ and it is my first go at writing code for it. Ill post the question and my code so far if anyone could help me get the code correct and working would be really great.
Question:
Your program should operate continuously with a list of drinks and their costs displayed on screen. there should also be a "shutdown" option with a password for a service person to come and re-stock the machine.
Once a user has selected their drink the system should allow them to enter the amount of money they are inserting into the machine. The program should then calculate the amount of change to be returned and subtract one from the number of the drink in the machine. If the user selects a drink which has sold out an appropriate message should be displayed. Some input validation should be carried out on the amount eg. no negative values and no amount larger than $10.
When the "Shutdown" option is chosen the system should report total turnover and number of each drink left in the machine. After a suitable input from the service person the system should then reset the number of drinks back to the initial values and resume normal operation.
Arrays must be used and an expected looping menu-structure.
the drinks are:
coca cola...$1.50....30 (in machine)
sprite........$1.60....30
fanta.........$1.70....30
ginger beer...$1.90.....30
powerade.....$3.50.....20
And this is what i have done so far. It's all mixed up but please forgive me as its my first go. Please help me if you can?
//
//
#include <iomanip>
#include <iostream>
#include <string>
#include <cmath>
using namespace std;
const int SIZE = 5; // Array size.
struct drink_machine
{
string drinkName ;
double drinkCost;
int numDrink;
double buyDrink;
float moneyIn;
float moneyOut;
int drinks ;
int inputMoney;
double choice;
};
struct drink_machine drink_mach[SIZE];
int main()
{
int menuChoice=1, choice;
drink_mach[0]= "Coca Cola";
drink_mach[1]= "Sprite";
drink_mach[2]= "Fanta";
drink_mach[3]= "Ginger Beer";
drink_mach[4]= "Powerade";
while(menuChoice != 6)
{
cout << "Choose A Drink To Purchase: " << endl;
cout << "1 - Coca Cola" << endl;
cout << "2 - Sprite" << endl;
cout << "3 - Fanta" << endl;
cout << "4 - Ginger Beer" << endl;
cout << "5 - Powerade" << endl;
cout << "6 - Quit\n" << endl;
choice = menuChoice;
}
return 0;
}
|
|
|
|
|
queenzz wrote: Please help me if you can?
There is so much still to do here that it is almost impossible to 'help' without doing all your work for you. I would suggest writing out the steps the program needs (in natural language) and then trying to convert what you have written into actual code. You also need to spend some time studying the use of structs and classes to use as your drinks. For example your individual drinks probably need to be held in a 'drink' class and will need a number to show price and availability.
|
|
|
|
|
queenzz wrote: i have this assignment...
From Tony Gaddis' book?
"One man's wage rise is another man's price increase." - Harold Wilson
"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
|
|
|
|
|
Inside a message handler for WM_LBUTTONDOWN, several functions are being called, one of which is known to display a dialog box under certain circumstances. Prior to this function being called, the mouse is captured using SetCapture(). However when that dialog is shown, the WM_LBUTTONUP appears to be getting swallowed by that dialog, and as such, to the underlying control that spawned the dialog, the mouse still appears to be down.
In looking for a passive method of detecting whether the dialog has been displayed, the code will call GetCapture() to retrieve the handle to the current window with the capture and check it against the handle to which the capture had been previously set. If the handles are different, it will post a WM_LBUTTONUP message to the message queue to "complete the click". Sample code:
::SetCapture(hWnd);
FunctionThatCouldDisplayADialog();
HWND hWndCapture = ::GetCapture();
if(hWnd != hWndCapture)
{
::PostMessage(hWnd, WM_LBUTTONUP, 0, MAKELPARAM(x, y));
}
With some testing of various scenarios (with more to come), this appears to be a reliable method to determine if a dialog was displayed during the current line of execution. To quote the manager of my team, this wreaks of being a hack, and as such, we're still mildly skeptical on the reliability of this method. I'm looking for feedback on this and whether anyone can see any potential pitfalls, issues or concerns for which we should be accounting.
Thanks.
|
|
|
|
|
Can you check if you can use WM_ACTIVATE message on your main window?. The state is supposed to be WA_INACTIVE when the dialog box is displayed.
|
|
|
|
|
Unfortunately given the way the solution is overall designed, that is not possible.
|
|
|
|
|
When I compiled a free-source code for a KLT point implementation (a feature point used widely in Computer vision) using VC with MFC support,
I got a compilation error "error C2632: 'float' followed by 'char' is illegal " for the line:
"float small,"
and error "C2062: type 'char' unexpected" for the line " if (det < small) return (int)(KLT_SMALL_DET);"
Seems the variable name "small" is illegal in VC 2005, I have tried "t_small" instead, then the problem is gone!!
That is really weird!!! Is "small" a reserved keyword in VC2005?.
I have never seen that kind of error message before!.
Following is the source code, the problematic line is in bold font:
static int _solveEquation(
float gxx, float gxy, float gyy,
float ex, float ey,
float small,
float *dx, float *dy)
{ float det = gxx*gyy - gxy*gxy;
if (det < small) return (int)(KLT_SMALL_DET);
*dx = (gyy*ex - gxy*ey)/det;
*dy = (gxx*ey - gxy*ex)/det;
return KLT_TRACKED;
}
|
|
|
|
|
According to this[^] it shouldn't.
Is there any typedef or any other kind of association with that word in the programm? Try to look for "small" in all files in your project. The compiler can complain about that use, but the cause could be in any other place.
Regards.
--------
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpfull answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
The source code you provided compiles fine on 2010 (provided KLT_SMALL_DET and KLT_TRACKED are defined).
Are you sure there arent't spurious characters in your original source file?
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]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Java | [Coffee]](https://codeproject.freetls.fastly.net/script/Forums/Images/coffee.gif)
(
