|
Guys,
Iam working with sqlite using c++, while i am trying to creating tables iam getting exception CppSQLite exception. I was already added CppSQLite3.h as header file. What i written is:
CppSQLite3.h
const *char gszfile="d:\\temp.db";
CppSQLit3DB db;
db. execDML("create table emp(cc varchar(20), subject varchar(30)");
i need solution for this, plz give me with more explanation.
|
|
|
|
|
You did not open the database.
|
|
|
|
|
hOW CAN I OPEN THE DATABASH
|
|
|
|
|
For example, your code looks like this:
const *char gszfile="d:\\temp.db";
CppSQLit3DB db;
db. execDML("create table emp(cc varchar(20), subject varchar(30)");You are missing this before you call execDML:
db.open(gszfile); When you execute the command without opening the database, you sure will get an exception.
|
|
|
|
|
Thnx to your reply, eventhough iam trying with ur solution, still same exception exist. The exception like:
c++ exception at memory location 0x0000012ee8e
|
|
|
|
|
What line is throwing the exception?
"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
"Man who follows car will be exhausted." - Confucius
|
|
|
|
|
David,
as finally i can able tog get the solution to create and insert data into sqlite tables. Now i want to display the data into listview/ treeview control, how can i get the records from existed table. Can u suggest me something.
Regards
KiranKumar
|
|
|
|
|
I have not met this type of trouble before. I am assuming that you are using the wrapper found here:
CppSQLite - C++ Wrapper for SQLite[^]
I liked that wrapper when I first read that article, but to be honest I never used it. My projects either used direct C function calls to the Sqlite library, or used a wrapper that is an enhancement of the wrapper found here:
An Easy to Use Wrapper for SQLite3 (Totally Free Embedded Database Engine!)[^]
To solve your problem, I will need to have a closer look at your code. Since you have the source code of everything, you surely can trace into the source code to pinpoint the problem. You might have discovered some problems in the wrapper, not in your code. Sqlite is always very friendly to me; surely it will be friendly to you.
Good luck!
|
|
|
|
|
bool OpenSQLite(CString sDatabaseFilePath)
{
int nRet = sqlite3_open16((char*)(LPCTSTR)sDatabaseFilePath, &m_pSQLiteDB);
if (nRet != SQLITE_OK)
{
return false;
}
return true;
}
void CloseSQLite()
{
if (m_pSQLiteDB)
{
sqlite3_close(m_pSQLiteDB);
m_pSQLiteDB = 0;
}
}
bool ExecuteQuery(CString sQuery)
{
if(!m_pSQLiteDB)
return false;
sqlite3_stmt* pVM = 0;
const TCHAR* szTail = 0;
int nRet = sqlite3_prepare16(m_pSQLiteDB,(char*)(LPCTSTR)sQuery,sQuery.GetLength()*sizeof(TCHAR), &pVM, (const void**)&szTail);
if(nRet != SQLITE_OK)
{
const char* szError= sqlite3_errmsg(m_pSQLiteDB);
return false;
}
nRet = sqlite3_step(pVM);
if(nRet ==SQLITE_DONE)
{
// u can use results
}
else if (nRet == SQLITE_ROW)
{
// row by row
}
else
{
sqlite3_finalize(pVM);
return false;
}
return true;
}
|
|
|
|
|
Sir,
My build is sccess but whan iam running the application i am getting error like:
application was unable to start correctlly, what is the problem, revert me back asap.
|
|
|
|
|
1
2 2
3 3 3
4 4 4 4
5 5 5 5 5
4 4 4 4
3 3 3
2 2
1
|
|
|
|
|
You should read book on C to get more familiar with the loops that are avail in C.
I prefer you to read "Let Us C - Yashwant Kanetkar".
Please dont expect full code from here 
well this case i can help, but what about the other cases?
So it is better to get familiar with C loops and then make a logic from your side.
All the best.
Величие не Бога может быть недооценена.
|
|
|
|
|
You need an outer loop and a inner one.
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]
|
|
|
|
|
Try this:
#include <iostream>
using namespace std;
void main()
{
const char *p[] = {"1", "2 2", "3 3 3", "4 4 4 4",
"5 5 5 5 5", "4 4 4 4", "3 3 3",
"2 2", "1"};
for (int i=0; i<sizeof(p)/sizeof(*p); ++i)
{
cout << p[i] << endl;
}
}
Steve
|
|
|
|
|
You've got my 5, for the best non-answer of the day.
I don't know why others gave you a "1" rating, I guess they didn't read what you were suggesting!
|
|
|
|
|
hmmm, this is a difficult one...
Can you see any pattern in it?
|
|
|
|
|
Rozis wrote: Can you see any pattern in it?
The laser pointer and cat design pattern? 
You measure democracy by the freedom it gives its dissidents, not the freedom it gives its assimilated conformists.
|
|
|
|
|
It is very simple. The following is the generic code algorithm.
int range = <any value="">;
int outer,inner;
//The following loop is for displaying pattern from 1 to n ( any value)
for( outer loop... )
{
for( inner loop... )
}
//The following loop is for displaying pattern from n-1 to 1
range -= 1;
for( outer loop... )
{
for( inner loop.... )
}
Understand the basic code flow and implement your code.
|
|
|
|
|
#include <iostream>
using namespace std;
void main(){
const static int threshold(5);
for(int i(1), d(+1); i; i += d, d = (i == threshold)? -1 : d){
for(int j(0), end(i); j != end; ++j) {
cout << i << " ";
}
cout << endl;
}
}
Getting rid of the ending space are trivial and left as an exercise  .
|
|
|
|
|
I am tying to figure out and start small on retrieving hardware information.
I am making a very simple program that does this:
1.) Find processor information
2.) Write found information to a log file ".txt"
3.) Display the found information on the screen
Very simple right? So I found this Win32 Processor Class at:
Win32 Processor Class
What I dont understand is how to implement this. On the website it does not say how to utilize this code. If it does, I do not see the example that is being displayed. I just see the breakdown of the Win32 Processor class and not a typical usage scenario.
So if anyone can please provide me some clarification on how to utilize this class correctly please respond back to this with what bits of information I have failed to recognize.
|
|
|
|
|
|
the example you point to is using a technology called WMI - Windows Management Instrumentation .. some examples on general WMI are here :- http://msdn.microsoft.com/en-us/library/aa394558(VS.85).aspx[^]
they might help you get going - WMI exposes a lot, but I dont think its necessarily the easiest of technologies to use/start with - others may disagree.
If I can find another starter for you I'll post back
'g'
|
|
|
|
|
The class you saw is WMI class, i prefer to use that.
The usage of class is mentioned in link itself, just check this(http://msdn.microsoft.com/en-us/library/aa390423(VS.85).aspx)
It is WMI so you need to handle like a COM.
Well try that, else you can go for suggestion from Rejeesh.
Величие не Бога может быть недооценена.
|
|
|
|
|
Ok,
So after looking at doing this I feel I need to use WMI (Windows Management Instrumentation).
Now to make sure I understand this, WMI is a tool that windows uses to read hardware information very accurately?
Now back to the programming portion. In order for me to use Win32_Processor Class, I first have to initialize CoInitilizeEx and CoInitilizeSecurity? I am a little confused about this. The COM (Component) is a library, and this library tells WMI and the Win32_Processor Class how to communicate with hardware?
Just making sure I understand everything and trying to put everything together.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
