/29/18, Tilsley, Jerry M. wrote:
>
> 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.
>
Do you have a license for the SQLite Encry
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
All,
I'm trying to use the INSERT OR REPLACE syntax so that I don't have to worry
about duplicate entries without creating a trigger. Using the schema:
CREATE TABLE messages (id numeric);
and using the SQL:
insert or replace into messages values (1);
Why does this result in multiple rows of
>-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,
All,
I have the schema:
CREATE TABLE panel_tracker (ov_id numeric, mt_acct char(12), orm_id numeric,
panel_code char(5));
I would like to create the following INSTEAD OF INSERT trigger:
create trigger insteadInsertPanelTracker instead of insert on panel_tracker
begin
set @ov_id = select ov_id
All,
I have a database that I am using with a couple processes that will modify the
database at near the same time. So I thought this would be the ideal time to
investigate the WAL mode. How do I enable this on the database, and what do I
need to watch for when talking to this db after WAL
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
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
This
All,
I have two environments; one production and one test/development. Both are
Redhat Linux 6.3 running SQLite 3.7.10. On the test/development environment
when I'm using the SQLite shell I can use the up/down arrows to use previous
commands, but on my prod environment I keep getting "^]]A"
Community,
I have a section of code like:
db eval $dbSelectStmt rows {
keylset kreq_codes $rows(col1) $rows(col2)
}
This captures two columns and loads them into a keyed list that I need to use
as a lookup. I would like to catch any errors that may result, shouldn't be
any
.
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
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 are
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
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
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
All,
I am trying to import some data from a csv file to an existing table called
MasterChargeList. But this is failing with the error that the table does not
exist. This is on SQLite 3.6.4 (required to use this version). See below for
details:
sqlite> .mode csv
sqlite> .schema
CREATE TABLE
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
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
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
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 and
>>Ludovic VP wrote:
>>
> >Is there a reason why SQLiteConnection.DataSource is set to the
> >database
>>file without the extension?
>>
>I'm not sure; however, it cannot be changed at this point without breaking
>backward compatibility.
An similar method could be developed to allow the 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
TCL Question
On Tue, May 8, 2012 at 7:40 PM, Tilsley, Jerry M.
<jmtils...@st-claire.org>wrote:
> I have set the timeout now and will monitor this change, on the note
> of using WAL I do have a question. The database is accessed by SQLite
> 3.6.4 from a vendor's application, but on
: [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"
>
, 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
All,
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" error.
This is a multi-thread process that writes to the DB, do I need to enable WAL
for this, if so, do I do this from the TCL side or the
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
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
All,
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), discharge_dt int, Primary
Key(acct), Foreign Key(mrn) references Patient_Info(mrn));
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]
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
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
...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Simon Slavin
Sent: Wednesday, January 04, 2012 10:33 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Performing Backup via TCL, receiving error
On 4 Jan 2012, at 1:53pm, Tilsley, Jerry M. wrote:
> How ca
]
On Behalf Of Tilsley, Jerry M.
Sent: Wednesday, January 04, 2012 10:24 AM
To: 'sqlite-users@sqlite.org'
Subject: 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
-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Dan Kennedy
Sent: Wednesday, January 04, 2012 10:19 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Performing Backup via TCL, receiving error
On 01/04/2012 08:53 PM, Tilsley, Jerry M. wrote:
> I
On Behalf Of Richard Hipp
Sent: Wednesday, January 04, 2012 8:27 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Performing Backup via TCL, receiving error
On Wed, Jan 4, 2012 at 8:23 AM, Tilsley, Jerry M.
<jmtils...@st-claire.org>wrote:
> I use the tcl commands:
>
: [sqlite] Performing Backup via TCL, receiving error
On 01/04/2012 06:55 AM, Tilsley, Jerry M. wrote:
> All,
>
> I am attempting to generate a backup script written in TCL that will backup
> all the databases in a given directory. These databases were all created
> with SQLite version
All,
I am attempting to generate a backup script written in TCL that will backup all
the databases in a given directory. These databases were all created with
SQLite version 3.6.4. I have the tea package for version 3.7.9 which is what I
am using to execute the backup command. When the
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.
..@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Richard Hipp
Sent: Tuesday, January 03, 2012 3:26 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] libtclsqlite3 package
On Tue, Jan 3, 2012 at 3:18 PM, Tilsley, Jerry M.
<jmtils...@st-claire.org>wrote:
>
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
]
On Behalf Of Richard Hipp
Sent: Tuesday, January 03, 2012 12:29 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Performing Backups with TCL
On Tue, Jan 3, 2012 at 12:07 PM, Tilsley, Jerry M.
<jmtils...@st-claire.org>wrote:
> Can you share your syntax you use? What I
users-boun...@sqlite.org]
On Behalf Of Richard Hipp
Sent: Tuesday, January 03, 2012 12:03 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Performing Backups with TCL
On Tue, Jan 3, 2012 at 11:43 AM, Tilsley, Jerry M.
<jmtils...@st-claire.org>wrote:
> All,
>
>
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
44 matches
Mail list logo