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
have to be updated when the computers are back at the office.
John
On 08/02/2018 11:33 AM, Igor Korot wrote:
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
ommunicate with the master in order to stay current.
I do this now because I have 1 account number index and the various
foxpro databases (tables) all open that one index when each is used.
John
On 08/02/2018 10:31 AM, Simon Slavin wrote:
On 2 Aug 2018, at 6:11pm, John R. Sowden wrote:
I d
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
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: Sunday, 22 October, 2017 20:59
To: sqlite-users@mailinglists.sqlite.org
Subject: [sqlite] very sqlite3 noobie
^C./sqlite3_test.py: line 7: syntax error near unexpected token `('
./sqlite3_test.py: line 7: `connection = sqlite3.connect(':memory:')'
john@sentry35:~$
On 10/22/2017 08:44 PM, Simon Slavin wrote:
connection = sqlite3.connect(':memory:')
same
john
I just checked my file with a hex editor (ghex) and found they are all
hex 27.
John
On 10/22/2017 08:27 PM, Simon Slavin wrote:
On 23 Oct 2017, at 4:13am, John R. Sowden <jsow...@americansentry.net> wrote:
error from terminal program:
./sqlite3_test.py: line 6: syntax erro
i just switched to python3 - no difference in error
On 10/22/2017 08:13 PM, John R. Sowden wrote:
error from terminal program:
./sqlite3_test.py: line 6: syntax error near unexpected token `('
./sqlite3_test.py: line 6: `connection = sqlite3(':memory:')'
john@sentry35:~$
version 2.7.12
at 9:59 PM, John R. Sowden
<jsow...@americansentry.net> wrote:
Since I am trying to learn sqlite3 (unlearning foxpro) I find that python is
the simpleist language, wfich allows me to focus on sqlite, I amtrying the
=guide just sent to the list.
I am getting a syntax error on line 5.
Since I am trying to learn sqlite3 (unlearning foxpro) I find that
python is the simpleist language, wfich allows me to focus on sqlite, I
amtrying the =guide just sent to the list.
I am getting a syntax error on line 5. below is the program copied by
hand from the guide:
Thank you all for your feedback. I now have a lot more to digest. I
will investigate the attach command. I am concerned about keeping all
of my company's data in 1 file, as if something happened to that file, I
would have data entry, programming, etc. to on all systems since the
last
I have been using the xbase language (dbase, foxpro, etc.) for about 36
years, writing applicatios for my alarm company, so each database is a
separate file for me. For the last 21 years, I have been using Linux,
and have found that sqlite is my best match for Linux database use.
What I fail
Thank you!
John
On 11/22/2016 01:21 PM, R Smith wrote:
On 2016/11/22 6:00 PM, John R. Sowden wrote:
That was a throw back to years ago. I was trying to protect against
y2k by making each dbf for 1 calendar year. Also, these files are
about 800k in size, so I was worried about storage
Am 21.11.2016 um 19:08 schrieb John R. Sowden:
Thank you all for your answers and direction for further information.
Hopefully, I will not bring these subjects up again. :)
John
On 11/21/2016 09:29 AM, John R. Sowden wrote:
First of all, I come from the dBASE/Foxpro world. There is no
dis
toph
Am 21.11.2016 um 19:08 schrieb John R. Sowden:
Thank you all for your answers and direction for further information.
Hopefully, I will not bring these subjects up again. :)
John
On 11/21/2016 09:29 AM, John R. Sowden wrote:
First of all, I come from the dBASE/Foxpro world. There is no
d
Thank you all for your answers and direction for further information.
Hopefully, I will not bring these subjects up again. :)
John
On 11/21/2016 09:29 AM, John R. Sowden wrote:
First of all, I come from the dBASE/Foxpro world. There is no
distinction between a table and a database. I
First of all, I come from the dBASE/Foxpro world. There is no
distinction between a table and a database. I understand that with
Sqlite a database includes tables and other items. The scenario that I
do not understand, is: say I have a log file with about 7 fields
totaling about 80
Good Morning:
I am a pre-newbie. A few questions. Q1: I am running xubuntu. When I
search for sqlite3, lots of things show up. This database engine seems
to be very popular, so I assume it is used my many programs on my
computer, like Thunderbird. Why, then when I enter sqlite3 at
18 matches
Mail list logo