rement a row value...
>
>
> On 06.04.2011, at 17:13, John D. Marinuzzi wrote:
>
> > Hello,
> >
> >
> >
> > Perhaps this is more of a SQL question, but I am curious if SQLite has
> > some kind of implementation for incrementing an integer within
Hello,
Perhaps this is more of a SQL question, but I am curious if SQLite has some
kind of implementation for incrementing an integer within a row without
actually reading the value and then updating the record. Is that possible?
Thanks,
John
BTW, if there is a better way to get a row count without using
sqlite3_get_table() that would also work.
_
From: john darnell
Sent: Thursday, March 31, 2011 9:27 AM
To: 'General Discussion of SQLite Database'
Subject: using sqlite3_get_tabl
I am declaring the arrays,
but not having an example to teach me, I have no idea what the correct method
is. If anyone has an example of how he or she is using sqlite3_get_table that
he or she wouldn't mind sharing, I would be appreciative.
TIA!
R,
John A.M. Darnell
Senior Programmer
Wa
create the result, instead of just using the already computed values in the
Ephemeral table.
Is it possible to fix this so that functions that have side effects or are time
consuming to compute are called only once?
John
On Feb 28, 2011, at 6:08 PM, John wrote:
>
> That doesn't
That doesn't really make any sense. I'm not calling "fun" from the tcl body,
just in the select statement. It didn't make any difference either.
Any Ideas?
John
On Feb 28, 2011, at 8:49 AM, Black, Michael (IS) wrote:
> I think your problem may be that fun()
Hi All,
In my example code here the function "fun" is called twice for each row. The
first set of calls is made in the initial evaluation of the sql statement, then
"fun" is called again as the tcl body is evaluated for each row. I wasn't
expec
estion?
>
The big question is what will you offer that is not available on the
currently available opensource or free tools?
John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I now have the script running as required on the remote server, apart
from a couple of creases I'd like you to help me iron out. What I
unwittingly held back, and which you would have picked up on straight
way, was my connect routine, to which I added "{ RaiseError => 1,
AutoCommit => 0 }" ea
Google mail seems to have chosen a convenient moment to go AWOL.
I wrote:
print qq~\$q{BUTTON} was: $q{BUTTON}~;
if ($q{BUTTON} =~ s~^Delete[^\d]+~~i){
print qq~\$q{BUTTON}=$q{BUTTON}~;
###my $rows = $dbh->do("DELETE FROM contacts WHERE rowid = $q{BUTTON}");
my $sth = $dbh->prepare(
On 28 January 2011 16:37, I wrote:
> Once I 'd deleted the second line it did work in the standalone
> script. But the duplication is not in the cgi version. Nevertheless
> now I am assured that it does work, I've just got to find what silly
> mistake I've made in the main script. I already have
At 11:33 -0600 28/01/2011, Puneet Kishor wrote:
> > Why would you do this rather than use $dbh->do ? It seems to add a
>> line of code to no purpose.
>
>Because I find using bind values easier, clearer, and safer, even for
>one-off execute statements.
Well, that makes sense.
> > And besides,
At 11:08 -0600 28/01/2011, Puneet Kishor wrote:
>Can't really say what you are doing wrong, but you code is needlessly
>complicated; all those tildes are making my eyes swim.
I also have difficulty interpreting escaped toothpicks, and I didn't
joint the sqlite list to have my Perl style polished
At 16:44 + 28/01/2011, Black, Michael (IS) wrote:
>Me thinkst you need to put singled quotes around $q{BUTTON}.
>
>my $rows = $dbh->do("DELETE FROM contacts WHERE rowid =\'$q{BUTTON}\'");
SInce the statement is in double quotes I surely wouldn't want to
escape the single quotes, but, as I sa
On 28 January 2011 16:19, Simon Slavin wrote:
> I strongly suspect that your value for $q{BUTTON} is wrong. Can you add a
> diagnostic like to display it ?
Yes, I realised immediately after posting that I had duplicated the
substitution in the stand-alone script so obviously the 'if' returned
I thought I was making a bit of progress but I've come up against a
brick wall trying to do what appears to be the most simple thing.
A button pressed in the page to delete a selected record is stripped
of its display name to become simply the rowid.
When I run the statement in the sqlite comm
At 22:41 -0800 25/01/2011, Darren Duncan wrote:
>How long have you been using Perl?
>
>Anyway, to start with I would replace the last couple lines with:
>
>my $catalog_rowset = $dbh->selectall_arrayref("PRAGMA
>table_info(contacts)") ;
>my @col_names = map { $_->[1] } @{$catalog_rowset};
Hello John Delacour...nice to see you join the SCLite list.
Folks, John may be a SCLite beginner, but he has quite a reputation on the
MacScript list. I personally am glad to see him here.
R,
John
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite
I've only been using SQLite for 5 days so I'm very much a beginner.
I just spent an hour or so working out how to get a list of column
headers from a table and come up with the script below, which will do
fine, but I wonder if there's a more elegant way to do it.
#!/usr/local/bin/perl
use str
On Thu, Dec 23, 2010 at 4:06 PM, Vander Clock Stephane
wrote:
> that very very much expensive :( how much you thing ?
>
$500 to $600 US.
John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/
> i m affraid so ... but what it's will be with 50 000 000 rows ? i don't
> have 100 gigabytes of memory :(
I would get a 256GB SSD.
John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Thank you Igor. That explanation makes sense. And it fits all the information
I had collected.
R,
John
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
> On Behalf Of Igor Tandetnik
> Sent: Monday, December 20, 2010 1
ables.txt
sqlite> select * from Names;
( It was this field)
V
1||慄湲汥|JohnDarnell, John||0|1|0
2||慄湲汥|John|A|M||Darnell, John A M||0|1|0
3||敄慬敮|PatrickDelaney, Patrick||0|1|0
4||慍潳⵮慄湲汥|ToddMason-Darnell, Todd||0|
5||Θëŵ╜äµæ╖|WilliamOÆDowd, Wi
Thank you for the reminder, Mr. Archer.
The basic_string is actually stored as part of a STL map and is fairly
long-lived; once it is created, it remains until the plugin's destructor clears
the map.
R,
John
> -Original Message-
> From: sqlite-users-boun...
nd of pointer and goes crazy
with anything else, then that could have been my problem.
I hope I have answered all of your questions. As far as I am concerned, my
problem is solved so unless you have some new insight that will greatly speed
my program or enhance efficiency, you do not have to
s:
.output c:\sqlite.txt
Select * from Names;
When I went to the root of C: I did not find the file. So I removed the path
from the filename and later found it in the SQLLite directory from which I was
running the shell.
R,
John
> -Original Message-
> From: sqlite-users-boun.
Pavel, I really appreciate you hanging with me on this subject. I can sometimes
be a bit thick and your patience in dealing with my situation is greatly
appreciated.
The data I am using is a very small set of names pulled from an InDesign
document text frame. They look like this:
John
the insert statement:
idx = -1;
idx = sqlite3_bind_parameter_index(ResultStmt, ":disp");
sqlite3_bind_text(ResultStmt, idx, CurrentName ->
second.GetDisplayName().c_str(), -1, SQLITE_STATIC);
//sqlite3_bind_text(ResultStmt, idx, "Smith, John Jacob
On Fri, Dec 17, 2010 at 3:12 PM, Richard Hipp wrote:
> On Fri, Dec 17, 2010 at 2:27 PM, John Drescher wrote:
>
>> >
>> > I'm unable to run your sqlite3.exe: MSVCR100.dll no found.
>> >
>> That is visual studio 2010 runtime.
>>
>
> Can someb
>
> I'm unable to run your sqlite3.exe: MSVCR100.dll no found.
>
That is visual studio 2010 runtime.
John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Thanks, Pavel. I will do this.
R,
John
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
> On Behalf Of Pavel Ivanov
> Sent: Friday, December 17, 2010 9:22 AM
> To: General Discussion of SQLite Database
> Su
r 17, 2010 9:01 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] beginner
>
> On Fri, Dec 17, 2010 at 08:42:54AM -0600, john darnell scratched on the wall:
>
> > I am learning SQLite based on the O'Reilly book by Jay Kreibich,
> > called "
Hello Srindhi:
From one SQLite beginner to another...
SQLite and SQL are two different subjects. So you need to clarify for
yourself what you want to do. Do you want to learn SQL? Then there are a
number of good books you can get from Amazon to help you learn, and there are a
number o
m table). Is there some setting within SQLite3 that I
should be manipulating to provide me UTF8 output?
The last four fields lead me to believe that my problem may be up front, on
input. They accurately reflect the values that I am storing. The only
difference between them and the earlier
statement that the Insert
statement did not work.
Once I bind the data to the Insert statement, how can I look at the final
statement to see what I have done wrong when the statement does not work?
R,
John A.M. Darnell
Senior Programmer
Walsworth Publishing Company
Brookfield, MO
John may also be
> Indeed, Windows Explorer.
>
> Please investigate the options in the popup menu (maybe you should
> choose "Properties" first and then look in the dialog box... I'm not
> sure). It has to be there :)
>
> --
> Regards,
> Serge Ig
ck") - thanks to Luuk34 for the tip.
> >>
> >
Stupid question I know, but you did mean Windows Explorer, did you not?
Anyway, stupid question or not, when I right-click the file in Windows
Explorer, I see no option to unblock. I'm using XP SP3. Is there another
option?
R,
John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
> On Behalf Of Dagdamor
> Sent: Tuesday, December 07, 2010 12:46 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] enums
>
> john darnell
ay.
Thanks for the information, Max.
R,
John
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
> On Behalf Of Max Vlasov
> Sent: Tuesday, December 07, 2010 12:15 PM
> To: General Discussion of SQLite Database
> Subject: R
Is there any way to build an SQLite table that recognizes enums? It's a lot
easier to understand at data that looks like this:
kHard
kSoft
kAlt
kSoft
kSoft
kHard
than this:
1
2
3
2
2
1
R,
John A.M. Darnell
Senior Programmer
Walsworth Publishing Company
Brookfield, MO
John may also be re
Okay, I seem to have figured it out. One needs to create the database and
then add a table before the database will be created.
Sorry for the baby steps.
R,
John A.M. Darnell
Senior Programmer
Walsworth Publishing Company
Brookfield, MO
John may also be reached at
johnamdarn...@gmail.com
ions
Enter SQL statements terminated with a ";"
sqlite>
I quit out of the SQLite shell and looked for test.db and did not find it.
So my question remains. How do I create a database?
R,
John A.M. Darnell
Senior Programmer
Walsworth Publishing Company
Brookfield, MO
John may also
Thanks Igor.
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Igor Tandetnik
Sent: Monday, November 29, 2010 7:11 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Just compiled SQLite in Visual Studio
john darnell wrote
Thanks, Simon. I'll take your advice.
Oh and BTW, I apologize for the "Mac truck" remark--I meant no offense to my
friends who code for the Mac (grin).
R,
John
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
e SQLite.c file without
any errors. Is it really that easy, or am I about ready to be hit by a Mac
truck filled with bugaboos?
R,
John A.M. Darnell
Senior Programmer
Walsworth Publishing Company
Brookfield, MO
John may also be reached at
johnamdarn...@gmail.com<mailto:johnamdarn...@gmail.c
Also what's your journal_mode and synchronous setting? (
http://www.sqlite.org/pragma.html#pragma_synchronous)
Depending on how these are set, if your application terminates early, or
system crashes, you will likely corrupt your DB.
2010/10/30 Martin Engelschalk
> Hello Lizhe,
>
> in order for
the tables have exactly the same schema, in theory I should
> > be able to use the same prepared statement on any one of those tables.
> Any
> > ideas on if this is possible?
>
> No, it's not possible, because prepared query contains information
> about the tables used by
need an
explcity ORDER BY, which would make the query more expensive.
On Fri, Oct 29, 2010 at 9:11 AM, Simon Slavin wrote:
>
> On 29 Oct 2010, at 4:52pm, john Papier wrote:
>
> > The thing is, I need to keep a cursor to where in the
> > table I was last searching, so I can con
Hi,
I need to create multiple tables all having the same schema. The
number/names of the tables will by dynamic. There would be somewhere in the
order of 10 to 100 of these tables. When doing operations on these tables, I
want to avoid having to do a prepare_query every time for performance
reason
0xFF);
>
> Changing the code in this way will not affect the quality of the resulting
> optimized code.
>
>
>
> Is this a common Multibyte versus Unicode error issue?
>
Mixing debug and release?
John
___
sqlite-users mailin
have not seen a document describing all the functions in the DLL, so I am
looking for help determining if there is a more appropriate function to call
when dropping a trigger.
Thanks in advance for any advice.
John
___
sqlite-users mailing list
sqlite
I see that normal views across attached databases do not work but it
looks like I can create a temporary view across attached databases. Is
this a supported configuration? I want to make sure before I put this
in my application.
--
John M. Drescher
Hello,
The following query works for me.
select * from db2.table where not exists (select * from db1.table where
db1.table.column1 = db2.table.column1);
Thanks again for the assistance.
--- On Fri, 9/24/10, Oliver Peters wrote:
From: Oliver Peters
Subject: Re: [sqlite] Query to compare t
Hello,
Thanks for your response.
I'm almost there but I keep getting sql syntax error (near col1) with the last
part of the query
where(not exists in db2);
Here's where I'm at:
select 'db1', db1.table1.col1, 'db2', db2.table2.col1 from db1.table1,
db2.table2 WHERE (NOT EXISTS col1 IN db2);
Hello,
I compare an application every few days which has sqlite as it's client
database.
I look at the content and check whether documents have made it into the
application after it has been built. I also check the metadata in the sqlite
client database for changes.
So, I am constantly compari
Hi,
I'm very beginner in SQL query syntax and my problem is :
I have a database that contains several objects and their properties.
Each object has it's own table where its properties are stored ( TEXT
Keyword, REAL Value ).
So, in each table we find Keywords such as : Weight, Length, Cost,...
Thanks for the prompt reply.
What form should the file take. I've tried enclosing the data for each
column in double quotes and separating them with either a comma, tab or
space but I get an error "expected 5 columns but only found 1. Using | I
get "datatype mismatch"
Also when I use .dump does
If I'm using MySQL I can populate a database with "Load data infile
'/tmp/data.txt' into table table_1"
Is there a similar way of loading data into a sqlite3 database?
Thanks
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sq
> Thanks for all the feedback!
>
> It helped a lot.
> 1. I'm going to try and see what happen if I leave the "end transaction"
> until 5 insert was done.
This is what I meant also when I said 500 was too small.
John
___
>
> This is a basic Visual C++ question.
>
> http://www.delphifaq.com/faq/f923.shtml
>
Sorry for the noise. I guess I should not try reading mail while
playing a flash game in a second window..
John
___
sqlite-users mailing list
sqlite-
isual C++ question.
http://www.delphifaq.com/faq/f923.shtml
John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Tue, Jul 13, 2010 at 12:48 PM, John Drescher wrote:
>> I was wondering if that's really so. Wouldn't the marginal speed
>> improvement be quite small? Is the percentage of the final rowcount really
>> a criterion?
>
> Each transaction costs at least 1 d
> I was wondering if that's really so. Wouldn't the marginal speed improvement
> be quite small? Is the percentage of the final rowcount really a criterion?
Each transaction costs at least 1 disk seek. Doing thousands of seeks
the result would be
ge of a million.
John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ounds: you can set JOURNAL_MODE to TRUNCATE, in
which case the journal file exists all the time, so it's not inconceivable
that you could keep a file handle open all the time.
I guess the other issue is that it returns SQLITE_FULL instead of something
more useful.
Any thoughts, suggestions?
listinfo/sqlite-users
>
--
John M. Drescher
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 6/25/2010 10:51 PM, Simon Slavin wrote:
>
> On 26 Jun 2010, at 3:47am, John wrote:
>
>> I don't know if SQLite now supports foreign keys yet or not.
>
> So you're posting to a mailing list you don't read ?
I read this! ;-)
Actually, I did do one project
On 9/26/2009 10:17 PM, John wrote:
> I have "The Definitive Guide to SQLite" and it has jump
> started me with databases. (the index could stand a lot
> of improvement though).
>
> I am looking for a "quick start" example of the normalization
> case where one
ecker).
Although it's surprising that this would happen (as the journal file is in a
hidden system directory (e.g. C:\users\john\AppData\Local\MyApp)) I guess
badly behaved apps may well briefly open and lock recently changed files.
(As an aside, this is clearly an issue the sqlite team hav
es.
So, I'm speculating that in my case SQLITE_FULL might actually be because of
an IO error which SQLite is incorrectly interpreting?
Or if not an IO error, then a system resources problem (I have some other
anecdotal evidence to suggest other crashes are related to low system
resources).
hi all,
i'm new to this forum and sqlite.
is it possible to have an executable (i.e. .exe) with connections to 2
sqlite databases?
i've read doc and it doesn't speak to this one way or the other.
thanks,
john
___
sqlite-users mail
>> in the near future we will implement windows 7. My question: Is
>> SQLite running on windows 7?
>>
I have been using sqlite under windows 7 for at least 8 months without
a single issue.
John
___
sqlite-users mailing list
sqlite-use
Forgot to say that the error occurs at the sqlite3_close function.
John
On Feb 23, 11:17 am, John wrote:
> Hi All,
>
> The very simple C-code below returns error message " library routine
> called out of sequence" .
> I really don't understand why ?
>
> I
( TMPstring );
sqlite3_close(db);
return;
}
if( sqlite3_close( db ) != SQLITE_OK );
{ wxMessageBox( wxString("Database can not be closed
properly !\n\n") << sqlite3_errmsg( db ));
return( -1 );
}
---
same time. You *might* be able to do so up to the limit of the cores in
the machine or by distributing the load over many machines, however, the
implication to me of a long running process is something that is
consuming large amounts of CPU time. It is possible that running
mu
Sorry, mailman stripped the patch from my message.
j...@work:~$ cat sqlite_tclsh_freebsd.patch
diff -Nur sqlite-3.6.22.orig/Makefile.in sqlite-3.6.22/Makefile.in
--- sqlite-3.6.22.orig/Makefile.in 2010-01-04 18:02:40.0
-0600
+++ sqlite-3.6.22/Makefile.in 2010-01-07 15:50:03.000
I realize this tarball and its autotools scripts aren't supported, but I
figured I'd share the patch anyway. On my FreeBSD 8 system I don't have
a "tclsh" command but I do have "tclsh8.4" and it is detected by
configure.
___
sqlite-users mailing list
s
designed
given the constraints of INTEGER PRIMARY KEY. The behavior does,
admittedly, produce a result which does not correspond to expectations
and therefore is a possible source of downstream bugs. Perhaps it
merits investigation.
Personally, I would expect the result:
rowid|id
1|I am "
nd SQLite, in which case the
suggestion to obtain the extensive knowledge available from books is
valid or
b. your statement mislead the group by misinforming them as to your
state of knowledge.
FWIW
John
___
sqlite-users mailing list
sqlite-users@sqli
I love the idea of READONLY and ENFORCE. I would certainly make use of
those in amalgamation form. What license do you put these under?
You should really publish these all somewhere, there are some great
features. Good work.
- John Brooks
On Tue, Dec 15, 2009 at 6:26 AM, wrote:
> Hi
Hi
Thanks for responding, I've added my comments in below.
On Dec 9, 2009, at 11:30 AM, Kees Nuyt wrote:
> On Tue, 08 Dec 2009 22:07:34 +0100, John Clayton
> wrote:
>
>> Hi
>>
>> I've got two processes opening up two sqlite databases. Assuming the
>>
ng error on commit.
Has anyone seen this kind of locking error or have suggestions as to
how I could track it down?
Thanks
--
John Clayton
Skype: johncclayton
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ed
during VACUUM, in contrast to a usual ROWID. It is unclear here if the
FTS3 rowid does or does not change during vacuum.
- John Brooks
On Thu, Dec 3, 2009 at 4:15 PM, Nicolas Williams
wrote:
> Use the glob operator.
> ___
> sqlite-user
pported by SQLite.
IMHO it's a bug (or oversight):
C:\Users\John\Documents>sqlite3 test.db3
SQLite version 3.6.20
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table foo (id integer, value varchar);
sqlite> .q
C:\Users\John\
ity in
>usage than most AA implementations rigidly built into many fashionable
>languages.
I would go crazy if I had to use a language without any structures,
objects, or arrays. How could a man LIVE without arrays? Heck, even
assembly language has arrays and/or structures (allocate your me
file formats. SQLite is far more flexible, and the moment
you need to adjust the schema, or and an index, SQLite will immediately
become worth it.
I wouldn't use SQLite for most in memory data that never needs to be
stored on disk, but I STRONGLY recommend SQLite for persistent d
Hi Serdar,
For Solaris, you need:
ramdiskadm -a mydisk 2m
newfs /dev/rramdisk/mydisk
mkdir /mnt/ramDisk
mount /dev/ramdisk/mydisk /mnt/ramDisk
John
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf
in
blobs. If you need to query against the array elements, use a custom
function (though, if you need to query against the elements in the
array, you should REALLY be using a relational table.)
As far as order goes, it is reasonably easy to order the rows using a
field for that purpose.
John
_
In your specific example you could simply define a custom "LIKE"
function, and LIKE could become Unicode aware without any goofy new
operators.
John
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jean-Christophe
updated
to use the new strongly typed SQLite, then Apache is updated to use the latest
PHP, finally, one by one, web hosting providers throughout the world update to
the latest Apache. And a whole rash of websites suddenly have problems. These
sites changed NOTHING, but suddenly their sites don't work?
I see SERIOUS problems with this proposal, especially in terms of backwards
compatibility.
John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
. For Win2k, only
UCS-2 is supported. Starting with XP, the Win32 APIs accept full UTF-16.
On any version, MultiByteToWideChar() should return data in the proper
encoding for that system. Igor and the others helped hash this through
until the real answer could be
l data you tried to attach, but I couldn't
because the attachment was blank except for a message footer.
John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
C level, not the
SQLite or printf level.
You'll need an arbitrary precision math library, sqlite3_bind_blob(),
and sqlite3_prepare_v2(). You can't use sqlite3_bind_double() because
your number is too big for a double.
FYI, those arbitrary precision libraries are brutes
rors at application compile time anyway, I
think I like the current behavior better.
Just my 2 cents.
John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
the encoding right. I use the
wide APIs myself, and if I was making a horrible mistake I wanted to
know. Besides, I figured the OP would prefer accurate information.
Many thanks for making sure I had my facts straight.
John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> He's probably measuring the number of atoms in a city or something.
LOL. Actually my bet is that field of the project has more to do with
number theory. That's the only likely way to get a number that large
with such high precision.
John
_
> Um...how do I go to the page that describes the date-time information
> without just 'knowing' it's there? For example, there seems to be no
> path to http://www.sqlite.org/lang_datefunc.html from
> http://.sqlite.org.
I used Google personally. &q
and above should (according to Kaplan and
Chen) support UTF-16 for API calls.
John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
;m no longer sure, and I can't find any reliable documentation on
this either way. It would be good if the APIs accept UTF-16, because that would
mean they also accept UCS-2, but I couldn't find anything reliable to support
this idea. Some folks say yes. Some say no. The documentation
elevant when binding,
where the strong typing of the API clarifies things.
John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
601 - 700 of 2794 matches
Mail list logo