I'd be surprised if a port to a non-mainstream OS was available for free,
but you never know. This may be your best bet:
see 6.0 Custom Modifications
http://www.hwaci.com/sw/sqlite/prosupport.html
--- panslaw <[EMAIL PROTECTED]> wrote:
> I know that SQLite was written in C and I'm sure it's possi
One of the strengths of SQLite is having the flexability to
hook it up to any language you like. But it would make life easier
for everyone if there was some sort of standard built-in simple
scripting language to create stored procedures and custom functions
within the standard SQLite distro to
Uwe Sander <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Am Donnerstag, 21. Dezember 2006 04:03 schrieb [EMAIL PROTECTED]:
> > My compiler does not define CP_OEM. Can somebody please tell me
> > what the literal value of that macro is?
>
> I think, the name of the constant is CP_OEMCP,
Yes. I figured
People with access to win95 and winCE, please test the
latest changes to see if they work. I do not have access to
any of these systems and so I have no way of testing the
changes myself. Thanks.
The following files have been modified:
http://www.sqlite.org/cvstrac/getfile?f=sqlite/src/loade
Hi,
Am Donnerstag, 21. Dezember 2006 04:03 schrieb [EMAIL PROTECTED]:
> My compiler does not define CP_OEM. Can somebody please tell me
> what the literal value of that macro is?
I think, the name of the constant is CP_OEMCP, its value is 1. Don't have a
CP_OEM on my disk.
- Uwe
-
Brodie Thiesfield <[EMAIL PROTECTED]> wrote:
>
> To be safe, the unicodeToMbcs needs to determine which codepage to
> convert to in the WideCharToMultiByte calls. This is done by calling the
> AreFileApisANSI() http://snipurl.com/arefileapisansi like:
> UINT codepage = AreFileApisANSI() ? CP_ACP :
The utf8ToUnicode function uses MultiByteToWideChar(CP_UTF8) which it
seems from recent comments isn't supported on all versions of Windows
CE. This may need to be changed to use the internal UTF-8 to UTF-16
conversion routines.
To be safe, the unicodeToMbcs needs to determine which codepage to
co
Another wince change... Wince users, please verify patch [3543]
for me. http://www.sqlite.org/cvstrac/chngview?cn=2123
--
D. Richard Hipp <[EMAIL PROTECTED]>
-
To unsubscribe, send email to [EMAIL PROTECTED]
---
Wince users, please verify that the code still works after
applying patch [3542]. This patch reduces the number of
utf8->unicode conversions required on wince.
http://www.sqlite.org/cvstrac/chngview?cn=3542
--
D. Richard Hipp <[EMAIL PROTECTED]>
win95/nt/ce users, please test check-in [3541] to see if extension
loading now works on wince and to make sure that nothing broke on
win95/nt. Tnx.
http://www.sqlite.org/cvstrac/chngview?cn=3541
--
D. Richard Hipp <[EMAIL PROTECTED]>
---
Robert Simpson wrote:
CP_UTF8 doesn't work on most CE platforms and hence your proposed patch
doesn't work.
Then neither did drh's. Which then only leaves the option of
implementing it in os_win.c which I have been wanting to do all along.
> Robert wrote:
>> Brodie wrote:
>>> Robert wrote:
> -Original Message-
> From: Brodie Thiesfield [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 20, 2006 4:43 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Need a wince test
>
> Robert Simpson wrote:
> >> From: Brodie Thiesfield [mailto:[EMAIL PROTECTED]
> >> Robert, you ar
Robert Simpson wrote:
From: Brodie Thiesfield [mailto:[EMAIL PROTECTED]
Robert, you are missing the point. Because of the way this is being
defined, there is a need to check for _UNICODE. If you don't then a
build with _UNICODE defined will fail. If it was implemented like the
rest of the functio
Jeff Godfrey wrote:
I'm curious how others handle this.
A. You don't need or use any custom SQL functionality
B. You don't use a 3rd party SQLite management tool
C. Something else I haven't thought of?
Jeff,
I think it is mostly A, or B, or at least it alternates between A and B
depending
Laszlo Elteto wrote:
Nested transactions would solve my problem - but only if it worked across
different connections. As I said there are many transactions from various
clients, they may use multiple connections (eg. on a server). I think nested
transactions would still be for ONE particular conn
> -Original Message-
> From: Brodie Thiesfield [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 20, 2006 12:17 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Need a wince test
>
> Robert, does the patch I provided work as is on Windows CE or not?
>
> Robert Simpson wrote:
>
Julien,
Thanks for the pointer. That does indeed look interesting, though I'm
not sure it completely solves my problem (though, there may be no good
solution to my problem). It would seem that, using the "loadable
extension" feature, I could easily create a compiled version of my
necessary
[EMAIL PROTECTED] wrote:
> Brodie Thiesfield <[EMAIL PROTECTED]> wrote:
[...]
> SQLite should never expect strings in any encoding other
> than UTF-8 or UTF-16. (Note that ASCII is a proper subset
> of UTF-8 so SQLite will also accept ASCII.) I do not know
> what CP_ACP is, but if it is not a su
On Wed, Dec 20, 2006 at 01:22:06PM -0500, Laszlo Elteto wrote:
> Nested transactions would solve my problem - but only if it worked across
> different connections. As I said there are many transactions from various
> clients, they may use multiple connections (eg. on a server). I think nested
> tra
Brodie Thiesfield <[EMAIL PROTECTED]> wrote:
>
> As far as I understand, sqlite changed sometime in the early 3.0
> versions such that char* strings (input and output) are always assumed
> to be UTF-8.
>
[...]
>
> Yes. But this is a separate problem. Look at the code in os_win.c, e.g.
> sqlite
Robert, does the patch I provided work as is on Windows CE or not?
Robert Simpson wrote:
There's some flaws in your arguments, Brodie ...
1. There's no need to do this whole _UNICODE test, only the _WINCE test is
needed. All versions of Windows that support unicode also support the ANSI
versi
Nested transactions would solve my problem - but only if it worked across
different connections. As I said there are many transactions from various
clients, they may use multiple connections (eg. on a server). I think nested
transactions would still be for ONE particular connection only...
Laszlo
It is the same problem as trying to get a quart out of a pint bottle.
People looking for durability and higher performance might find that
using 15,000 RPM disks will do it without affecting durability or
requiring an application redesign. Experimentation with multiple disk
spindles so that S
On Wed, Dec 20, 2006 at 02:01:12AM +, [EMAIL PROTECTED] wrote:
> Laszlo Elteto <[EMAIL PROTECTED]> wrote:
> > I DO need Durability, so I don't want to drop that. In fact, I need and want
> > normal transactional updates - just not immediately flushed to disk.
>
> If the information is not flu
"Francesco Andrisani" <[EMAIL PROTECTED]> wrote:
> Hi comunity,
> i'm writing CGI pages (writeen in ANSI C) with SQLITE3 support, all work fine
> using "SELECT" statement, but when i try to exec "UPDATE" or "INSERT"
> statement i've the follow error:
>
> unable to open database file
>
> I've se
> -Original Message-
> From: Brodie Thiesfield [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 19, 2006 9:17 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Need a wince test
>
> There are a few problems with your patch.
>
> +# ifdef _WIN32_WCE
> +static HANDLE loadLibrar
That may not be good enough. I actually do need the transactions within a
few seconds (for consistency and availablility for other clients) - It's
just that a few seconds of transaction loss is not a problem (on restart the
system would reset to a good state).
It seems nobody has ever done this ty
Hi comunity,
i'm writing CGI pages (writeen in ANSI C) with SQLITE3 support, all work fine
using "SELECT" statement, but when i try to exec "UPDATE" or "INSERT" statement
i've the follow error:
unable to open database file
I've set all data base fle permission, but it don't work.
Thank a lot.
On 12/20/06, Brodie Thiesfield <[EMAIL PROTECTED]> wrote:
+static HANDLE loadLibraryUtf8(const char *z){
+ WCHAR zWide[MAX_PATH];
+ DWORD dwLen = MultiByteToWideChar(CP_UTF8,0,z,-1,zWide,MAX_PATH);
+ if (dwLen == 0 || dwLen > MAX_PATH) return NULL;
+ return LoadLibraryW(zWide);
+}
I can't t
Hi,
Look at the new "loadable extension" feature:
http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions
It also describe an example that could be really easy to convert to
your sqrt problem.
--
Julien
-
To unsubscribe
chetana bhargav
wrote:
I have two seperate triggers like,
CREATE TRIGGER cnt1
AFTER INSERT
ON tbl1
WHEN (new.Id =1 and new.priority > 2 )
BEGIN
update cnt set Critical = (SELECT Critical from msgs_cnt where
Id=1) + 1 where Id=1;
end;
CREATE TRIGGER cnt2
AFTER INSERT
ON tbl1
WHEN
Hi ,
I have two seperate triggers like,
CREATE TRIGGER cnt1
AFTER INSERT
ON tbl1
WHEN (new.Id =1 and new.priority > 2 )
BEGIN
update cnt set Critical = (SELECT Critical from msgs_cnt where Id=1) + 1
where Id=1;
end;
CREATE TRIGGER cnt2
AFTER INSERT
ON tbl1
WHEN (new.Id =1 and new
Thanks Karthick. My code too works fine... (I made a small typo mistake in
query, which executed silently)
But I guess your method is the right one.
Regards,
Lloyd
On Wed, 2006-12-20 at 16:54 +0530, Karthick V - TLS , Chennai wrote:
> Let the time zone given by user
> +0530
>
> Therefore i
Let the time zone given by user
+0530
Therefore its 330 minutes / 13200 seconds
select datetime( StartTime,'unixepoch','+13200.0 seconds') from mytable
--- gives you the local time
Select datetime( StartTime,'unixepoch')gives u universal time
Where StartTime is an integer(unixtimestamp sto
34 matches
Mail list logo