SQLite Forum

Serious Sqlite command line Problems after Windows 10 update
Login
Thank you for your reply

(1) The customer's Laptop is a Surface pro and after Microsoft advised him to download the latest version of windows 10 his laptop  has Microsoft Windows [Version 10.0.19042.630]  the Sqlite version is 3.33.0 2020-08-14 13:23:32
the windows update that appears to have caused the problems described below was
November 10, 2020—KB4586786 (OS Builds 18362.1198 and 18363.1198)

  The application which failed invoked a command/batch file which included the following command
      Sqlite3  input.db  <android.sql
where android.sql is a set of valid sql/sqlite commands creating a data base to be loaded onto an ANDROID mobile device, the same file on an identical computer without the  windows update and download produces the data base and exits, but on this customers Laptop it does not create the data base and  just opens another command prompt window and displays an sqlite prompt.

Yet The application he uses has successfully worked for over 10 years. and prior to the windows update he has not had this issue before.


I created a simple text file test.sql with just one sqlite command .Help

and at the command prompt typed

  sqlite3  <test.txt

The result is that the command is not obeyed and another command prompt window opens and displays the sqlite commmand  prompt

If at this command prompt I type

.read test.txt

The help menu is displayed and the command works

I think recreating the problem is not easy.


Many Thanks
P.s 1 Fortunately, no other customer has reported the same fault, so the panic is hopefully now over, and this customer has an identical contingency plan fail-safe back up laptop and is working successfully on his fail-safe laptop.
and attempts to get the original working laptop are still ongoing.

P.S. 2Perhaps an online BUG report form would help those who want to report possible bugs to you. and the option to attach screen shots or video recordings of the bug. happening would help to see the problem taking place.










W