Re: [sqlite] Pragma Use for TCL scripts

it. Come to find out I was making a really stupid coding error. I think I have this working now. Jerry -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Wednesday, August 29, 2018 12:45 PM To: SQLite mailing list

[sqlite] Pragma Use for TCL scripts

All, Trying to access some encrypted databases via TCL interface and need to provide the key. Can someone provide an good example of this? I've found some things on google, but not having much success. Thanks, Jerry Tilsley Disclaimer Confidentiality

[sqlite] Insert or Replace Trouble

of the same value? I'm I just not understanding the syntax correctly? Thanks, Jerry Tilsley, CIS Lvl 2 Information Services | St. Claire Regional Medical Center Jerry.Tilsley at st-claire.org Disclaimer This email is confidential and intended solely

[sqlite] What's the status of SQLite4? Where can I find its source code?

Seems I could not find its source code ... https://sqlite.org/src4/doc/trunk/www/index.wiki Thanks.

[sqlite] What's the best way to pass function information to virtual table?

hacky of course and non-standard if you're exposing > SQL to users. > > MikeN > > > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto: > sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Jerry > Sent: Monday, June

[sqlite] What's the best way to pass function information to virtual table?

inal Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto: > sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Clemens Ladisch > Sent: Wednesday, June 17, 2015 1:23 AM > To: sqlite-users at mailinglists.sqlite.org > Subject: Re: [sqlite] What's the best way to

[sqlite] What's the best way to pass function information to virtual table?

What's the best way to pass function information to > virtual table? > > Jerry wrote: > > With xBestIndex and xFilter, we can pass the constraint information > > (e.g., those from WHERE clause) to virtual table (through struct > > sqlite3_index_info), so that we can locate

[sqlite] What's the best way to pass function information to virtual table?

Thanks, Clemens. Some of my comments as follows 2015-06-17 1:23 GMT-07:00 Clemens Ladisch : > Jerry wrote: > > With xBestIndex and xFilter, we can pass the constraint information > (e.g., > > those from WHERE clause) to virtual table (through struct > > sqlite3_index_info

[sqlite] What's the best way to pass function information to virtual table?

Hi, I am working on sqlite+rocksdb, i.e., using rocksdb as the back-end using sqlite virtual table. With xBestIndex and xFilter, we can pass the constraint information (e.g., those from WHERE clause) to virtual table (through struct sqlite3_index_info), so that we can locate the cursor to narrow

[sqlite] UNION with ORDER BY collate gives 'Error: no such column:'

collating sequences are compatible with the comparison collations before using the merge algorithm for compound SELECT statements. Fix for ticket [6709574d2a8d8]. (user: drh) So is my question is: Is it my query that is broken or is this a bug? Thanks, Jerry

[sqlite] 0 bytes in -wal file indicates successful checkpoint?

of data loss. Am I correct? Thank you, Jerry

Re: [sqlite] Adding WHERE to query --> database disk image is malformed

On 2014 Jun 24, at 14:46, David Empson wrote: > The most likely explanation is that it got processed by something which > thought it should be treated as ASCII text and was doing a spurious LF-to-CR > translation. If there was only one 0x0A byte in the "good" file, then

Re: [sqlite] Adding WHERE to query --> database disk image is malformed

ory for my project, I committed the corrupt file about 10 days ago. Still trying to figure out how that happened. Thank you guys for all of the clues. Jerry ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Adding WHERE to query --> database disk image is malformed

Oh, I just realized that, although Igor’s suggestion “fixed” the problem, this database definitely does not contain any indexes. The schema dump is simply this… CREATE TABLE ItemTable ( "key" text UNIQUE, value blob NOT NULL ); ___ sqlite-users

Re: [sqlite] Adding WHERE to query --> database disk image is malformed

On 2014 Jun 23, at 21:49, Igor Tandetnik wrote: > One possibility: the query with WHERE clause attempts to use some index, > while the query without doesn't. > > Try this query: > > SELECT * FROM itemTable WHERE +key = 'profileName' ; > > Note the + sign - this

[sqlite] Adding WHERE to query --> database disk image is malformed

One thing I find rather surprising is that sqlite seems to know that the 14-byte and 24-byte blobs are UTF16-LE encoded strings, and prints them as “Fooobar” and “Baah”. Is my database OK or malformed? The same thing happens when I execute the failing query with the sqlite3 C Library,

Re: [sqlite] Instead Of Insert Trigger Error

>-Original Message- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] >On Behalf Of Clemens Ladisch >Sent: Thursday, March 06, 2014 11:29 AM >To: sqlite-users@sqlite.org >Subject: Re: [sqlite] Instead Of Insert Trigger Error >Tilsley,

