On Wed, 10 Oct 2007 22:10:38 -0500, you wrote:
>On Thu, 11 Oct 2007 02:40:22 +, drh wrote
>> The BEGIN, ROLLBACK, and/or COMMIT only happen on the outermost
>> "transaction". Of course, it is kind of silly to nest
>> as shown above. But this is useful, for example, when each
>> "db transact
I know that the limits page says that the limit is 10 by default, I
would just like to know if the limit is per connection handle or global
for the module?
Thanks.
Minor bug:
Please add the prototype and defines for the following to sqlite3ext.h
void (*result_error_toobig)(sqlite3_context*);
#define sqlite3_result_error_toobigsqlite3_api->result_error_toobig
Without these, externally loadded libs that would like to use error_toobig will
not load i
The attached patch seems to do it. The thinking-out-loud patch in my
earlier email wasn't right (I'd kept an interim edit from the
PRAGMA-based approach).
I can't think of a reason to have EXCLUSIVE as the default.
-scott
On 10/10/07, Scott Hess <[EMAIL PROTECTED]> wrote:
> On 10/10/07, [EMAIL
Greetings.
So, I know that I can do a single select and get a list of the different
items found on a column, but what I would like to do is to get this same
list on another select statement. Let me explain;
I have this select statement,
"select ProjID,
cust,
proj,
PClass,
I'm thinking about this.. to get a 'exact' copy of a sqlite database we
should implement a new public API:
sqlite3 * sqlite3_clonedb(sqlite3 * db, const char * szOutput);
sqlite3 * sqlite3_clonedb16(sqlite3 * db, const void * szOutput); // utf-16
version
this api can do the real file copy without
We use a custom aggregate function called DisplayList to do exactly what
you're talking about. C# code follows.
SELECT
U.UserName,
DisplayList(R.RoleName)
FROM
Users U
INNER JOIN
Xref_Users_Roles X
ON
U.UserID = X.UserID
INNER JOIN
Roles R
ON
X.RoleID
Version 0.76 of the SQLiteODBC Driver is ready for
download from http://www.ch-werner.de/sqliteodbc
The Win32 installer is build with SQLite 3.5.1 and 2.8.17.
Enjoy,
Christian
-
To unsubscribe, send email to [EMAIL PROTEC
the question of how to do a backup comes up a lot so this would be very
nice. If it was added with a compile-time OMIT flag then there shouldn't be
a big concern on bloating the library.
Sam
---
We're Hiring! Seeking a passionate developer to join our t
Hello to all!
I really need some help here. I know that using the sqlie3_create_function
we can call c function through sqlite.
But here is my problem:
sqlite3_create_function(mpDB,"DEPLOY",3,SQLITE_UTF8,NULL,&deploy_func,NULL,NULL);
void MyClass::deploy_func(sqlite3_context* context,int
arg
Or more to the point, I changed the URL on the Users page of the wiki, to
reflect the new home: http://www.lazarusid.com/modauthsqlite3.html
Clay Dowling
--
Lazarus Registration
http://www.lazarusid.com/registration.shtml
-
nadiap <[EMAIL PROTECTED]> wrote:
Hello to all!
I really need some help here. I know that using the
sqlie3_create_function we can call c function through sqlite.
But here is my problem:
sqlite3_create_function(mpDB,"DEPLOY",3,SQLITE_UTF8,NULL,&deploy_func,NULL,NULL);
void MyClass::deploy_func
Thanks. Yes, that is nice, but I am using D. :-) This is a good idea,
though. Thanks for sharing. I could easily implement this.
Ok, so this is not possible using SQLite select, correct?
- Original Message -
From: "Samuel R. Neff" <[EMAIL PROTECTED]>
To:
Sent: Thursday, Octobe
The built-in limit in code for attach is 30 (2 reserved for MAIN and TEMP,
plus 30 bits more, to fit within a 32-bit integer type), which can be
expanded by setting the macro SQLITE_MAX_ATTACH to the higher number when
compiling sqlite3.c . The limit is per connection handle.
There are, of course
I built 3.5.1, from the 3.5.1 tarball, on Fedora 5 over glibc-4.11 with
gcc-4.1.1, 32 bits and 64 bits.
On 32 bits I run all.test and I get 0 errors.
However, on the 64 bit build there is the following error:
io-4.2.2...
Expected: [0x]
Got: [0x]
This is using the d
I'm working with implementing my own VFS. If the developer(s) could
answer a couple of questions, it would be helpful.
In section 2.1.4 of the SQLite 3.4.2 to 3.5.0 document, reference is
made to "a database file will be doing page-aligned sector reads and
writes in random order" regarding th
Mark Spiegel <[EMAIL PROTECTED]> wrote:
>
> I take this to mean that paged-aligned sector I/O will always be used
> for all the DB types. Will there ever be an I/O to a DB file that will
> not follow these rules.
When first opening a database, 100 bytes are ready from the very
beginning of the
Thank you Dr. Hipp. The DB info makes perfect sense. Since I have to
accommodate the initial read in the DB file you don't need to check on
the change counter. I'll handle it already.
With regard to the journal files, I understand that they will for the
most part be written sequentially (wi
On Thu, 11 Oct 2007 13:33:35 +0200, Kees Nuyt wrote
> On Wed, 10 Oct 2007 22:10:38 -0500, you wrote:
>> You might want to be a little bit more clear about the fact that
>> [transaction] nests even though BEGIN does not.
>
> The TCL transaction{} can be nested, the SQL BEGIN can't.
It looks like I
19 matches
Mail list logo