Re: [sqlite] Is this a problem?

2017-05-23 Thread Leona Struckhoff
Yah! when i did the .open leona.rmgc and then entered pragma integrity_check;I got OK  thank you From: Jens Alfke To: SQLite mailing list Sent: Tuesday, May 23, 2017 5:55 PM Subject: Re: [sqlite] Is this a problem? > On May 23, 2017, at 3:31 PM, Leona Struckhoff wr

Re: [sqlite] Is this a problem?

2017-05-23 Thread Jens Alfke
> On May 23, 2017, at 3:31 PM, Leona Struckhoff wrote: > > I placed the Leona.rmcg file in the same folder as the sqlite3.exeI double > clicked on sqlite3.exeI noticed my comand prompt had sqlite and not sqlite3. > Your examples below have sqlite3. > I entered the following:sqlite> sqlite3 Le

Re: [sqlite] Is this a problem?

2017-05-23 Thread Virgilio Fornazin
upside down and I could read it. > > > From: Keith Medcalf > To: SQLite mailing list > Sent: Tuesday, May 23, 2017 5:00 PM > Subject: Re: [sqlite] Is this a problem? > > > I would suggest following up with RootMagic and see if they have > overloaded one of

Re: [sqlite] Is this a problem?

2017-05-23 Thread Leona Struckhoff
: Keith Medcalf To: SQLite mailing list Sent: Tuesday, May 23, 2017 5:00 PM Subject: Re: [sqlite] Is this a problem? I would suggest following up with RootMagic and see if they have overloaded one of the builtin collation sequences (NOCASE comes to mind) with something else -- perhaps

Re: [sqlite] Is this a problem?

2017-05-23 Thread Leona Struckhoff
qlite3": syntax errorsqlite> I wasn't sure if i needed the [ ] around the file name so it did it with and without.  I got the same results. From: Simon Slavin To: SQLite mailing list Sent: Tuesday, May 23, 2017 4:32 PM Subject: Re: [sqlite] Is this a problem? On 2

Re: [sqlite] Is this a problem?

2017-05-23 Thread Keith Medcalf
-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of moma...@yahoo.com > Sent: Tuesday, 23 May, 2017 11:08 > To: sqlite-users@mailinglists.sqlite.org > Subject: [sqlite] Is this a problem? > > I am new to SQite. I am not new to queries. I am a 28 year QA

Re: [sqlite] Is this a problem?

2017-05-23 Thread Simon Slavin
On 23 May 2017, at 6:07pm, moma...@yahoo.com wrote: > > I ran the following query over my RootMagic 7 (Version 7.22.3.0 – 24 Jan > 2017)database in SQLite Spy (Version 1.9.11 Win32): Neither of these matter. Neither of these tell you which version of SQLite they’re running. However, the fact

[sqlite] Is this a problem?

2017-05-23 Thread momakid
I am new to SQite. I am not new to queries. I am a 28 year QA Tester. I have been doing queries and macros for the past 25 years. I ran the following query over my RootMagic 7 (Version 7.22.3.0 – 24 Jan 2017)database in SQLite Spy (Version 1.9.11 Win32): --integritycheck.sql PRAGMA integrity_c