Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

fleaphpÖÐsqliteÔõôÓÃ

ÓÉÓڳɱ¾¿¼ÂÇÓÃsqlite×öÊý¾Ý¿â£¬¿ÉÊÇÔÚµ÷ÓÃcreate·½·¨Ê±³ö´í£¬ºÃÏñÊDz»Äܵõ½×ÔÔöµÄIDÔõô¸Ä°¡
ÓÃmysqlÓÐʲô³É±¾£¿


ÓÃmysql²»µÃÂòÊý¾Ý¿â°¡¡£¡£¡£
¶¼ÊÇÒ»Ð©Ð¡ÍøÕ¾

id INTEGER NOT NULL PRIMARY KEY
ÉèΪÖ÷¼ü¾Í×ÔÔö

ÒýÓÃ
id INTEGER NOT NULL PRIMARY KEY
ÉèΪÖ÷¼ü¾Í×ÔÔö

ÎÒÖªµÀÕâÑùÄÜ×ÔÔö£¬ÎÒÏëÎʵÄÊÇfleaphp²»ÄÜÌí¼ÓÊý¾Ý£¬³öÏÖ´íÎóµÄµØ·½ºÃÏñÊÇ»ñÈ¡×î´óIDµÄʱºò£¬sqliteÖ§³Ölast_insert_idÂð

sqlite_last_insert_rowid

Ë­ÓÐÔÚfleaphp 1.7ÖÐÄÜÓõÄsqliteÇý¶¯°¡

up

ÓÃsqliteµÄÈ˾ÍÕâôÉÙÂð

ÓÃsqliteµÄÈ˲»ÉÙ£¬µ«ÓÃfleaphpµÄÈ˲»¶à

ÒýÓÃ
ÓÃsqliteµÄÈ˲»ÉÙ£¬µ«ÓÃfleaphpµÄÈ˲»¶à

Äĸö¿ò¼ÜѧϰÇúÏ߯½»ºÄØ£¿
ÎÒÕýÔÚÕÒÒ»¸ö¿ò¼Üѧѧ


Ïà¹ØÎÊ´ð£º

sqliteÏÂselect * from table whereµÄÎÊÌâ

ÎÒÏÖÔÚÏë°´ÕÕ×Ö¶Î DAY ºÍ NAME À´²éѯ£¬ÎÒÏëʵÏÖ£º±ÈÈ磬ÔÚÒ»¸öÊäÈë¿òÀïÊäÈë ¡°2009-10-12ÕÅÈý¡±£¬¿ÉÒÔ²éѯ³ö×Ö¶ÎDAYºÍNAMEµÄ×éºÏ·ûºÏÊäÈëµÄÄÇÏî¡£
Ò»°ãºÃÏñÊǰÑÁ½¸öÌõ¼þ·Ö¿ªÐ´£¬where DAY= and NAME= ÏÖÔÚÎÒÏëÈà ......

cb2010ÔõôʹÓÃSQLiteÊý¾Ý¿â£¿

×îºÃÊDz»ÐèÒªÁíÍâ°²×°Çý¶¯»ò×é¼þµÄ·½Ê½¡£

ʹÓÃSQLiteµÄAPI, ËüÌṩÁËdll ÐÎʽµÄAPI

ÄѵÀCBÌṩµÄÊý¾Ý×é¼þ²»Ö§³Ö£¿

2010ÊÇÖ§³ÖµÄ¹Ø¼üÊÇÇý¶¯ÒªÑ¡¶Ô£¬ºÃÏñÊÇoffice 11ʲôµÄ

ÒýÓÃ
ÄѵÀCBÌṩµÄÊý¾Ý×é¼ ......

delphiÔõÑùÁ¬½ÓSqlite Ôöɾ¸Ä²é

delphiÁ¬½ÓSqlite Ôöɾ¸Ä²éÀý×Ó
Êý¾Ý¿âÒѾ­Á¬Í¨ÁË, ²åÈë»á±¨´í£¬no query specified
with dm.ASQLite3Query1 do
  begin
    dm.ASQLite3Query1.Close;
    dm.ASQLite3 ......

delphi Á¬½ÓsqliteÊý¾Ý¿â£¬insert±¨´í

¿ÉÒÔÌí¼ÓÊý¾Ý£¬µ«ÊǵãÌí¼Óºó»á±¨.access violation at address 0049AB84 in module 

Ô´Âë
procedure Tstudent.add_buttonClick(Sender: TObject);
var
  sqlstr:string;
begin
&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