|
I have try to use ado AppendChunk() fucntion to save to a clob data type to oracle database, but when i read back, the data was not save to the oracle database. Anyone know what is the problem?
// BEFORE THIS FUNTION, ORACLE DATABASE WAS CONNECTED
bool ADODBHandler::UpdateMap()
{
AdoNS::_RecordsetPtr rst;
try
{
..........................
rst.CreateInstance("ADODB.Recordset");
rst->CursorType = AdoNS::adOpenKeyset;
rst->LockType = AdoNS::adLockOptimistic;
HRESULT hr = rst->Open("pcmap.WAFERMAP3_PROCESSMAP", _variant_t((IDispatch*)m_cpConnection,true), AdoNS::adOpenKeyset, AdoNS::adLockOptimistic, AdoNS::adCmdTable);
rst->AddNew();
rst->Fields->GetItem("LOTNO")->PutValue(lotno);
rst->Fields->GetItem("WAFERNO")->PutValue(WaferNo);
rst->Fields->GetItem("WAFERID")->PutValue(Waferid);
rst->Fields->GetItem("PROBER_FILE")->PutValue(ProberFile);
rst->Fields->GetItem("ORIENT")->PutValue(Orient);
rst->Fields->GetItem("ROW_COUNT")->PutValue(RowCount);
rst->Fields->GetItem("COL_COUNT")->PutValue(ColCount);
rst->Fields->GetItem("PASS")->PutValue(Pass);
rst->Fields->GetItem("FAIL")->PutValue(Fail);
rst->Fields->GetItem("SOURCE")->PutValue(Source);
rst->Fields->GetItem("ET_TIME")->PutValue(date);
rst->Fields->GetItem("MAP_VER")->PutValue(Ver);
rst->Update();
_variant_t varChunk;
varChunk.bstrVal = _bstr_t(cWafer); // cWafer is a char array about 2500 bytes long
// for some strange reasons, cannot save varChunk to database and no exception error was capture
rst->Fields->GetItem("MAP")->AppendChunk(varChunk);
rst->Update();
}
.........
}
|
|
|
|
|
you may submit the post to database forum of CodeProject, there are more db users there.
|
|
|
|
|
Hi,
I am trying to impersonate a user on Win 2k machines. The LogOnUser() api works perfect on XP, 2k3 but it fails on win 2k machines as it requires SE_TCB_NAME privilege. So i tried to set the privilege to the current process by the code available on MSDN http://msdn.microsoft.com/en-us/library/aa446619(VS.85).aspx[^] but it didnt work for me. still it fails by giving error 1314 (A required privilege is not held by the client), if i give the "Act as a part of operating system" privilege from Administrative tools -> local Security Policy -> Local Policy to that particular user, the code works perfectly on win 2k. But how to achive it through code.
Thanks,
Sandeep
|
|
|
|
|
Hi all,
I have done spliting using OnCreateClient function of MainFrame class,
I have split my view in two column.
Is this possible whenever i want split window show or whenever i dontwant only one form show.
By default the split window show when i run an application,in toolbar i have a button when i clicked the button than in place of split window onlu one form can show.
Can this is possible.
Please tell me.
Tahnks in advance.
IN A DAY, WHEN YOU DON'T COME ACROSS ANY PROBLEMS - YOU CAN BE SURE THAT YOU ARE TRAVELLING IN A WRONG PATH
|
|
|
|
|
|
I believe that the OP indicated that he could successfully split his view into two columns. He wants to remove/hide one of those panes when a toolbar button is clicked.
"Love people and use things, not love things and use people." - Unknown
"The brick walls are there for a reason...to stop the people who don't want it badly enough." - Randy Pausch
|
|
|
|
|
I am using VC6 in Vista.For accesssing data base ( MSAccess ) compenents I am using MSADO1.5 ,
But that is not working with vista.
Can anybody help me to find a solution
|
|
|
|
|
Make it work ?
Seriously, with so vague information, nobody will be able to help you.
|
|
|
|
|
You did't deserve to be voted down for that one.
|
|
|
|
|
He was probably frustrated because I didn't provide a full working solution with codezz plzz urgnt !1!!
|
|
|
|
|
Hi,
I am dovelping a wizard based applcation with 3 pages. At one page CTreeCtrl is there but when I call DeleteAllItems() It does not show any item even if I insert the item code is here:
CTreeCtrl *Tree=(CTreeCtrl *)GetDlgItem(IDC_TREE1);
Tree->DeleteAllItems();
Tree->InsertItem(_T("aa"));
And One CComboBox that does not drop down. what is the reason?
|
|
|
|
|
Try calling UpdateWindow() after the InsertItem method.
In ComboBox, after dropping the control from the resource pane into your dialog, you have to resize it vertically to set its dropdown area. Click on the pulldown button of the combobox. You will get a fram with 8 resizing points. Resize the frame vertically and try.
|
|
|
|
|
UpdateWindow() is not working and I can can pulldown the Combobox only horizontally not vertically
|
|
|
|
|
Good to see you around here on a weekend, Paul. Looks like you're addicted now.
|
|
|
|
|
Check your resource ID's (IDC_TREE1 ). GetDlgItem() will return any child control on the dialog with that ID, even if it is not a tree control. The DeleteAllItems() and InsertItem() member functions of the CTreeCtrl class only send messages. If the window they are sending those messages to is not a tree control, it will just ignore them.
This could also explain your CComboBox problem as well.
|
|
|
|
|
I have nothing that explains how I can send my program's database data to a known Excel 2007 file. Does anyone know of a tutorial on this; or have any suggestions as to go about it. I tried using the "INSERT" statement but only got one piece of data into the Excel "Sheet", there are 11 colums in the MS Access database and I would like to have those same columns in the Excel workbook. Am I supposed to create a Table with the columns in Excel before trying to transfer the data from Access in my program?
|
|
|
|
|
Hello all,
I have some questions about the windows console. If my main GUI windows create a new console windows attach to the main process by calling AllocConsole(). Is there any way to get notify when the console get closed by the user? For example, the close windows button in the top right get clicked by the user. The problem what I have is that if the console windows get closed, then my main process will also be terminated. However, it happen without letting my free my application resource. Any suggestion? Thanks for advance!
Nachi
Nacho
|
|
|
|
|
|
I need to write a program to check if an application is playing any sound through the sound card.
Has anyone had any experience with this? What library should I hook?
This is for Windows XP. The program can be built on any platform (.NET, C++).
I've tried hooking kernel32.DeviceIoControl but I don't know which functions to look for to intercept the Wave output (format and buffers). Should I hijack the sound card drivers? Or is there an easier way?
I appreciate any ideas or thought.
Thanks.
|
|
|
|
|
Hello,
I am trying to declare the above mentioned
and on compile I seem to be getting an error
message,
can any body help?
It seems to work fine, with some sample code Ive got
can anybody help?
Thanks v much
Simon
|
|
|
|
|
simon alec smith wrote: It seems to work fine...
How can it work fine with a compiler error?
Have you included afxtempl.h ?
"Love people and use things, not love things and use people." - Unknown
"The brick walls are there for a reason...to stop the people who don't want it badly enough." - Randy Pausch
|
|
|
|
|
Thank You,
It seems to compile now,
but what I dont get, is that I have some sample
code from a manual I downn loaded
and it works with out the afxtempl.h
if you have an answers that would be great
anyway thanks once again
cheers
Simon
|
|
|
|
|
wow CTypedPtrList without afxtempl.h
is should be included in some other header files , did u check ?
Vikas Amin
My First Article on CP" Virtual Serial Port "[^]
modified on Thursday, July 24, 2008 5:33 PM
|
|
|
|
|
Yes I've checked,
but knowing me it something I've overseen
anyway I dont think this website is into advertising
but If you really want to know then I will be happy
to disclose
i'm just happy that i'm in the right ball park
|
|
|
|
|
hi.
i write a program that is dialogbased.
i have 2 dialogbased form in my program and every of this 2 form want to access to another form
first dialog can access the data from another form but when i define one variable from another dialog error happen.
can u help me?
|
|
|
|