Has anyone compiled sqlite 3.3.8 under OpenWatcom 1.x ? I'm not
able to do it, because of this:
void (*interrupt)(sqlite3*);
in sqlite3ext.h ... seems to be, that interrupt is a reserved word
in OpenWatcom, but this is just a guess ...
Any idea ?
Marten
I've read the book from Michael Owens about SQLite and also
read the parts about threads and sqlite3.
Actually it seems to be possible to use the same connection
handler from different threads - but within a transaction
only one thread is allowed to access the library with that
particular
There are good reasons to have "NULL" values - though they can make the live
a bit harder. Use them - even Microsoft has found out, that they made a
big mistake
in .NET 1.x and corrected them in 2.0 by introducing nullable types.
Darren Duncan schrieb:
You can save your self a lot of grief by
[EMAIL PROTECTED] schrieb:
the 2.4 kernel. If you are using win32 or mac os-x or linux
with a 2.6 kernel, this restriction does not apply.
Thats interesting ! Thanks !
Marten
-
To unsubscribe, send email to
Igor Tandetnik schrieb:
Da Martian <[EMAIL PROTECTED]> wrote:
So if I look at a name with umlaughts in the database via sqlite3.exe
I get:
Städt. Klinikum Neunkirchen gGmbH
--
|
an "a" with two dots on top
"A with umlaut" is represented as two bytes in UTF-8. sqlite3.exe just
dumps
Ulrich Schöbel schrieb:
SQLite includes a Tcl API. Tcl does all these conversions with ease.
See the encoding convertto/convertfrom commands and fconfigure
But Tcl is not part of SQLite (and this is good) - this is just an
add-on. The idea with the
additional functions are pretty good !
I have written some interface code to the sqlite3 API using the
OpenWatcom 1.5 compiler and I wrapped several functions like
sqlite3_column_text, sqlite3_column_int and all went fine.
Then I tried to wrap sqlite3_column_double(..) and when I do something
like
...
sqlite3_column_double( stmt,
John Stanton schrieb:
Maybe your statement does not reference a valid row.
No, actually I have in my test program several lines to retrieve
the values in different ways:
sql = "select aColumn from TESTME2;";
sqlite3_open("c:\\sunittest.db", );
sqlite3_prepare(db, sql, strlen(sql), ,
[EMAIL PROTECTED] schrieb:
Make sure sqlite3_column_double() really is declared to
return a double and that dVal really is declared to be a
double. If both of those things check out, then I would
assert that this is a compiler bug.
Yes, I think also that this is a very low level error - I've
Marten Feldtmann schrieb:
[EMAIL PROTECTED] schrieb:
Make sure sqlite3_column_double() really is declared to
return a double and that dVal really is declared to be a
double. If both of those things check out, then I would
assert that this is a compiler bug.
Yes, I think also
After most of the problems could be solved (thanks to this list). Here
is the result. A wrapper library for this product:
http://www.schrievkrom.de/uk/tips/small-projects/vasqlite/index.htm
Marten
-
To unsubscribe,
Michele Santucci schrieb:
Hello,
I'm trying to use sqlite3 into a CVI (National Itruments ANSI C dev tool). I
took the last sqlite3 dll and source.
I create the .lib file linked it to the binary and included the sqlite3.h
file... but as long as I start the application I got an error about a
LuYanJun schrieb:
> Hi guy:
> what does the follow meaning?
> sqlite> BEGIN READ_ONLY;
> SQL error: near "READ_ONLY": syntax error
READ_ONLY is not a valid option for this command.
BEGIN [DEFERRED | EXCLUSIVE | IMMEDIATE]
Marten
Is it possible to get the information, if a SQLite library one
uses is threadsafe compiled or not ?
Marten
-
To unsubscribe, send email to [EMAIL PROTECTED]
And the dll is ok ???
Marten
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
How can I get all the names of a table without doing a query against the
table ?
I need all the names of columns within tables/views, the column index
within the
raw table.
With that information I may use sqlite3_column_meta_data to get
additional information
about the coumns ...
Marten
Igor Tandetnik schrieb:
Marten Feldtmann <itlists-w+T/[EMAIL PROTECTED]>
wrote:
How can I get all the names of a table without doing a query against
the table ?
PRAGMA table_info(table-name);
Thats it ! Thanks !
What's sqlite3_column_meta_data? It doesn't seem to be men
Dennis Cote schrieb:
I think it should be possible to create a subset of the standard
information schema in sqlite using virtual tables.
That would be very nice and consistent !
Marten
-
To unsubscribe, send
select count(*) from tablename ... if sqlite supports count(*) ...
Marten
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
I'm not sure how to use a function call in a prepared statement:
insert into persons(name, birthday) values( ?,?)
how to I bind the value of date('1964-04-01') to one of the
parameters ? I want to store not the string, but the value of
the internal date-function-call into that column ?
Somehow
Igor Tandetnik wrote:
> It's not clear why you would want to, considering that
> date('1964-04-01') = '1964-04-01'. date() function produces a string in
> -MM-DD format (the same format you are starting with).
Due to a totally misunderstanding of these functions ... forget
my question
Indeed it may be questionable to use SQLite for stuff like this, but its a
very fast relational db library - and therefore it can be used as any other
relational database to store objects.
What is needed is very simple: you need a object-oriented relation database
wrapper - either as a
Just some additional comments:
The "vertical" approach (described by Teg) leads also to a very
untypical relational
database and if a pure sql administrator would look at it .
Ok, but it works, but when using a vertical approach you have consider some
points:
* you have to throw away the
Teg schrieb:
Hello Marten,
I wasn't suggesting one table for all object, I was suggesting a table
for objects and a table for object properties. Using the object ID as a way
to identify which properties belong to what objects in the properties
table. The "Vertical" part was simply for the
Teg schrieb:
Hello Marten,
Monday, January 16, 2006, 2:14:59 PM, you wrote:
To me duplicate entries or near duplicate entries in a table are a
no-no. Sounds to me like you're talking about inserting the object
multiple times in the same table each instance describing one
"property" of the
michael munson schrieb:
Type refers to an int value that represents an in-server datatype. The
main difference is that I realized that I wouldn't necessarily need a
row for EVERY property, only if a property is different than the value
stored on the parent object. If its the same, it can
Jim Crafton schrieb:
In my table(s) I need to model a class hierarchy, as well as a
class/var/function belonging to a namespace, and/or a function/var
belonging to a class. In other words a parent/child relationship. If I
simply add a new column to my primary symbols table, call it
"Parent",
I wanted to use the prebuild dll of sqlite - and I was looking
for the information, what calling convention was used within
the sqlite.dll.
It seems to me, that "cdecl" is used and NOT "stdcall" - right ?
Marten
Marcus Grimm schrieb:
> this will be a lot of work and I'm wondering why
> you do this ?
> Despite beeing a german with a rather poor english knowledge,
> I guess a programmer should still be able to understand
> the english sqlite documentation, right ? :-)
>
There are still lots of
more.
Has anything changed (calling conventions ?) between these (official)
versions (dll) under Windows? I have not found anything in the version
documentation.
I was not able to find/download 3.7.12/13/14/15 versions to find out,
where the problems started ?
Thanks,
Marten Feldtmann
Are the old prebuild binary versions (dll windows) available from
somewhere ?
Marten
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
31 matches
Mail list logo