I've been comparing three .Net providers along with the JET OLEDB
provider. I have the same data in an MDB and also an Sqlite db.
The providers I've used so far, all on Windows, are:
- The Mono Sqlite client http://www.go-mono.com
- The AGS Sqlite provider http://www.ag-software.com/sqlite.aspx
-
> ok. As I am sure you realize it would be very useful to be able to
> create case-insensitive indexes with:
>
> create index idx_my_index on my_table(lower(my_column));
How can you be sure which index sqlite will use when there are more indices on a
field?
>
> culley
>
> On Friday, Januar
> Not sure if this has been posted before, but it took me a while to work
> out so might help someone.
Thanks for posting this. Had the same issue with my own .net wrapper and at
least now I know why!
--
Richard Heyes
-
To uns
Hi,
at the moment I try to write a few wrappers for the sqlite api.
Here we are:
##
#include
#include
using namespace std;
namespace F {
class FSqLite : public FApplication {
public:
FSqLite() {}
~FSqLite() {}
static int callback(void *No
Hi all,
wouldn't sqlite fit into the openoffice package as access fits into
Microsoft Office?
/ Jonas
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
What you propose will work, but you haven't given enough
info for anyone to tell you whether it's the best solution.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Hi all,
does someone could tell me how to
implement the record (rows) navigation
like "MoveNext", "MovePrevious",
"EOF" etc... using the AGS_SQLite
wrapper and VB6?
Thank you a lot in advance,
Giuliano Isacchi
-
To unsubscrib
My Implementation:
##
namespace F {
static int FSqLite :: callback(void *NotUsed, int argc, char
**argv, char **azColName)
{
return 0; // only for testing
}
> [ ... ]
use
int FSqLite :: callback(void *NotUsed, int argc, char **argv, char
**azCo
Try
create trigger itemDelTrg after delete on Items for each row begin
delete from Stats where Stats.ID = old.ID;
end;
Also consider
create trigger statInsTrg before insert on Stats for each row
when (select count(ID) from Items where ID = new.ID) = 0 begin
select raise(ro
Guillaume Fougnies wrote:
2) Disk image corruption (with indexes):
After a time of running, i get this error in return:
"database disk image is malformed".
I have tracked this problem down to what appears to be a
bug in Linux threads. For details see
http://www.sqlite.org/cvstrac/tktview?tn=56
Hi,
The returned result is a variant array. You move through a array as you
normally do, by increasing a index counter. You can write a class
around any array to emulate an ADO recordset if you want.
Regards
Greg
-Original Message-
From: ISA Programmi [mailto:[EMAIL PROTECTED]
Sent: Su
G'day all,
In my quest to get regex support running I have modified parse.y to
accept ~ as regex or bitnot depending on context.
I have put #ifdefs around all the regex code and setup an autoconf test
for it so it can be compiled out, or is not compiled in if the OS does
not support regex.
I r
12 matches
Mail list logo