Re: [sqlite] Column values

On Mon, Oct 06, 2008 at 10:57:22PM -0400, Merv scratched on the wall: > Hi > > Will someone please tell me how I can retrieve the value of a column, > i.e. is if integer or varchar etc. > I am accessing an unknown file. If you have an unknown SQLite database file you're trying to poke

Re: [sqlite] Column values

You're asking for the column type, not the value. If you open the database with sqlite3 there is a command that you can use that shows the SQL commands that created the table. The .help functionality is very descriptive though the actual command escapes me at the moment. Hope this helps

[sqlite] Column values

Hi Will someone please tell me how I can retrieve the value of a column, i.e. is if integer or varchar etc. I am accessing an unknown file. Have a super one! Merv ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] calculating cached page size for SQLITE_CONFIG_PAGECACHE

Hello list I wrote a function that attempts to calculate the cached page size for a given page size, to be passed as the sz parameter for sqlite3_config(SQLITE_CONFIG_PAGECACHE, buf, sz, N). It appears to work so far (with 3.6.3) but I'd appreciate if anyone could go over it and see if they

Re: [sqlite] Memory Resident Database

Ribeiro, Glauber wrote: You probably want to open your in-file database, open the :memory: database, and copy all the data from the file to memory, do your manipulations in memory, then copy back to file when you're done. http://www.sqlite.org/cvstrac/wiki?p=InMemoryDatabase has a simple TCL

Re: [sqlite] Floating point numbers

> Does anyone knows why floating point numbers are truncated when they are > written or read from the database?! SQLite stores real numbers as 8 byte IEEE floats, which can hold approximately 16 significant digits. See: http://www.sqlite.org/datatype3.html You could get slightly more

[sqlite] Floating point numbers

Hi, Does anyone knows why floating point numbers are truncated when they are written or read from the database?! The following code truncates the number so that precision is lost! rc = sqlite3_exec(db, "create table test_tab (num_row real)", callback, 0, ); if( rc!=SQLITE_OK ){

[sqlite] SQLite garbage collection in PHP

If I'm doing, as it might be, the following in PHP: $dbh = new PDO ("sqlite:mydb"); $res1 = $dbh->query ("select ..."); $res11 = $res1->fetchAll (PDO::FETCH_ASSOC); Does anyone know at what point the variable $res1 becomes free for re-use? Is it immediately after the assignment to $res11

Re: [sqlite] SQLite syntax diagrams

I love the diagrams. They are much easier to read (for me) than plain text. To make them searchable, perhaps alt-text would suffice? RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf

Re: [sqlite] Memory Resident Database

You probably want to open your in-file database, open the :memory: database, and copy all the data from the file to memory, do your manipulations in memory, then copy back to file when you're done. http://www.sqlite.org/cvstrac/wiki?p=InMemoryDatabase has a simple TCL program to copy a database,

Re: [sqlite] Replacement for sqlite3_expired?

On Oct 6, 2008, at 1:01 AM, Michael Grigoriev wrote: > Moderator, please feel free to disregard previous email. I figured > it out. Oops. Sorry for letting this through. My moderation policy is to pass any emails that have "SQLite" somewhere in the subject line. I didn't look at the

Re: [sqlite] SQLite syntax diagrams

I find those diagrams less readable than text version. There are other problems besides my personal preferences: - text cannot be copied from pictures - syntax cannot be viewed with text-only browsers - site loads a little longer (there are still people that don't use broadband)

Re: [sqlite] Replacement for sqlite3_expired?

Moderator, please feel free to disregard previous email. I figured it out. Thanks, Michael. On Mon, Oct 6, 2008 at 00:42, Michael Grigoriev <[EMAIL PROTECTED]> wrote: > Hi, > > I noticed that sqlite3_expired is now marked as deprecated. What is > the new suggested mechanism for finding out if a

[sqlite] Replacement for sqlite3_expired?

Hi, I noticed that sqlite3_expired is now marked as deprecated. What is the new suggested mechanism for finding out if a cached statement has expired? PS. I think it would be generally useful to update the Deprecated Functions page on the website to indicate the replacement for each deprecated

Re: [sqlite] [Index] Listing 6001 after 601 and not after 801?

On Sun, 5 Oct 2008 08:52:21 -0600, "Dennis Cote" <[EMAIL PROTECTED]> wrote: >It sounds like you want the account numbers to be sorted as text rather than >numerically, so cast the values to text in the order by clause. > > ... order by cast(account_number as text) ... Thanks guys. An easier

[sqlite] Compile SQLite3 for MS Windows Driver Kit user-mode application

Hello, Has anybody tried to compile SQLite3 with the MS WDK? The Win32 DLL is not compatible as far as I understand and recompiling with the WDK is necessary. But using the source code as is results in many warnings (mostly conversion errors). The WDK does not tollerate these. Best

Re: [sqlite] Memory Resident Database

marcglennjamon wrote: Hello guys, Is there an option in SQLite to make the database file reside in the memory during sql transactions for faster access? I am using the C# language under Mono. Thanks in advance, Marc Glenn Yes - use ":memory:" (without the double quotes) as the

[sqlite] Data Analysis help

HI folks, I'm seeking some assistance in analyzing a rather flat database (imported from Excel / CSV). I recognize the need for a more structured database, but can't get my head around a "good"/"best fit" set of schemas to represent the data requried. If someone is willing to donate their time