|
Dear Consultant,
What is the way to store
unsigned char* fingertemplate in oracle DataBase
We have In the Following Code
a variable of type fingertemplate and we preallocate 384 bytes
for it and somewhere else I want to Save It In Oracle DataBase
Please Tell Me What Is The Suitable Oracle Type For Storing
Unsinged Char * Varriable And How???
#include <stdio.h>
#include <stdlib.h>
#include "BS_API.h"
#include <stdlib.h>
#include <stdio.h>
#include "ORACL.H"
#include "OBOUND.H"
int main(int argc, char* argv[])
{
unsigned char* FingerTemplate=(unsigned char*)malloc(384);
OStartup();
ODatabase odb("local","suprema","suprema");
ODynaset odyt(odb," select ID,User_ID,template_num,template from qt_user_Template");
odyt.StartEdit();
odyt.AddNewRecord();
int temp1;
odyt.SetFieldValue("template",*FingerTemplate );
odyt.SetFieldValue("ID",temp1);
odyt.SetFieldValue("user_Id",temp1);
odyt.SetFieldValue("template_num",user->numOfFinger);
odyt.Update();
return 1;
}
JESECOV
|
|
|
|
|
Please quote your message correctly so that its appears correctly and > < characters appear correctly. Tip: that [Preview] button exists for a reason...
Oh, yeah... If the character data does not contain any NUL or binary characters, you may be able to store it in a CHAR column. Otherwise you will have to use BLOB or IMAGE types (note that I am not that familiar with Oracle...).
Peace!
-=- James If you think it costs a lot to do it right, just wait until you find out how much it costs to do it wrong! Avoid driving a vehicle taller than you and remember that Professional Driver on Closed Course does not mean your Dumb Ass on a Public Road! DeleteFXPFiles & CheckFavorites (Please rate this post!)
|
|
|
|
|
Use of pre and code when you want to post a code
|
|
|
|
|
Hi,
I need to keep an SDI application alive even after logoff.
If i run a dialog based application with system's account the application lives even after logoff..
But an SDI app doesn't. It is getting closed when logoff even if it is started with system's account..
How it is getting the logoff message...
Note : Both are simple apps created with appwizard...no more codes yet...
Is there anyway to keep it alive after logoff...
Any help is appreciated..
Thanks..
~ Selva
|
|
|
|
|
See what messages are being sent to it, like WM_ENDSESSION , for example, and handle them to prevent the normal functionality which may be to shut down.
Peace!
-=- James If you think it costs a lot to do it right, just wait until you find out how much it costs to do it wrong! Avoid driving a vehicle taller than you and remember that Professional Driver on Closed Course does not mean your Dumb Ass on a Public Road! DeleteFXPFiles & CheckFavorites (Please rate this post!)
|
|
|
|
|
Thanks James, I will do the same..
But before that,
What happens in case of a Dialog based application??? How it works...
I havent added any code to the applications. I just tested with the simple apps created with wizard...
any way i ll check the message and try to handle it...
~ Selva
|
|
|
|
|
Thanks a lot James..It works...
~ Selva
|
|
|
|
|
HI
How can i add .dll file in my project
i am using VS7.
manu
|
|
|
|
|
Can you be more detailed about your problem ?
|
|
|
|
|
I need some functionality in my project related to outlook.But i have one .dll file that contains some function that is useful for me .
Thats why i want to use them and this is possible after added the dll my code.
How can i do this
manu
|
|
|
|
|
manu_2205 wrote: I need some functionality in my project related to outlook
For this, there must be a interface you want to use.
manu_2205 wrote: But i have one .dll file that contains some function that is useful for me .
Using dll is same as you was using in VC6. Either by implicit linking or explicit linking.
|
|
|
|
|
Plz tell me about implicit/explicit linking in c++.
Actually i am new in c++.
Before i have worked in c#.
Thanx in advance
manu
|
|
|
|
|
Hmmm, you need little reading. This series of articles[^] should give you idea.
|
|
|
|
|
Do you want to use of functions on the dll?
|
|
|
|
|
Yes i want to use function of dll
manu
|
|
|
|
|
You need to load dll LoadLibrary and then use of GetProcAddress for return address of function on dll and in the end use of FreeLibrary
|
|
|
|
|
In a DB appl built with VC++ 6.0 an MFC with DB support without files
when i'm moving the recorset pointer to the first field it still doesnt't take me there.
the DB is Access and ODBC Connection has been used.
Wat could b he possible errors.
Shouvik
|
|
|
|
|
Override CRecordView::OnMove . See, if debugging gives you some clue.
|
|
|
|
|
My logic itself is wrong. C i'm using certain where condition in my query which means i'll be gettin a fitered result. now the third record shown in the ListBox nowhere means that, it is also the third record in the database. So moving the record pointer taking the LB GetCurSel() as reference is indeed a stupid way of coding.
Sorry to bother u guys up.
Shouvik
|
|
|
|
|
shouvik.d wrote: Wat could b he possible errors.
The recordset isn't open.
The recordset has no records.
Can you show the code you use to open the recordset ad move to the first record?
|
|
|
|
|
I Actually am showing a set of records in a list box and on selection from the ListBox i move to that specific record but i'm not able to go to the first record as shown in the database only so i'm not able to move to the selected records. A certain Offset value is always there which also varies according to the number of records in the recordset.
void CLibManView::OnDblclkBooks() <br />
{<br />
m_pSet->MoveFirst();<br />
m_pSet->Move(lb->GetCurSel());<br />
MessageBox(CLibManView::GetStatus(m_pSet->m_Stat));<br />
}
My whole code is too big to attatch.
Shouvik
|
|
|
|
|
What type is m_pSet and what code do you call to open it?
Maybe it's not opened in the proper mode...
Mark
|
|
|
|
|
m_pSet is of type
<code>CLibManSet* m_pSet;</code>
whereas CLibManSet is of type
<code>class CLibManSet : public CRecordset</code>
its opened as
<code>m_pSet->Open(CRecordset::dynaset, (LPCTSTR)query,CRecordset::none);</code>
Shouvik
|
|
|
|
|
Thank you The source code helps!
Are you sure your "query" is valid and returning a set of records?
If it is working correctly and there are records returned then you should be positioned on
the first record when you "open" the recordset.
m_pSet->Open(CRecordset::dynaset, (LPCTSTR)query, CRecordset::none);
if (m_pSet->IsBOF() && m_pSet->IsEOF())
{
}
else
{
}
Also if Open() returns 0 then your database isn't connected/open.
No CDBException* being thrown, correct?
Mark
|
|
|
|
|
dear mark,
the code was extremely useful. As we know if a db contains atleast one record and the record pointer is on the First Record IsBOF() will return 0,
and indeed after using m_pSet->MoveFirst the value of IsBOF() is 0.
But now in MS ACCESS the order of the records are as follows
Ac_No Name Author Type Value Date Stat
<hr>
1111 Christmas Carol Charles Dickens 2 800 12/12/2006 2
1112 The Adventures of Hucklebery Finn Mark Twain 2 799 12/1/2005 1
1113 Chip DVD 06/06 Chip Magazine 1 100 1/6/2006 1
1114 Christmas Carol Charles Dickens 2 800 12/11/2006 1
1118 Last Christmas Eagles 1 299 1/4/2005 1
1119 The Adventures of Robinson Crusoe Daniel Dafoe 2 799 1/2/2002 1
<hr>
Even after issuing MoveFirst() the pointer is pointing to 1118.
weird
Note: the fields might be a bit mangled plz bear.
Shouvik
|
|
|
|