[sqlite] Instead Of Insert Trigger Error

from ov_systems where mt_mnemonic=NEW.ov_id; insert into panel_tracker values (@ov_id, NEW.mt_acct, NEW.orm_id, NEW.panel_code); end ; But I receive the following error: Error: cannot create INSTEAD OF trigger on table: main.panel_tracker Can you assist me in figuring this out? Jerry

[sqlite] WAL/TCL Question

mode is enabled? Thanks! Jerry Tilsley, CIS Lvl 2 St. Claire Regional Medical Center Sr Systems Analyst jerry.tils...@st-claire.org Disclaimer This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views

Re: [sqlite] Performing Multiple SQL Statements Within A Transactions Using TCL

rming Multiple SQL Statements Within A >>Transactions Using TCL >>On 10/10/2013 2:14 PM, Tilsley, Jerry M. wrote: >>> All, >>> >>> Does anybody have any examples of wrapping multiple SQL insert/update >>> statements in a transaction using the TCL AP

[sqlite] Performing Multiple SQL Statements Within A Transactions Using TCL

All, Does anybody have any examples of wrapping multiple SQL insert/update statements in a transaction using the TCL API? Thanks, Jerry Tilsley, CIS Lvl 2 St. Claire Regional Medical Center Sr Systems Analyst jerry.tils...@st-claire.org Disclaimer

[sqlite] Problem with getting previous command in shell

this out since it is occurring only inside the SQLite shell and not at the OS level. Thanks for any help! Jerry Tilsley, CIS Lvl 2 St. Claire Regional Medical Center Sr Systems Analyst jerry.tils...@st-claire.org Disclaimer This email is confidential and inten

Re: [sqlite] Not reading data in the -wal file? (Not Reproducible)

() and sqlite3_close() appear in that order with no early returns in the code and which is always called on the main thread, the next query would open a new database connection. But at least I tried, and got advice from the smartest people out there. Jerry

Re: [sqlite] Not reading data in the -wal file? (Not Reproducible)

ction handle. It don't see how Process 3 could get the new record, but Process 2 would not get it until a relaunch. Is the story as I told it possible, or must I have gotten something wrong? Jerry ___ sqlite-users mailing list sqlite-users@sqlite.org http:

[sqlite] Not reading data in the -wal file? (Not Reproducible)

ny possible explanations would be appreciated. Jerry Krinock ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] TCL SQLite Catch During DB Eval?

unless something goes really crazy. Can I do the following: If {[catch {db eval $dbSelectStmt { keylset kreq_codes $rows(col1) $rows(col2) }} errMsg]} { Puts "you had an error!" } Thanks! Jerry Disclaimer This email is co

Re: [sqlite] JDBC Drivers for SQLite?

. LMH Tilsley, Jerry M. [via SQLite] wrote: > All, > > Might be a silly question, but does anyone know if any JDBC drivers > exist for SQLite? > > Thanks, > > Jerry > > > > Disclaimer > This email is confi

[sqlite] JDBC Drivers for SQLite?

All, Might be a silly question, but does anyone know if any JDBC drivers exist for SQLite? Thanks, Jerry Disclaimer This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented

Re: [sqlite] PHP ODBC Question

SQLite Database > Subject: Re: [sqlite] PHP ODBC Question > > > On 3 Dec 2012, at 3:38pm, "Tilsley, Jerry M." <jmtils...@st-claire.org> wrote: > > > Any suggestions out there on what ODBC driver to use with PHP, or any > other manner to connect to a SQLite data

[sqlite] PHP ODBC Question

