stall what you prefer to build non-port based software.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
ve to rewrite your code to avoid implicit
transactions around each INSERT statement, see
http://www.sqlite.org/faq.html#q19
regards,
Markus
--
Markus Hoenicka
markus.hoeni...@cats.de
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
end up having several INTEGER
columns with the pk column set to 1. Does that mean that I cannot
unambiguously identify that one autoincrementing column?
regards,
Markus
--
Markus Hoenicka
markus.hoeni...@cats.de
(Spam-protected email: replace the quadrupeds with "
nvert all columns defined as
INTEGER with a non-NULL entry in the pk column (is this correct? the
docs are a bit terse about this) back to INTEGER PRIMARY KEY.
Thanks
Markus
--
Markus Hoenicka
markus.hoeni...@cats.de
(Spam-protected email: replace the quadrupeds with "mh
t at runtime that a
column has been defined as INTEGER PRIMARY KEY instead of as INTEGER,
all is well and I'll be able to fix the sqlite driver accordingly.
regards,
Markus
--
Markus Hoenicka
markus.hoeni...@cats.de
(Spam-protected email: replace the quadrupeds with "mhoenicka&quo
oked familiar to
> anyone as I haven't been able to find anything about it on my own. Please
> let me know if there is any further information that I can provide that
> might help diagnose the issue.
>
> Thanks in advance,
> Adrian
> _______
g array from the callbacks himself these days, or did I miss some
simple and obvious way to switch?
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
have to switch to the low-level interface
using prepared statements in order to be able to use
sqlite3_column_name() et al.
I'm just wondering whether it makes more sense to make
sqlite3_get_table() consistent and have it return the number of colums
and their names irrespective of the
s the column information, or whether simply no
one saw this as a limitation yet.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
___
sqlite-users mail
h...If that
is the kind of information you want to compute, it's probably not that
goofy after all.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
-
dex in command than i get
the error
SQL error: near "index": syntax error
http://sqlite.org/lang_keywords.html
"index" is a reserved word. Just use a different column name which is
not in the above list.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected ema
mple things
in a simple fashion. However, you're still required to handle database
engine specific stuff in your code to use more advanced SQL features.
ODBC seems to encapsulate all and everything, at the price of being
huge.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
action layer's API instead of the
database-specific API.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
-
2 were self-titled and thus carry the same title.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
-
To unsubscribe,
olumns.
Artist Album and tracks.
Can i fix a range of ids for each column
like 1-100 for Artist 101-200 for Album and 201-300 for tracks
So that I can have a unique number(id) for each record.
Will there be a problem while deleting and inserting the records?
Thanks and best regards,
A.Sreedh
cal policy) which points to /opt/OpenSource/bin/make. You can
then run GNU make by using "gmake" instead of "make" in the build
process from any shell you prefer.
regards,
Markus
--
Markus Hoenicka
[EMAIL PR
y inconvenience any users?
--
D. Richard Hipp <[EMAIL PROTECTED]>
-
To unsubscribe, send email to [EMAIL PROTECTED]
-----
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected
a from other shell
> eveything works fine.
> But when it's the cas from my C program it raises the error message database
> is locked.
> How can i avoid this issue?
> thanks a lot
>
Do your threads share the same connection? If yes, using separate connections
might help.
re
eate an accessibility issue, but it seems to work fairly well.
just my 2c,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
sebcity <[EMAIL PROTECTED]> was heard to say:
>
> Time constraints
>
Good point. I've got time constraints too. Could everyone else please start to
solve all my problems right now too please?
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace
___
> Scanned and protected by Email scanner
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -----
>
>
--
Markus Hoenicka
[EMAIL PROTECTED]
(S
ved."
If no rows match the where clause, no rows will be deleted. This is not an error
but the expected behaviour.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenick
t;make" created. This usually
returns your build directory to the state right after unpacking the sources
from the tarball. "make uninstall" should remove installed files though.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace
lite3 to your gcc command line in order to build an
app that uses SQLite.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
---
commandline/sqlitebrowser (for select-statements necessary)?
>
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
taining
> german umlaut characters?
>
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
try it for me, just wondering if anyone knows approx.
>
>
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
?
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
.net), including SQLite, SQLite3, MySQL,
PostgreSQL, Firebird, Ingres, Sybase, MS SQL, mSQL, as well as work in progress
for Ingres and Oracle.
I strongly support Vivien's suggestion to extend existing abstraction layers
instead of developing yet another one.
regards,
Markus
--
Markus Hoenicka
[E
put a stop to the automated signup pretty quickly.
>
...and it will exclude the visually impaired just as quickly.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
Markus Hoenicka <[EMAIL PROTECTED]> was heard to say:
Sorry for the typo, fixed below
my $command = "CREATE TABLE my_table (";
foreach my $counter (1..999) {
$command .= "INT column" . $counter . ", ";
}
$command .= "INT column1000)";
print $c
anks
>
Something along these lines (untested!!) should work:
my $command = "CREATE TABLE my_table (";
foreach my $counter (1..999) {
$columns .= "INT column" . $counter . ", ";
}
$command .= "INT column1000)";
print $command;
You may need to name your c
ve looked
> around but not much luck. Thanks for looking
What about writing a small Perl|Ruby|Python script to generate a SQL command
that you feed to sqlite?
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
ks ok. You should be careful though as the result is something like a
Cygwin/Win32 hybrid. All paths are handled Windows-style which makes things a
bit odd on Cygwin.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
Markus Hoenicka writes:
> amead writes:
> > It's a bit of a long-shot, but have you tried the 'cygdrive' path syntax?
> >
> > $ sqite /cygdrive/c/cygwn/usr/local/share/refdb/db/refdb
> >
> > (assuming you installed Cygwin on C:\cygwi
harm. However, if you closely inspect os.c, you'll notice that the
platform-specific code bypasses most of the functionality that Cygwin
offers. All file accesses use native Windows calls, and I believe this
is why paths with a leading slash fail.
regards,
Markus
--
Markus Hoenicka
[EMAIL
issue that we've been talking about a while ago. I'm
using now an all-Unix-style SQLite build on Cygwin, and attempting to access a
database results in:
SQL error: database is locked
Has anyone ever got close to fixing this locking issue on Cygwin?
regards,
Markus
Markus Hoenicka <[EMAI
SABLE_LFS -DHAVE_USLEEP=1 -I.
-I${TOP}/src
I still get the same complaint about large file support.
Does anyone know what's going on? Has anyone else attempted to build SQLite
"natively" as a Unix app on Cygwin?
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-prot
ews
up the Unix-style Cygwin port. I'll try to track this down.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
start the app
in / and pass the relative path, the app works ok.
I'm currently away from my Linux/BSD boxes, so I can't tell whether this problem
is specific to Cygwin. Can anyone help?
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
ee to drop me a line to
sort this out.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
-
To unsubscribe, e-mail: [EMAIL
41 matches
Mail list logo