|
hi everybody.
in my vc++ application cannot insert data into database....
success fully inserting to passing values...using this code line
SQLExecDirect(hstmt,(unsigned char *)"insert into emp values(222,'shan',5676)" ,SQL_NTS);
but using varibles(dynamically) cannot inserting.
SQLINTEGER empnum=1006;
SQLVARCHAR ename[20]="weewe";
SQLFLOAT esal=5656;
SQLExecDirect(hstmt,(unsigned char *)"insert into emp values(empnum,'ename',esal)",SQL_NTS);
please solve this porblem......
thanks in advance......
|
|
|
|
|
eswar pothula wrote: SQLExecDirect(hstmt,(unsigned char *)"insert into emp values(empnum,'ename',esal)",SQL_NTS);
Code is treating (empnum,'ename',esal)as the values and not as variable...So this code tries to insert string into Interger data type for the colum Emp number and salary and so it errors out
If you want to dynamically assign the values, my sugesstion would be bind the parameters using
SQLBindParameter and execute using
SQLExecute
cheers,
Super
------------------------------------------
Too much of good is bad,mix some evil in it
modified on Tuesday, November 3, 2009 5:21 AM
|
|
|
|
|
eswar pothula wrote: SQLExecDirect(hstmt,(unsigned char *)"insert into emp values(empnum,'ename',esal)",SQL_NTS);
That's wrong.
Try to change it to:
const int SIZE = 256;
char sqlcmd[SIZE];
sprintf(sqlcmd, "insert into emp values(%d,'%s',%f)", empnum, ename, esal);
SQLExecDirect(hstmt,(unsigned char *) sqlcmd, SQL_NTS);
of course, in real life, you should check for buffer overruns, etc...
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]
|
|
|
|
|
Hi All,
I have a dialog based application and are there any general scenarios where i can make the application hang.
Thanks,
Hari
|
|
|
|
|
Hari_16 wrote: I have a dialog based application and are there any general scenarios where i can make the application hang
There are quite a lot, I suppose.
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]
|
|
|
|
|
Can u name some of them.....
|
|
|
|
|
Well it is difficult to point some, until and unless knowing your intentions
Величие не Бога может быть недооценена.
|
|
|
|
|
Honestly .. no specific intentions just had some crashes and fixed it .. so was thinking of ways to hang an application .
In my project i use multithreading and critical section to synchronise them....
|
|
|
|
|
Multithreading and synchronization is not more than enough for a dead lock.
Just check the the various conditions of dead lock.
have to home work on your operating system knowledge
Just refer Modern operating systems from Andrew S. Tanenbaum.
I love this book
Величие не Бога может быть недооценена.
|
|
|
|
|
If you do not use a critical section, that won't make your application "hang". You'll possibly lose out on data corruption due to race condition, but the threads will continue to execute and at worst you'll take a nasty crash (like an access fault).
But a using or not using a critical section won't have anything to do with a "hang", unless a thread is being a dog and locking a resource (for a long time) that the UI thread is waiting for. But that boils down to my other reply that I've posted to your original query.
“Follow your bliss.” – Joseph Campbell
|
|
|
|
|
You may put an infinite loop somewhere.
Your thread may wait for a dead synchronization object.
A blocking I/O function call...
[added]
You may even lauch Eclipse, for the purpose
[/added]
There are quite a lot ways for you, to make it happen...
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]
modified on Tuesday, November 3, 2009 5:28 AM
|
|
|
|
|
|
You want to construct or Destruct the application ?
|
|
|
|
|
At the moment Destruct
|
|
|
|
|
By "hang", I assume that an application becomes unresponsive? If that's it, then blocking the UI thread would be almost the only reason why it happens.
For example, if there's a lengthy calculation of some sort, like parsing a huge file, then that should be done on a separate thread.
“Follow your bliss.” – Joseph Campbell
|
|
|
|
|
|
Hari_16 wrote: where i can make the application hang
I am not sure why you want to hang your own thread but this should work:
SuspendThread(GetCurrentThread());
Best Wishes,
-David Delaune
|
|
|
|
|
|
Dear friends,
When I draw a simple cube, in a DXUT empty project (which can be found in DirectX Sample Browser), the cube becomes transparent. all sides of the cube are visible. I like to have a concrete cube. I'm exhausted. How can I do that?
|
|
|
|
|
Hello,
How to change the background color of the dropdown list in combo box.
I changed the back ground color of dialog box in OnCtlColor() method, this changed the color of all the items on the dialog.
I could individual controls color but not able to change the dropdown list color of combo box.
Below is the code snippet.
if(pWnd->GetDlgCtrlID() == IDC_COMBO1)
{
HBRUSH g_bkcolor = CreateSolidBrush(RGB(255,255,255));
pDC->SetTextColor(RGB(0,0,0));
pDC->SetBkColor (RGB(255,255,255));
hbr = g_bkcolor;
return hbr;
}
If someone knows how to change the color please let me know.. Thank You..
|
|
|
|
|
1.Derive the Combo box class
2.Overide the WM_CREATE message
i.e CBS_OWNERDRAWFIXED in Create function
3. Handel the DrawItem function of Combobox
Here
a. Fill the Item's rectabgle with the color you wanted to show as background
b. Then drawtext on top of it.
I think this much clue is sufficient.
|
|
|
|
|
Thanks for the reply.
I am not that expect in MFC to get it.
Could you explain it with an example?
Than you once again..
|
|
|
|
|
Using colors in CEdit and CStatic[^]
This article will help you to understand how to create the custom control according to requirement. After understanding those start working on your combo box.
|
|
|
|
|
Hello Friends
I am using setWindowLong with parameters like:
HWND colorpickerHwnd= bmap->GetWindow();
WNDPROC wpOrigPPProc15 = (WNDPROC) SetWindowLong(colorpickerHwnd,
GWL_WNDPROC, (LONG) PPSubclassProc15);
and the Window Procedure is
LRESULT CALLBACK PPSubclassProc15(
HWND hwnd,
UINT uMsg,
WPARAM wParam,
LPARAM lParam)
{
if(uMsg == WM_LBUTTONDOWN)
{
}
return CallWindowProc(wpOrigPPProc15, hwnd, uMsg,
wParam, lParam);
}
Now,the Problem is that It is going to that Window procedure but not recieving any messages(like mouse click and move etc)
Am I missing Something?
please suggest me something.
Thanks
Yogesh
|
|
|
|
|
yogeshs wrote: Now,the Problem is that It is going to that Window procedure but not recieving any messages(like mouse click and move etc)
This does not really make sense; if it is calling the windows procedure then it must be sending messages to it.
What is 'bmap' and where does it sit in the zorder of your windows? Are you sure it has the focus at the time that you are trying to use the mouse on it?
|
|
|
|