On Wed, Aug 25, 2004 at 09:46:38PM -0700, Darren Duncan wrote:
>
> While I see this issue now closed, following Richard's explanation of
> how things actually are working now, I'm curious as to where in the
> SQL:2003 standard it mentions positional host parameters and '?';
> please give a
At 11:29 PM -0400 8/25/04, Matt Wilson wrote:
Not only backwards compatibility, but standards compliance as well.
While I see this issue now closed, following Richard's explanation of
how things actually are working now, I'm curious as to where in the
SQL:2003 standard it mentions positional
Hello,
I have recently come to a very intersting problem on
SQLITE. We have SQLITE V2.8.5 on the embedded system.
I have two databases with the same schema. The
databases have 5 tables which have references to each
other. For eg. an id referred in one table is also
used in another table and so
On Wed, Aug 25, 2004 at 06:22:26PM -0700, Darren Duncan wrote:
>
> For "backwards compatability", any plain '?' could still be allowed,
> and be mixed with both other usages, and each '?' occurance would
> implicitly be the same as ?1, ?2, etc.
Not only backwards compatibility, but standards
At 9:34 PM -0400 8/25/04, D. Richard Hipp wrote:
Parameters can be in any of three forms:
*
*
*
Each parameter is assigned a number. Numbers are sequential from left
to right and begin with 1. The parameter number is used to bind values
to the parameter. All parameters get a
On Sunday 08 August 2004 8:32 pm, Scott Leighton wrote:
>
>Solved! Just to close the loop on this for the benefit of any other
> DBD::SQLite users who may be trying to upgrade from v 0.31 to v 1.x.x.
> Watch out for cases where your former working code left unfinished SELECT
> statements since
At 6:31 PM -0600 8/25/04, Dennis Cote wrote:
The application should not be setting the mapping between the parameter
names and their index numbers. This should be done automatically by SQLite
as it parses the SQL statement. As each named parameter is encountered
SQLite should scan the parameter
I have some further suggestions to workout regarding host parameters
/ bind variables, sort of bringing things together as it were, so
they can be addressed during the current SQLite 3 beta phase.
Note that I don't have any current SQLite 3 code in front of me, so
the following is more a
At 2:13 PM -0600 8/25/04, Dennis Cote wrote:
I agree with Michael and also Matt Wilson's previous posts.
This is a good idea, but it should stick to the SQL standard way of naming
vaiables; a colon, ":", followed by an identifier. This scheme is used by
most other SQL engines for this purpose. It
Michael Roth wrote:
> We already have ?, ?nnn and :nnn: IIRC. Adding $xyz, %xyz, @xyz and
> possible other ones in parallel isn't a good thing, I think.
>
> Maybe :xyz: is good enought and binding language neutral. Maybe @xyz.
>
> How this is handled in other engines? Maybe there is a
>
Dear Christian,
Thanks again for your help.
Before I got your message, I did try working with shell.c but was not able
to get the code to work(I forget what errors I was getting but I believe the
compiler did not like sqlite3_bind_text)
BUT...
I was able to create a large table on the fly (i
On Wed, Aug 25, 2004 at 12:27:28AM -0700, David M. Cook wrote:
>
> Yeah, it's read-only, though, (no __setitem__), you have to "cast" to a dict
> if you want to use the rows in your app.
Hmmm. Anything beyond providing the sequence protocol for the result
of a fetchone() is an extension
Thanks Christian for your response.
>>Is there anything comparable to "Copy" that will allow me to import text
>>files using an sql statement from my program?
>>
>>Putting it another way, using sqlite3.exe and the command ".import
>>import.txt sample" works just fine.
>Whats wrong with using
[EMAIL PROTECTED] wrote:
>
> Hi,
> I'm new to SQLite and maybe was this already said, but is there a way to use
> SQLite inside a Java program?
> I've found Javasqlite (www.ch-werner.de/javasqlite) which is a JDBC Driver
> for SQLite but it seems to work with versions SQLite 2.8.13 and this one
nfr, dando pulos de alegria, escreveu :
There is a nice OLE provider project from xml file at
http://www.viksoe.dk/code/xmloledb.htm
Maybe you can use that as a starting point.
Regards
Noël
Unfortunally it is only binary freeware (a DLL), no source code.
But thanks, anyway.
~Nuno Lucas
Hi,
I'm new to SQLite and maybe was this already said, but is there a way to use
SQLite inside a Java program?
I've found Javasqlite (www.ch-werner.de/javasqlite) which is a JDBC Driver
for SQLite but it seems to work with versions SQLite 2.8.13 and this one is
not available anymore on the SQLite
On Wed, Aug 25, 2004 at 12:10:39AM -0400, Matt Wilson wrote:
> On Tue, Aug 24, 2004 at 08:43:47PM -0700, David M. Cook wrote:
> >
> > * DBAPI compliance is important to me. sqlite is only one of the DBs I'd
> > like to support in my apps.
>
> Do you know what's currently lacking in
Nuno Lucas wrote:
Hi,
I'm really asking this in name of a friend of mine, which is
programming in VisualObjects and wanted to use his VoAdo classes with
SQLite.
I really don't understand much of the subject, but from what I
understood he needs an OLE/DB provider so he can use SQLite with this
Hi,
I'm really asking this in name of a friend of mine, which is programming
in VisualObjects and wanted to use his VoAdo classes with SQLite.
I really don't understand much of the subject, but from what I
understood he needs an OLE/DB provider so he can use SQLite with this
classes (a DLL
19 matches
Mail list logo