On Oct 31, 2005, at 7:54 PM, Edward Wilson wrote:
I simply count the number of elements in my record set
thereby avoiding a double query to the database.
Yes, exactly, I take for granted that the resultset is accumulated at
the database level and not
at the application level.
sorry, I don
>I simply count the number of elements in my record set
>thereby avoiding a double query to the database.
Yes, exactly, I take for granted that the resultset is accumulated at the
database level and not
at the application level.
-
ed
--- Puneet Kishor <[EMAIL PROTECTED]> wrote:
>
> On Oct 2
Apple added special hacks to their release of SQLite 3.1.3 that
allow it to work on remote filesystems with broken file locking.
For various reasons, those hacks have not been incorporated into
the SQLite core, yet.
A bit more detail; Apple shipped with 3.1.3 with locking support
for various
We use a TEXT field for dates and time and make it strictly ISO8601 and
hence portable between storage methods.
Jay Sprenkle wrote:
I would like to know how I should handle dates and timestamps
via the C API. I know that if I write an SQL insert statement, I have
to use one of the forms reserve
Is it really necessary for copy's input file to be fopen()ed with mode
"rb"? This causes CRLF files opened on MS-Windows to have \r's appended
to the values in the last column. The last column might otherwise be
numeric.
Actually, I'd prefer that DB_COPY accept a Tcl channel rather than a
filena
On 30 Oct 2005 at 03:14 NZST, Florian Weimer wrote:
> Is it true that there isn't yet a binding to SQLite versoin 3 from
> Objective Caml?
>
> (I only found one for version 2.)
There seem to be a couple of different ocaml-sqlite3 bindings around:
http://www.imada.sdu.dk/~bardur/personal/45-progr
From my understanding of Length(), it still reads the
entire Blob into memory before getting its size ( please
correct me if I am wrong ).
Many have suggested, that the best approach is to have
your application restrict the size of the blobs that it
writes to a size that is good for you. You can
> I would like to know how I should handle dates and timestamps
> via the C API. I know that if I write an SQL insert statement, I have
> to use one of the forms reserved for dates and timestamps and
> the like, but how do I do this via the sqlite3_bind_* procedures?
I treat dates as a text field
On 10/31/05, Joe Wilson <[EMAIL PROTECTED]> wrote:
> [...] But if
> for some reason you absolutely must need to know the number of bytes
> that a text or blob value takes from within the Sqlite SQL language,
> just refer to the documentation of typeof(), CAST, CASE and quote()
> and you can come up
Hello,
I would like to know how I should handle dates and timestamps
via the C API. I know that if I write an SQL insert statement, I have
to use one of the forms reserved for dates and timestamps and
the like, but how do I do this via the sqlite3_bind_* procedures?
Regards,
Arjen
Oops - the second paragraph should have read:
"with appropriate manipulations of sqlite3_value_type(),
sqlite3_value_bytes() and sqlite3_value_text()."
--- Joe Wilson <[EMAIL PROTECTED]> wrote:
> Length() is perfectly consistant with the value's type. As you've
> demonstrated, Sqlite does not r
Robert Simpson wrote:
>
> That's exactly what I ended up doing in the ADO.NET 2.0 wrapper. In order
> to implement full Compact Framework support and callbacks, I ended up
> writing stdcall entrypoints and callback wrappers for just about the entire
> SQLite API.
>
My Fortran interface does som
I'm certainly not diplomatic material. But, what you have said is
exactly what I meant. I get more than a little weary of people who take
"free" code and whine about it. My belief is if you don't like it, fix
it yourself or shut up after your initial "notification" of the issue.
As to calling Bi
I had this same problem some time ago. We were trying to make a virtual list
box that could handle ANY number of items. The scroll bar is the wrinkle. You
can't set it or size it without knowing the size of the list.
My conclusion was this:
A list of more than 100 or so items on screen is really
Length() is perfectly consistant with the value's type. As you've
demonstrated, Sqlite does not respect the column types in tables
as declared in the CREATE statement.
Length(text_value) always returns the number of characters and
length(blob_value) always returns the number of bytes. The type
> Look I'm certain you mean well, but the rest of us are pretty busy
using
> one of the best small footprint databases on the planet. That means
we
> are way too busy to nit-pic a good product to pieces, just because it
> won't compile clean using Mickeysoft's latest and greatest.
It's not a "nit
That's exactly what I ended up doing in the ADO.NET 2.0 wrapper. In order
to implement full Compact Framework support and callbacks, I ended up
writing stdcall entrypoints and callback wrappers for just about the entire
SQLite API.
Robert
- Original Message -
From: "Arjen Markus" <
What is important is the implication of the compile warnings. I agree
that they should not be ignored, but they should be understood. For
example we always take pains to remove all compiler warnings, even the
innocuous and gratuitous ones, so that "noise" does not hide a
significant warning.
Hi!
Yes. I wrote the binding for version2, but not for version3 (yet).
Mikhail
Florian Weimer wrote:
Is it true that there isn't yet a binding to SQLite versoin 3 from
Objective Caml?
(I only found one for version 2.)
On Mon, 31 Oct 2005, Adi Spivak wrote:
>
>hello.
>i have sqlite 2.8.17 installed on my system (compiled manually not a distro
>package)
>i wish to remove it (uninstall) it complitlly from my system and install the
>3.2.7
>i need to make sure it is removed so i can make sure that the program i need
hello.
i have sqlite 2.8.17 installed on my system (compiled manually not a distro
package)
i wish to remove it (uninstall) it complitlly from my system and install the
3.2.7
i need to make sure it is removed so i can make sure that the program i need
to install that will use sqlite will be
Fred,
They are not nit-picking and they "are" actually contributing to the
robustness of the application by doing this research. Your
anti-Microsoft bigotry does no service to this list at all and is
neither a "contribution" or an offer of help.
I for one would be keen to see these warnings addr
I have been silently reading the conversation, but I have
to reply on this latest message.
- Original Message -
From: "Fred Williams" <[EMAIL PROTECTED]>
Look I'm certain you mean well, but the rest of us are pretty busy using
one of the best small footprint databases on the planet. Th
On 10/31/05, Fred Williams <[EMAIL PROTECTED]> wrote:
> Look I'm certain you mean well, but the rest of us are pretty busy using
> one of the best small footprint databases on the planet. That means we
> are way too busy to nit-pic a good product to pieces, just because it
> won't compile clean us
On 10/28/05, Joe Wilson <[EMAIL PROTECTED]> wrote:
> --- Nuno Lucas <[EMAIL PROTECTED]> wrote:
> > On 10/25/05, Joe Wilson <[EMAIL PROTECTED]> wrote:
> > > The built-in Sqlite length() function works just fine on blobs:
> > >
> > > sqlite> select length(X'00');
> > > 5
> > >
> > > Why d
25 matches
Mail list logo
