|
hi.. i've already added the required sqlite3.h header file yet the error messages are not resolved. Can you please help me on that. This is my coding:
// SQLITE1.cpp : Defines the entry point for the console application.
//
#include "stdafx.h"
#include <stdio.h>
#include "sqlite3.h"
static int callback(void *NotUsed, int argc, char **argv, char **azColName){
int i;
for(i=0; i<argc; i++){
printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
}
printf("\n");
return 0;
}
int main(int argc, char **argv){
sqlite3 *db;
char *zErrMsg = 0;
int rc;
if( argc!=3 ){
fprintf(stderr, "Usage: %s DATABASE SQL-STATEMENT\n", argv[0]);
}
rc = sqlite3_open(argv[1], &db);
if( rc ){
fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
sqlite3_close(db);
}
rc = sqlite3_exec(db, argv[2], callback, 0, &zErrMsg);
if( rc!=SQLITE_OK ){
fprintf(stderr, "SQL error: %s\n", zErrMsg);
sqlite3_free(zErrMsg);
}
sqlite3_close(db);
return 0;
}
|
|
|
|
|
vanishaa wrote: hi.. i've already added the required sqlite3.h header file yet the error messages are not resolved.
A .h file is not a library file, it's a header file. You need to have a *.lib file to be added in your project settings: in the linker category, you need to add the name of the lib file in "Additional Dependencies" or something like that (I don't have VS installed on my PC here so I can't give you the exact location, but search a bit and you'll find it).
|
|
|
|
|
I'm using visual c++ for the project and already added the sqlite3.dll file. The same error occurs again. I have no idea where it went wrong..
|
|
|
|
|
I'm talking about a .LIB file, not a dll file. Did you add this lib file in your project settings (3rd time I'm asking) ?
|
|
|
|
|
Hi all ,
is there any function that converts this string str = "23/02/09 14:44:13" to julian date format in C or C++ .
thanks in advance .
|
|
|
|
|
Vijjuuuuuuuuu........... wrote: is there any function that converts this string str = "23/02/09 14:44:13" to julian date format in C or C++ .
Yes (and it possibly returns 09034 for your input).
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]
|
|
|
|
|
Thanks for the reply , but is there any function to do that ?
|
|
|
|
|
You can roll your own one. What are your doubts while doing that?
I recall for you the needed steps (if you aren't using MFC or ATL). You have to:
- Parse the string to obtain
day-of-month, month and year from the string. - Convert
day-of-month and month to day-of-year. - Align properly
year and day-of-year values in the resulting number.
In the above task, only point(2) is a bit tricky because of leap years.
Using MFC or ATL would make your life easier.
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 Monday, February 23, 2009 4:11 AM
|
|
|
|
|
just use scansf grab the constituent parts and throw it into a SYSTEMTIME struct.
Just rember that scanf assumes int * and the systemtime struct is all word size objects.
a programmer traped in a thugs body
|
|
|
|
|
DWORD Month,Day,Year,Hour,Minute,Second;
//Initalize the values and the structure to zero
Month = Day = Year = Hour = Minute = Second = 0;
memset(&ST,0,sizeof(ST));
//Fix This use the stram reader so I can read the write size
//Parse out the date with sscanf
sscanf_s(Val.c_str(),"%d/%d/%d %d:%d:%d ",&Day,&Month,&Year,&Hour,&Minute,
&Second);
//reassign the values into the structure
ST.wDay = (WORD) Day ;
ST.wMonth = (WORD) Month ;
ST.wYear = (WORD) Year ;
ST.wHour = (WORD) Hour ;
ST.wSecond = (WORD) Second;
ST.wMinute = (WORD) Minute;
a programmer traped in a thugs body
|
|
|
|
|
it depends on what you mean by julian date - since the term is most often miss-used these days.
If you mean 'the day number as a number starting counting from the 1st of Jan in the Current year', then you need to follow the advice of our trusted and esteemed colleague CPallini
If you mean since an arbitrary point in time - such as is used by astronomers etc, ie 4713BC, then, part one of CPallini's response still applies, then you feed the results of the parse into something like :-
http://www.silverglass.org/code/Date.html[^]
'g'
|
|
|
|
|
Thanks for replying me 
|
|
|
|
|
|
|
Vijjuuuuuuuuu........... wrote: ...to julian date...
Which one?
"Old age is like a bank account. You withdraw later in life what you have deposited along the way." - Unknown
"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
|
|
|
|
|
i am RichEdit box in my application,...how can i change the background colour of this RichEditBox?need help plzz!!!!
|
|
|
|
|
Use SendMessage to send the EM_SETBKGNDCOLOR message to the rich edit control.
Look at the documentation for EM_SETBKGNDCOLOR on how this is done.
«_Superman_»
I love work. It gives me something to do between weekends.
|
|
|
|
|
|
Hi
I need to log a warning message if count of similar active X controls on a window is greater than 10. I have the window name with me. I need the logic to count the Active X controls on same window.
Thanks.
|
|
|
|
|
I suppose (it's just a guess, however) you simply cannot do that.
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]
|
|
|
|
|
Hai!
In the Resource view of my application there are folders such as Dialog, String table, Icon, Version. If i click the version a window appears which contains the updated values of file version and product version etc.
How can i programmatically get this value of product version as i need it to display in an AfxMessageBox. Is there any function to access this value of Product version.
Thanks!
|
|
|
|
|
Check out the following APIs
GetFileVersionInfoSize
GetFileVersionInfo
VerQueryValue
«_Superman_»
I love work. It gives me something to do between weekends.
|
|
|
|
|
CodeProject has articles showing you how to do that.
Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
|
|
|
|
|
Hi,
I have been posting messages re: WIN32 C app my last few question have been regarding Calculating the number of characters in the edit control of a Rich Edit Dialog Box
All of the really nice pepole here have been sending me code snipts to help me out however most of the Code was of the MFC variety
In order to get with the program I decided to re-write my C app using the MFC classes as opposed to plain old WIN32 SDK api's
So now getting back to My orignal Problem I have been using WM_SETTEXT and EM_REPLACSEL meesages to highlight certian pieces of the Dialog Box
Now that I am using the methods to the base Class CDialog
seems using the DDX macros is the way transfer data as opposed to
WM_SETTEXT and WM_GETTEXT
will DDX still work To HighlIght data using EM_RELACESEL ????
thankx Again
|
|
|
|
|
Why don't you try it?
Why don't you use CRichEditCtrl::ReplaceSel [^]?
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