All, Any suggestions out there on what ODBC driver to use with PHP, or any other manner to connect to a SQLite database via PHP? Thanks, Jerry Tilsley St. Claire Regional Medical Center Sr Systems Analyst | Interfaces Disclaimer This email is confidential

Re: [sqlite] Importing CSV File Into Table

Thanks all, that fixed my issue and all imported successfully. I knew I was doing something stupid, but wasn't sure. > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Swithun Crowe > Sent: Tuesday, November 13, 2012

[sqlite] Importing CSV File Into Table

TABLE MasterChargeList(charge_code TEXT, mnemonic TEXT, description TEXT); CREATE TABLE OncologyChargeList(charge_code TEXT, mnemonic TEXT, description TEXT); sqlite> .import /csv/iv_codes.csv MasterChargeList; Error: no such table: MasterChargeList; Jerry Tilsley St. Claire Regional Medical

[sqlite] Using 3.6.4 SQLite-Amalgamation file

All, I have the need to get the SQlite-Amalgamation file for 3.6.4, and I need the sqlite3.c file. I downloaded the archive 3.6.4 amalgamation file, but it doesn't contain the sqlite3.c file. How can I make this? Thanks, Jerry Tilsley Sr Systems Analyst St. Claire Regional Medical Center

Re: [sqlite] Select rows where a column is not unique

Subject: Re: [sqlite] Select rows where a column is not unique On Mon, Aug 6, 2012 at 2:58 PM, Tilsley, Jerry M. <jmtils...@st-claire.org>wrote: > Guys, > > I'm sure this is a pretty lame question, but my thinking hat is > malfunctioning this morning. How can I select all

[sqlite] Select rows where a column is not unique

Guys, I'm sure this is a pretty lame question, but my thinking hat is malfunctioning this morning. How can I select all rows from a table where a specific column is NOT UNIQUE? Table has three columns (charge_code, mnemonic, description). Thanks, Jerry Tilsley Sr Systems Analyst St. Claire

[sqlite] svn: SQLite compiled for 3.6.20, but running with 3.6.4

All, Anyone know how I can get rid of the 3.6.20 compilation so that the system will quit complaining? This is on a RedHat 6.2 system. Thanks, Jerry Tilsley Sr Systems Analyst St. Claire Regional Medical Center Disclaimer This email is confidential

Re: [sqlite] Why is SQLiteConnection.DataSource set as the database file without its extension?

could be developed to allow the extension without breaking backward compatibility. Something like: public override void OpenWithExt(){ ... _dataSource = ... } >-- >Joe Mistachkin Jerry Tilsley jmtils...@st-claire.org Disclaimer This email

[sqlite] SQLite Tcl Extension

Does the version number for the TCL Library for SQLite match the version of the core SQLite product? Thanks, Jerry Disclaimer This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions

Re: [sqlite] SQLite via TCL Question

Ok, I appreciate the information! Thanks, Jerry -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Tuesday, May 08, 2012 8:20 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite via

Re: [sqlite] SQLite via TCL Question

: [sqlite] SQLite via TCL Question On 5/8/12 1:51 PM, "Tilsley, Jerry M." <jmtils...@st-claire.org> wrote: >This is probably a newbie question so please bear with me. I'm >accessing a SQLite database through TCL and periodically I get a "Database >Locked" >

Re: [sqlite] SQLite via TCL Question

, May 08, 2012 5:36 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite via TCL Question On 8 May 2012, at 9:51pm, "Tilsley, Jerry M." <jmtils...@st-claire.org> wrote: > This is probably a newbie question so please bear with me. I'm accessing a > SQLit

[sqlite] SQLite via TCL Question

e TCL side or the command-line side? Thanks, Jerry Disclaimer This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent t

Re: [sqlite] sqlite3 3.7.11 on FreeBSD 9.0-RELEASE amd64 (ports) segfaults with memstatus compiled in _pthread_mutex_init_calloc_cb

ite3SchemaClear (p=Variable "p" is not available. ) at sqlite3.c:85429 temp1 = {htsize = 0, count = 4, first = 0x80252af70, ht = 0x0} temp2 = {htsize = 0, count = 1, first = 0x80252afa0, ht = 0x0} pElem = Variable "pElem" is not available. -- Jerry Lundström - S

