The command prompt here means your CMD.EXE (Windows) or *nix shell... you must use sqlite3.exe [dbfile] to get the sqlite shell to use PRAGMA integrity_check;
*command prompt>* sqlite3 [database filename] sqlite3> PRAGMA integrity_check; sqlite3> .quit On Tue, May 23, 2017 at 7:40 PM, Leona Struckhoff <moma...@yahoo.com> wrote: > Rootsmagic is a free geneology software, so you can not enter direct > commands. They have a integrity check option in their database tools. And > it comes back ok. If there is a command line option, I have not found it > yet. > LOL..My monitor is not upside down and I could read it. > > > From: Keith Medcalf <kmedc...@dessus.com> > To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > 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 something that knows how to do Case > Insensitive and Accent Insensitive across the entire Unicode spectrum. > > Can you issue direct SQL Queries to RootMagic, or does it only use > "pre-canned" queries (pre-canned includes anything where you cannot type an > SQL statement to execute) such as QBE interfaces. > > -- > ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı > > > > -----Original Message----- > > From: sqlite-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 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_check; > > > > I expected to get an OK to be returned. > > > > I actually got the following results: > > multiple rows of “row ??? missing from index idsSourceTemplateName” > > multiple rows of “row ??? missing from index idxPlaceName” > > multiple rows of “row ??? missing from index idxSurnameGiven” > > “row ??? missing from idx Surname” > > Multiple rows of “row ??? missing from index idxGiven” > > > > Yet when I do an integrity check in Rootsmagic 7, it comes back OK. > > I am kinda confused. RootsMagic says it is ok but SQLite says there are > > problems. > > > > OR, am I doing something wrong in SQLite? > > > > If I am not doing anything wrong in SQLite, how do I fix this? > > If I fix this in SQLite, now I am afraid I won’t get an ok in RootsMagic > > on their integrity check. > > > > > > Sent from Mail for Windows 10 > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
