Juan,
> Can you please provide instructions for this or publish it? Compiling
> with bcc55 has eluded us for quite a while. Please include exact steps
> and versions of each program used.
I've published SQLite327makefiles.zip file on my site, section "Utilities"
as resulting example of quite sim
Actually, on SQLite, 'INTEGER PRIMARY KEY' does designate a special
type of autoincremented column.
The internal 64 bit rowid is used directly in that case, which is
essentially 'free' storage.
http://www.sqlite.org/faq.html#q1
http://www.sqlite.org/lang_createtable.html
http://www.sqlite.org
On Sat, Oct 22, 2005 at 12:19:04PM -0700, Mario Gutierrez wrote:
> CRETE TABLE my_table (
> id INTEGER PRIMARY KEY,
> ...
> )
>
> This would meet your criteria, but 'id' is not an autoincremented column.
Sorry, I don't get it. Why is it not? Also, why would one do that? If I
wanted an non-a
with Return Value 13.
I checked my partition space and its usage is just 2% (Platform is Linux
using SQLite 3.2.2).
Also I am using Temp tables and periodically move data into my Main Table. I
wondered if my Temp Table is full because strace on my process gave me
messages like:
access("/var/tmp/sql
Sasa Zeman wrote:
Does someone have Make files to create exe and dll for > Borland command
line compiler v 5.5?
Problem have solve days ago. If anyone need these scripts and .def file for
BCC, I will publish it on my site or author may consider to include it in
distributed archives.
Can you
Lloyd Dupont wrote:
But to my disbelief there is (apparently) no way to get the size of a blob
(other than loading it :-()
I'd like to be corrected if I am wrong, but I
don't think there is anyway to do this in
SQLite, besides simply storing the size of the
blob with the blob when you write it
I assume the wrapper has wrapped this particular function. I'm
currently writing my own wrapper and it has wrapped it as well.
This is my definition (in case your wrapper doesn't have it):
///
/// Returns the lengh of data in a single column of the current result row
of a query
///
/// Statem
Isn't this what you are looking for?
http://www.sqlite.org/capi3ref.html#sqlite3_column_bytes
" If the result is a BLOB then the sqlite3_column_bytes() routine returns
the number of bytes in that BLOB. "
Or do you really need it inside an SQL statement?
that's right!
I'm not using SQLite C A
Well, I guess I was not clear in my explanations.
I'm already doing my own locking, that's the problem!
But I'm not sure how to improve it.
My problem here is the following: I am doing a search through all record,
could be long. Do some string matching, cutting, etc with all text of all
records
Isn't this what you are looking for?
http://www.sqlite.org/capi3ref.html#sqlite3_column_bytes
" If the result is a BLOB then the sqlite3_column_bytes() routine returns
the number of bytes in that BLOB. "
Or do you really need it inside an SQL statement?
Rob
- Original Message -
Fro
I look into the build in function of SQLite and saw there is a function to know
the length of a string (in a record).
Great!
But to my disbelief there is (apparently) no way to get the size of a blob
(other than loading it :-()
And no, length() doesn't work on Blob.
I think it would be a worthy
Have you thought of performing your own thread locking using the
equivalent of a semaphore? It is a much better method than some form of
busy wait and is not only less likely to unearth deep synchronisation
problems but will result in a faster running application.
Threads A and B wait on the
12 matches
Mail list logo