[sqlite] sqlite3 3.7.11 on FreeBSD 9.0-RELEASE amd64 (ports) segfaults with memstatus compiled in _pthread_mutex_init_calloc_cb

in main () Turning off MEMSTATUS for the sqlite3 ports package removes the problem. I've reported this to FreeBSD also. Cheers, Jerry -- Jerry Lundström - Software Engineer .SE - The Internet Infrastructure Foundation http://www.iis.se/ ___ sqlite-users

[sqlite] Call PRAGMA from TCL API

All, How can I call the pragma statements, more specifically the PRAGMA FOREIGN_KEYS=ON from within the Tcl environment? Thanks, Jerry Disclaimer This email is confidential and intended solely for the use of the individual to whom it is addressed. Any

Re: [sqlite] Question on the use of triggers

on the use of triggers On 2/8/2012 12:30 PM, Tilsley, Jerry M. wrote: > I creating a new database and would like to use triggers on a couple > of the tables. Below are two of the tables I will be working with in > the triggers; > > CREATE TABLE accounts (mrn char(8), acct char(12), d

[sqlite] Question on the use of triggers

this first trigger? Thanks all! Jerry Disclaimer This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of St. Claire

Re: [sqlite] ANNOUNCE: Sqlite Root Gui Admin Tool for manage Sqlite Database

Tried to download, says the installation is corrupt. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Fabio Spadaro Sent: Monday, January 23, 2012 2:35 PM To: General Discussion of SQLite Database Subject: Re: [sqlite]

Re: [sqlite] Performing Backup via TCL, receiving error

Anyway to make the new version the default for the sqlite command when executed from various directories? Sent from my Verizon Wireless Device Simon Slavin wrote: On 4 Jan 2012, at 9:43pm, Tilsley, Jerry M. wrote: > Ok, I'm ending up with two versions of SQLite installed on my system beca

Re: [sqlite] Performing Backup via TCL, receiving error

Ok, I'm ending up with two versions of SQLite installed on my system because one was install with RPM and the latest is a tarball. How do I get the tarball to overwrite the pre-existing version? Jerry Tilsley, Sr Systems Analyst St. Claire Regional Medical Center Morehead, Ky P: 606-783-6563

Re: [sqlite] Performing Backup via TCL, receiving error

Simon, I done as you requested and built a new file. The new TEA extension still fails with SEGMENTATION FAULT when trying to perform backup. Jerry Tilsley, Sr Systems Analyst St. Claire Regional Medical Center Morehead, Ky P: 606-783-6563 -Original Message- From: sqlite-users-boun

Re: [sqlite] Performing Backup via TCL, receiving error

Looks like the file was filtered out, how do I post this out where you can look at it? Jerry Tilsley, Sr Systems Analyst St. Claire Regional Medical Center Morehead, Ky P: 606-783-6563 -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org

Re: [sqlite] Performing Backup via TCL, receiving error

Attached is one of the databases I am having trouble with. If I use the new version of SQLite to back up the file it works, if I use the new TEA lib I get the segmentation fault. Jerry Tilsley, Sr Systems Analyst St. Claire Regional Medical Center Morehead, Ky -Original Message

Re: [sqlite] Performing Backup via TCL, receiving error

base files to the new version? I am unsure on how to run a debugger since my code is executed from a TCL script. Jerry Tilsley, Sr Systems Analyst St. Claire Regional Medical Center Morehead, Ky -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]

Re: [sqlite] Performing Backup via TCL, receiving error

. Jerry Tilsley, Sr Systems Analyst St. Claire Regional Medical Center Morehead, Ky -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dan Kennedy Sent: Wednesday, January 04, 2012 12:03 AM To: sqlite-users@sqlite.org Subject: Re

[sqlite] Performing Backup via TCL, receiving error

the script attempts to execute the command I receive a SEGMENTATION FAULT. Any ideas as to what is going on, or what I should do to correct this issue? Thanks, Jerry Tilsley, Sr Systems Analyst St. Claire Regional Medical Center Morehead, Ky Disclaimer This email

