you prefer to build non-port based software.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
) 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 PROTECTED]
(
s.
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.Sreedhar.
e 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, send
n 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
-
To unsu
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]
(Spam-protected
index 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
ormation 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
, 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
[EMAIL PROTE
?
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]
-
ering 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]
-
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]
-
ndline/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]
-
r 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
-
To unsub
e" 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 the
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
_
> Scanned and protected by Email scanner
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> ---------
>
>
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protec
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
bility 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
-
To unsubsc
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.
regards
onvenience any users?
--
D. Richard Hipp <[EMAIL PROTECTED]>
-
To unsubscribe, send email to [EMAIL PROTECTED]
-----
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email
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 mailing l
he 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 number of returned rows.
e 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
___
sql
aven'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
> ___
> sqlite-users mailing list
d out 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 qua
y that I might 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 "mhoenicka
ible, you may have 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&qu
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
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
>
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 column
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
t; will 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
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 PROTECTED]
For
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
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
E_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-protected email: re
king 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 <[EMAIL PROTECTE
sely 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 PROTECTED]
(Spam-protect
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:\cygwin)
> >
40 matches
Mail list logo
