sqlite¿ØÖÆÊý¾Ý¿â´óС
sqliteÖÐÓÐûÓжÔÓÚÊý¾Ý¿â´óС½øÐйÜÀíµÄ½Ó¿Ú£¿±ÈÈ磬´´½¨Êý¾Ý¿âµÄʱºòÖ¸¶¨Êý¾Ý¿â´óС£¬¶ÔÊý¾Ý¿â½øÐвÙ×÷ºó²ì¿´¸ÃÊý¾Ý¿âÊ£ÓàµÄ¿ÉʹÓõĿռä´óСµÈ¡£×î½ü¿´ÁËÒ»ÏÂsqliteµÄÏà¹Ø½Ó¿Ú£¬ÍøÉÏÒ²ËÑË÷ÁËÏ£¬Ã»ÓÐÕÒµ½ÓÐÓõÄ×ÊÁÏ¡£Çë¸ßÊִͽ̰¢{{
Ïà¹ØÎÊ´ð£º
C# code:
System.Data.SQLite.SQLiteConnection conn = new SQLiteConnection(@"acs.db");
try
{
conn.Open();
}
......
ÇódelphiÔõÑùÁ¬½ÓSqlite Ôöɾ¸Ä²éÀý×Ó
ÓÃASqlite3Query,ÉèÖÃËûµÄconnectionΪASqlite3DB
ASqlite3Query.Sql.text := 'insert into ....';
ASqlite3Query.Execsql;
sqlstr:='insert into stude ......
¿ÉÒÔÌí¼ÓÊý¾Ý£¬µ«ÊǵãÌí¼Óºó»á±¨.access violation at address 0049AB84 in module
Ô´Âë
procedure Tstudent.add_buttonClick(Sender: TObject);
var
sqlstr:string;
begin
&nb ......
ÎÒÏë×öÒ»¸ösqliteµÄ¼à¿ØÈí¼þ£¬ÊµÊ±ÖªµÀÓû§¶ÔÊý¾Ý±í¶¼×öÁËÄÄЩ²Ù×÷¡£
ÔÚÓû§update Ò»¸öÓû§Êý¾Ý±íֵʱ£¬ÎÒÈçºÎ¿ÉÒÔµÃÖªÓû§updateµÄÄĸö×ֶεÄÖµ£¿ÎÒ±¾À´¸øÓû§±íÌí¼Ó´¥·¢Æ÷À´ÊµÏֵģ¬µ«´¥·¢Æ÷ºÃÏñÖ»Äܵõ½Ó ......
sqliteµÄ¿ÕÖµ²éѯÔõôд,ÄÜÕߵ÷Ö
select * from tt where f1 is null
select * from yourTable where col is null;
SQL code:
sqlite> create table Aoqun (id int primary key,col1 int);
sqlite> ......