Re: [sqlite] libtclsqlite3 package

That worked! I appreciate the help. Sent from my Verizon Wireless Device Stephan Beal wrote: On Tue, Jan 3, 2012 at 9:41 PM, Tilsley, Jerry M. <jmtils...@st-claire.org>wrote: > /usr/bin/ld: cannot find -ltcl8.4.12 > collect2: ld returned 1 exit status > make: *** [libsqlite3.

Re: [sqlite] libtclsqlite3 package

ltcl8.4.12 collect2: ld returned 1 exit status make: *** [libsqlite3.7.9.so] Error 1 I do have the correct version: tcl>echo $tcl_patchLevel 8.4.12 Thanks, Jerry Tilsley, Sr Systems Analyst St. Claire Regional Medical Center Morehead, Ky -Original Message- From: sqlite-users-boun.

[sqlite] libtclsqlite3 package

All, I need to get the update libtclsqlite3 package. How can I compile this or download this? Thanks, Jerry Tilsley, Sr Systems Analyst St. Claire Regional Medical Center Morehead, Ky P: 606-783-6563 Disclaimer This email is confidential and intended

Re: [sqlite] Performing Backups with TCL

Running SQLite version 3.6.4. This is to work, just not sure why it quit working now. Jerry Tilsley, Sr Systems Analyst St. Claire Regional Medical Center Morehead, Ky P: 606-783-6563 -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org

Re: [sqlite] Performing Backups with TCL

Can you share your syntax you use? What I am using keeps kicking out the error "Error: bad option 'backup': must be..." Jerry Tilsley, Sr Systems Analyst St. Claire Regional Medical Center Morehead, Ky -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-

[sqlite] Performing Backups with TCL

All, Working on a TCL script that will perform backups of my SQLite databases. This is to work, but now it says that the backup option is invalid. Is this option no longer supported? Thanks, Jerry Tilsley, Sr Systems Analyst St. Claire Regional Medical Center Morehead, Ky

[sqlite] Bug: Compiler Warning, Mac OS X, in proxyGetHostID()

In sqlite3.c, version 3.7.4, line 28396 is: struct timespec timeout = {1, 0}; /* 1 sec timeout */ This declaration should be moved inside this #if #if defined(__MAX_OS_X_VERSION_MIN_REQUIRED)\ && __MAC_OS_X_VERSION_MIN_REQUIRED<1050 because presently you get a compiler warning

Re: [sqlite] How rebuild with larger page size from command line?

ither seeing a third (and invalid) argument or an > invalid file name ("placesDump.txt ;"). Ah that works. Although I haven't tried Kishor's idea, that should obviously work too. Thanks all, Jerry ___ sqlite-users mailing list sqlite-users@sql

Re: [sqlite] How rebuild with larger page size from command line?

ror if I delete the PRAGMA line and just have the .read in the file. In the man page for sqlite3, .read will "Execute SQL in [a file]". The problem is probably that .read itself is a meta-command, not "SQL"; hence .read cannot be nested. Any other ideas? Thanks, Jerry ___

[sqlite] How rebuild with larger page size from command line?

But I need them both. What can I do? Thank you, Jerry Krinock ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] valgrind leak summary shows possible memory loss

I recently upgraded to latest sqlite 3.6.2 and valgrind shows possible memory loss of 272 bytes. I narrowed it down to a 2 line program of just sqlite3_open and sqlite_close. Valgrind doc says that this is probably a memory leak unless you are doing funny things with pointers. I saw the early

Re: [sqlite] char to int conversion

Dennis, I did not know about cast expression but it looks like a better solution. Thank you for your quick response. Jerry > >> > I have a CHAR field which is usually an integer. I would like to >> sort > this field as if it is an integer so that 1a 5b 10c 12xxx does >&

[sqlite] char to int conversion

I have a CHAR field which is usually an integer. I would like to sort this field as if it is an integer so that 1a 5b 10c 12xxx does not get sorted as 10c 12xxx 1a 5b. I have successfully used something like "ORDER BY CHARFIELDNAME - 0" which seems to convert the expression to an integer the

