sqliteÖ®Database is lockedÎÊÌâ
»·¾³£ºQNX 6.3.2
°æ±¾£ºSQLite 2.7.3
ÏÖÏó£ºÔÚÃüÁîÐÐÏÂsqlite½øÈ¥£¬Ö´ÐÐ.table¡¢pragmaÖ®Àà¡¢select¶¼Ìáʾ
database is locked
Ææ¹ÖµÄÊÇ£¬¼´Ê¹ÊÇд´½¨Ò»¸öÊý¾Ý¿â£¬Ö´ÐÐÉÏÊöÃüÁîÒ²ÊÇÄÇÑù¡£
Áí£ºÔÚһ̨ÍêÕû°²×°µÄQNX6.3.2ÉÏ£¬Ã»ÓÐÎÊÌ⣬µ«ÊÇÔËÐл·¾³ÊDzüô¹ýµÄ£¬¾ßÌå²Ã¼ôÄÚÈݲ»Ïê¡£
¶àл£¡£¡ ¿à˼ÊýÈÕ£¬ÎÞ¿ÉÄκΡ£
¸Õ½ÓÊÖSQLiteÒ²²»¶®£¬ÓÑÇé°ï¶¥£¡
£¬ÓÑÇé°ï¶¥£¡
{{
Ïà¹ØÎÊ´ð£º
µç»°±¾Æ¥Åä²éѯ£¬Ï£ÍûÒ»ÌõÓï¾ä¸ã¶¨
¼ÙÉèºÅÂë±¾(numtable)ÈçÏÂ:
ºÅÂë(num) ÁªÏµÈË (relationname)
10086 ÒÆ ......
×îºÃÊDz»ÐèÒªÁíÍâ°²×°Çý¶¯»ò×é¼þµÄ·½Ê½¡£
ʹÓÃSQLiteµÄAPI, ËüÌṩÁËdll ÐÎʽµÄAPI
ÄѵÀCBÌṩµÄÊý¾Ý×é¼þ²»Ö§³Ö£¿
2010ÊÇÖ§³ÖµÄ¹Ø¼üÊÇÇý¶¯ÒªÑ¡¶Ô£¬ºÃÏñÊÇoffice 11ʲôµÄ
ÒýÓÃ
ÄѵÀCBÌṩµÄÊý¾Ý×é¼ ......
ÇódelphiÔõÑùÁ¬½ÓSqlite Ôöɾ¸Ä²éÀý×Ó
ÓÃASqlite3Query,ÉèÖÃËûµÄconnectionΪASqlite3DB
ASqlite3Query.Sql.text := 'insert into ....';
ASqlite3Query.Execsql;
sqlstr:='insert into stude ......
delphiÁ¬½ÓSqlite Ôöɾ¸Ä²éÀý×Ó
Êý¾Ý¿âÒѾÁ¬Í¨ÁË, ²åÈë»á±¨´í£¬no query specified
with dm.ASQLite3Query1 do
begin
dm.ASQLite3Query1.Close;
dm.ASQLite3 ......
ÓÉÓڳɱ¾¿¼ÂÇÓÃsqlite×öÊý¾Ý¿â£¬¿ÉÊÇÔÚµ÷ÓÃcreate·½·¨Ê±³ö´í£¬ºÃÏñÊDz»Äܵõ½×ÔÔöµÄIDÔõô¸Ä°¡
ÓÃmysqlÓÐʲô³É±¾£¿
ÓÃmysql²»µÃÂòÊý¾Ý¿â°¡¡£¡£¡£
¶¼ÊÇÒ»Ð©Ð¡ÍøÕ¾
id INTEGER NOT NULL PRIMARY KEY
......