Hello everyone,
I'm new to SQLite as well as to this list. I'm writing because I was
planning on using SQLite for a personal -but public- project that I wanted
to make available through Google App Engine. It is basically a SQLite to
CSV converter and a SQLite to VCard converter. In other words, I
I have no way to test but i think a call like
rc = sqlite3_bind_text(stmt, 1, (LPCTSTR)likeexp, -1,
SQLITE_TRANSIENThttp://www.sqlite.org/c3ref/c_static.html
);
would work
2012/6/26 deltagam...@gmx.net deltagam...@gmx.net
Hello I have as input parameter
CString likeexp
but I think in the
If you are compiling for Unicode, your CString has a LPCWSTR (const
wchar_t*) operator. In that case use sqlite3_bind_text16. If you're not
using
Unicode, then there is a LPCSTR (const char*) operator that will let you use
sqlite3_bind_text directly like Alessandro shows.
Doug
-Original
When seeking additional pain along these lines, your attention is drawn to
sqlitejdbc.
I did get it to compile and pass its test suite; actually integrating it
with a project, not so much.
On Tue, Jun 26, 2012 at 5:39 PM, E. Timothy Uy t...@loqu8.com wrote:
40-80 hours digging deep into how
Hello,
I am porting my Java applications from Oracle Lite to SQLite and
getting those error message: “SQLite only supports TYPE_FORWARD_ONLY
cursors”.
I’d like to know if there is any (updated) SQLite JDBC driver that
supports the TYPE_SCROLL_INSENSITIVE cursors?
Thanks you.
gizu tseng gizu.ts...@gmail.com wrote:
I am porting my Java applications from Oracle Lite to SQLite and
getting those error message: “SQLite only supports TYPE_FORWARD_ONLY
cursors”.
I’d like to know if there is any (updated) SQLite JDBC driver that
supports the TYPE_SCROLL_INSENSITIVE
gizu tseng gizu.ts...@gmail.com wrote:
I am porting my Java applications from Oracle Lite to SQLite and
getting those error message: SQLite only supports TYPE_FORWARD_ONLY
cursors.
I'd like to know if there is any (updated) SQLite JDBC driver that
supports the TYPE_SCROLL_INSENSITIVE
Hello,
sqlite3 event.db select datetime('now');
gives me a time that is 2 hours too late ( 2012-06-27 15:33:13)
than my system time ( win 7 ) 17::33:13
How can this be fixed ?
___
sqlite-users mailing list
sqlite-users@sqlite.org
On Wed, Jun 27, 2012 at 05:37:55PM +0200, deltagam...@gmx.net scratched on the
wall:
Hello,
sqlite3 event.db select datetime('now');
gives me a time that is 2 hours too late ( 2012-06-27 15:33:13)
than my system time ( win 7 ) 17::33:13
How can this be fixed ?
Move two timezones
Am 27.06.2012 17:40, schrieb Jay A. Kreibich:
On Wed, Jun 27, 2012 at 05:37:55PM +0200, deltagam...@gmx.net scratched on the
wall:
Hello,
sqlite3 event.db select datetime('now');
gives me a time that is 2 hours too late ( 2012-06-27 15:33:13)
than my system time ( win 7 ) 17::33:13
How
On Wed, Jun 27, 2012 at 05:45:41PM +0200, deltagam...@gmx.net scratched on the
wall:
Am 27.06.2012 17:40, schrieb Jay A. Kreibich:
On Wed, Jun 27, 2012 at 05:37:55PM +0200, deltagam...@gmx.net scratched on
the wall:
Hello,
sqlite3 event.db select datetime('now');
gives me a time that
I'm working on getting the Mac version of the SQLite ODCB connector fully
functional. I'm having some problems getting examples of lots of different data
types - for instance, my northwind copy has a decimal stored as a varchar.
Does anyone have a small test DB they would be willing to part
Fully agree with you, Jay.
- SQLite NUL select datetime('now','localtime');
E.
On Wed, Jun 27, 2012, at 10:55, Jay A. Kreibich wrote:
On Wed, Jun 27, 2012 at 05:45:41PM +0200, deltagam...@gmx.net scratched on
the wall:
Am 27.06.2012 17:40, schrieb Jay A. Kreibich:
On Wed, Jun 27, 2012
On 27 Jun 2012, at 5:00pm, Maury Markowitz maury.markow...@gmail.com wrote:
I'm working on getting the Mac version of the SQLite ODCB connector fully
functional. I'm having some problems getting examples of lots of different
data types - for instance, my northwind copy has a decimal stored
Kinda' depend on what exactly you want to do.
If you want your application to always use local time no matter where it's run:
select('now','localtime');
If you want to know how far off of UTC you are do this:
select round((julianday('now','localtime')-julianday('now'))*24);
In my case this
UTC is the right time. If you're doing anything with dates and
times I would STRONGLY recommend that all recorded times are in UTC.
Jay is right. I've been bitten by storing local times before. Even if your
users
are in the same time zone, that time zone shifts with day light savings. It
And I should also add...sqlite doesn't respect timezones for past/future dates.
So...you may want to consider storing both UTC and localtime and then you can
do whatever you want by selecting the appropriate field. That way historical
reports can be accurate with localtime.
Or you can
On Wed, 27 Jun 2012 07:10:49 -0400, gizu tseng gizu.ts...@gmail.com
wrote:
Hello,
I am porting my Java applications from Oracle Lite to SQLite and
getting those error message: “SQLite only supports TYPE_FORWARD_ONLY
cursors”.
I’d like to know if there is any (updated) SQLite JDBC driver that
Hi there,
We are considering using the SQLite Encryption Extension in one of our
products, and are wondering what the performance characteristics of it are?
Does the encryption algorithm affect performance? Any stats on this you might
have would be useful.
Thanks!
-Paul
Hi Paul,
Are you speaking of CEROD?
FYI, I use to link sqlite3.c with the free wxSQLite3 encryption (AES128/256)
module (http://wxcode.sourceforge.net/components/wxsqlite3).
I didn't notice any significant slowing down (3-4% max.), but of course there
is no compression involved...
Hope this
On Wed, Jun 27, 2012 at 2:55 PM, Paul Vercellotti pverce...@yahoo.comwrote:
Hi there,
We are considering using the SQLite Encryption Extension in one of our
products, and are wondering what the performance characteristics of it are?
Does the encryption algorithm affect performance? Any
Sorry if this is the wrong place for this. Just a quick comment that it would
be good for the following documentation page about date functions to mention
more specifically that the value of the fields need to be in one of the time
formats:
http://www.sqlite.org/lang_datefunc.html
The 'Time
On Wed, Jun 27, 2012 at 3:34 PM, gray.sql...@mailnull.com wrote:
What is also confusing (and maybe is a feature request) is that the
default JDBC format for the Xerial driver (at least) is to output a time as
2012-07-19 09:58:18.36 which doesn't [quite] match any of the internal
formats.
I am getting back SQLITE_DONE (101) from sqlite3_step() and the statement
is clearly being executed.
SQL: INSERT INTO [Scans](ScanID, Timestamp, EndTime, Result) VALUES(NULL,
@Timestamp, @Timestamp, @Result);
The table has been created as:
CREATE TABLE [Scans]
(ScanID INTEGER NOT
http://en.shijingsteel.com/pptlr.html
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
A quick policy reminder: Emails such as the one below (don't click on the
link) result in immediate banishment from the mailing list.
I don't know if James Brison is a real person or the nom de guerre of some
robot. In either event, don't let the same fate befall you - make sure
your computer
26 matches
Mail list logo