On Friday, 3 August, 2018 13:50, Warren Young wrote:
>I’d be careful trying to apply your knowledge directly to SQLite.
>dBase comes out of the non-SQL world, so it’s going to have a
>different outlook in many areas.
>If the following is a fair description of how FoxPro for DOS indexes
>work, th
On 3 Aug 2018, at 7:52pm, John R. Sowden wrote:
> My concern in using Sqlite is since the index is embedded into the database
> file with various tables, if I am running multiple Sqlite database files, how
> do I use a common index for the different database files.
Okay. Thanks for that clari
On Aug 3, 2018, at 12:52 PM, John R. Sowden wrote:
>
> I have the xbase type of databases down tight
I’d be careful trying to apply your knowledge directly to SQLite. dBase comes
out of the non-SQL world, so it’s going to have a different outlook in many
areas.
> I understand what an index i
to Heaven says a
lot about anticipated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of John R. Sowden
>Sent: Friday, 3 August, 2018 12:52
>To: sqlite-users@mailinglists.sqlite.org
>Subject: Re: [
On 8/3/18, John R. Sowden wrote:
> I have the xbase type of databases down tight, having been using them
> since I bought my copy of dBASE II from George Tate of Ashton-Tate at a
> West Coast Computer Faire in 1981.
Are you using indexes to impose uniqueness constraints across multiple tables?
--
I have the xbase type of databases down tight, having been using them
since I bought my copy of dBASE II from George Tate of Ashton-Tate at a
West Coast Computer Faire in 1981. I have been writing applications for
my alarm company, now through Foxpro 2.6 in DOS. I understand what an
index is.
On 2 August 2018 at 20:08, Keith Medcalf wrote:
Further to this, you can "emulate" the current structure by creating
multiple databases each containing only the tables needed for that "bit" of
your application. For example, you can create a customers.db containing
the customers table and all the
> another point that I did not make clear. The accounting programs are not
> associated with the technical programs, different people, different security
> access. The tech databases and programs are in portable computers that go out
> in the field, but not the accounting, etc. There indexes wo
> another point that I did not make clear. The accounting programs are not
> associated with the technical programs, different people, different security
> access. The tech databases and programs are in portable computers that go out
> in the field, but not the accounting, etc. There indexes wo
te-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Jean-Luc Hainaut
>Sent: Thursday, 2 August, 2018 15:04
>To: SQLite mailing list
>Subject: Re: [sqlite] Common index for multiple databases
>
>On 02/08/2018 20:50, Keith Medcalf wrote:
>> In n
On 02/08/2018 20:50, Keith Medcalf wrote:
In no DBMS known can you index data sourced from multiple tables in the same index --
this applies to "Relational" databases and all other database models (such as
pure hierarchical, network, network extended, etc.) In all DBMS systems the contents of
On 2 Aug 2018, at 7:44pm, John R. Sowden wrote:
> another point that I did not make clear. The accounting programs are not
> associated with the technical programs, different people, different security
> access. The tech databases and programs are in portable computers that go
> out in the f
-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Keith Medcalf
>Sent: Thursday, 2 August, 2018 12:51
>To: SQLite mailing list
>Subject: Re: [sqlite] Common index for multiple databases
>
>
>You misunderstand how dBase databases work.
a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of John R. Sowden
>Sent: Thursday, 2 August, 2018 12:27
>To: sqlite-use
Hi,
On Thu, Aug 2, 2018 at 1:44 PM, John R. Sowden
wrote:
> another point that I did not make clear. The accounting programs are not
> associated with the technical programs, different people, different security
> access. The tech databases and programs are in portable computers that go
> out
another point that I did not make clear. The accounting programs are
not associated with the technical programs, different people, different
security access. The tech databases and programs are in portable
computers that go out in the field, but not the accounting, etc. There
indexes would h
den
Sent: Thursday, August 02, 2018 2:27 PM
To: sqlite-users@mailinglists.sqlite.org
Subject: Re: [sqlite] Common index for multiple databases
I made a mistake. I should have said table, not database. My concern
is if I have 4 databases each with tables associated with a particular
use, like accounting, te
Hi,
On Thu, Aug 2, 2018 at 1:27 PM, John R. Sowden
wrote:
> I made a mistake. I should have said table, not database. My concern is if
> I have 4 databases each with tables associated with a particular use, like
> accounting, technical, etc., which may reside on different computers, how do
> I
I made a mistake. I should have said table, not database. My concern
is if I have 4 databases each with tables associated with a particular
use, like accounting, technical, etc., which may reside on different
computers, how do I keep the index in each database file current. I
assume that I h
On 2 Aug 2018, at 6:11pm, John R. Sowden wrote:
> I do not want these databases to all reside in one sqlite file. How do I
> index each database on this customer account number when each database and
> associated index are in separate files? Is this what seems to be referred to
> as an exter
t 02, 2018 1:12 PM
To: sqlite-users@mailinglists.sqlite.org
Subject: [sqlite] Common index for multiple databases
I have been reviewing sqlite for a couple of years, but still use
foxpro. I have a question regarding an index issue.
Currently I have several types of databases (in foxpro, one per
I have been reviewing sqlite for a couple of years, but still use
foxpro. I have a question regarding an index issue.
Currently I have several types of databases (in foxpro, one per file)
that all point to an index of a common field, a customer account
number. The databases are for accountin
22 matches
Mail list logo
