SQLite DB problems - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: SQLite DB problems (/showthread.php?tid=68215)

---

SQLite DB problems - MX_Master - 08.03.2009

I uploaded some sqlite DBs (*.db files) through FTP into my online server's `filterscripts` folder (Windows sa-mp server, on my local computer Windows too). Game mode added some data into DBs with db_query( db_link, "INSERT INTO ..." );. So i downloaded these DB files back on my computer and can't open/edit any of them.

SQLite Administrator shows message box "qAdmin: Cannot perform this operation on a closed dataset." SQLite Maestro shows message box "SQL Error: library routine called out of sequence"

If data was added to DBs by my local windows server, DB files still can be edited properly.

Any ideas?

---

Re: SQLite DB problems - MX_Master - 08.03.2009

You mean properly usage of db_close ? I checked 3 GMs. First open DB into OnGameModeInit and db_close it into OnGameModeExit. Second opens and closes DB after each query. Third opens DB file into main() and has no db_close. Still one result - can't open DB file after downloading it back to my computer.

---

Re: SQLite DB problems - MX_Master - 08.03.2009

yea, but "open problem" i saw in any of these cases

---

Re: SQLite DB problems - MX_Master - 08.03.2009

In any way even if i closes DB files remotely properly, this problem is still here.

---