SQLite Forum

Database anomaly
First, discover what the "current directory" is for the process that uses v3.36 progrramatically. Then look at ajay.db in that directory and observe your "lost" change.

Second, specify the absolute pathname (rather than a relative pathname) to the database your program **should** be accessing.

If the terms "absolute" and "relative" make no sense to you in this context, do a web search for "relative pathname" and study the difference.

> Why is my change not in the database I opened?

Your question presupposes a fact not in evidence. What, exactly, is "the database \[you\] opened"?