Re: [sqlite] SQLite3 file format

few bytes in the file are always "SQLite format 3" but the following bytes don't seem to add up to the dot dots. Thanks, Jerry Krinock ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] "Unsupported File Format" from 3.1.3

te version. I'd thought that sqlite3 databases were generally backward- compatible. Is there any way to find out what is "unsupported" by sqlite 3.1.3 in this database? Thanks, Jerry Krinock ___ sqlite-users mailing list sqlite-u

[sqlite] Does sqlite3_prepare() clean up after itself if it fails?

know. Thanks, Jerry Krinock [1] http://www.sqlite.org/cvstrac/wiki?p=BlobExample [2]: static int writeBlob( sqlite3 *db, const char *zKey, const unsigned char *zBlob, int nBlob) { const char *zSql = "INSERT INTO blobs(key, value) VALUES(?, ?)"; sqlite3_stmt *pStmt;

[sqlite] Can I manually Lock a database?

that they get SQLITE_BUSY until I'm done. How can I manually lock the database using the C API? I can't find any "lock" function. Thanks, Jerry Krinock ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-b

Re: [sqlite] SQLITE_MAX_EXPR_DEPTH

On 2008 Jan, 18, at 19:34, [EMAIL PROTECTED] wrote: But instead of all that trouble, why not just say: id IN (1,2,3,4,5,...,N) Well, I guess the reason I did not say that is because: I had not yet had my SQL lesson for the day. All is wonderful now. Thank you for this, and the

[sqlite] SQLITE_MAX_EXPR_DEPTH

Where is it? Thanks, Jerry Krinock - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] C API: Manifest type SQLITE_INTEGER: Is it 32- or 64-bit?

On 2008 Jan, 03, at 17:21, Kees Nuyt wrote: If I understand the info at http://www.sqlite.org/c3ref/c_blob.html well, the INTEGER is always a 64-bit signed integer. Internally, integers are compressed, so they don't occupy eight bytes all the time. sqlite3_column_int64(); will always

[sqlite] C API: Manifest type SQLITE_INTEGER: Is it 32- or 64-bit?

rs? If so, what if someone throws a 32-bit integer at me someday? How can I tell whether integer data objects in a table are 32 or 64 bit? The column specifications I get from pragma_table_info() are likewise uninformative, saying simply type=INTEGER. Thanks again, Jerry Krinock

Re: [sqlite] sqlite3_get_table(); How to get all column names in C?

. But while thinking about it I realized that pragma SQL can be executed by the C API. So I did this, and it worked. Jerry (It's Objective-C code but anyone who's interested should be able to get the idea.) - (NSArray*)allColumnNamesInTableNamed:(NSString*)tableName { // Will return nil

[sqlite] sqlite3_get_table(); How to get all column names in C?

ral, the number of values inserted into azResult will be ((*nrow) + 1)*(*ncolumn)." However, I when the table has no data rows, the returned ncolumn=0, so the expression evaluates to 0 and indeed I get 0 values. Thanks, Jerry Krinock (Using sqlite 3.4.0, as shipped in M

[sqlite] Compiling a Library or Mac OS X using Xcode

Apple is currently shipping SQLite 3.1.3 in Mac OS 10.4, but SQLite 3.3.5 is much better. Anybody with a Mac and Developer Tools installed can build a the latest version of SQLite as a library in 5 minutes. The hard part was getting my project to use it instead of /usr/lib/libsqlite3.dylib

Re: [sqlite] Advice on compiling 3.5.5 for Mac OS X?

.Framework from /System, click Build and you're done!! I'll write back and post step-by-step details after I test it for a few days and find the bugs ;| Jerry

[sqlite] Advice on compiling 3.5.5 for Mac OS X?

using ./configure and makefile, but this is not my forte. Should I try Xcode first? Sincerely, Jerry Krinock P.S. I realize that SQLite 3.1.3 is built into Tiger, but 3.1.3 is missing many basic features.

[sqlite] How to use SQLite.NET.0.21?

quot;. I think it is related to the SQLite3.dll. Thank you. Regards, Jerry

[sqlite] ruby dbd and sqlite

to do? Jerry - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]