Çë½ÌʹÓÃTree¿Ø¼þºÍSQLiteÊý¾Ý¿âµÄÎÊÌâ
ÎÒÏëÒª½«sqliteÊý¾Ý¿âÖеÄÊý¾Ý£¬ÒÔÊ÷¿Ø¼þµÄÐÎʽ¶Á³ö£¬²¢ÇÒÏÔʾÔÚ¶Ô»°¿òÉÏÃæ£¬²»ÖªµÀÔõô×ö£¬À´Çë½Ìһϡ£
ps£º¿´µ½ÓÐʹÓÃÊ÷¿Ø¼þºÍaccessµÄ£¬ÀïÃæÓÐÊý¾Ý¿âÒýÇæÀ´Á¬½ÓÊý¾Ý¿âºÍ³ÌÐò£¬ÎÒ²»ÖªµÀSQLiteÈçºÎÓë³ÌÐòÁ¬½ÓÆðÀ´
SQLiteÊÇ·ñ¿ÉÒÔÓÃADOÁ¬½Ó
¼ÈÈ»ÒѾ¿´µ½Á¬ACCESSµÄ£¬ÄÇôӦ¸ÃÉÔ×÷¸Ä¶¯¾Í¿ÉÒÔÁ˰ɡ£
Õâ¸ö¸úʹÓÃÄĸöÊý¾Ý¿âû¹ØÏµ°É?
¹Ø¼üÊÇÄã×Ô¼ºµÄ±í½á¹¹Éè¼ÆÒªºÏÀí
Ïà¹ØÎÊ´ð£º
¿ÉÒÔÌí¼ÓÊý¾Ý£¬µ«ÊǵãÌí¼Óºó»á±¨.access violation at address 0049AB84 in module
Ô´Âë
procedure Tstudent.add_buttonClick(Sender: TObject);
var
sqlstr:string;
begin
&nb ......
ÎÒÏë×öÒ»¸ösqliteµÄ¼à¿ØÈí¼þ£¬ÊµÊ±ÖªµÀÓû§¶ÔÊý¾Ý±í¶¼×öÁËÄÄЩ²Ù×÷¡£
ÔÚÓû§update Ò»¸öÓû§Êý¾Ý±íֵʱ£¬ÎÒÈçºÎ¿ÉÒÔµÃÖªÓû§updateµÄÄĸö×ֶεÄÖµ£¿ÎÒ±¾À´¸øÓû§±íÌí¼Ó´¥·¢Æ÷À´ÊµÏֵ쬵«´¥·¢Æ÷ºÃÏñÖ»Äܵõ½Ó ......
³ÌÐò´úÂëÈçÏ£º
sqlTime = "select SUM(onlineTimeSpan) from T_OnlineTimeSum where ipAddress = :a AND onlineDate BETWEEN :b AND :c";
  ......
sqlliteÀïÃæÓÐʲô·½·¨°Ñintת»»ÎªÊ®Áù½øÖÆ´æ´¢µÄÄØ?
ÀýÈç,strftime('%s', 'now') µÃµ½1263777947,µ±Ç°µÄÃëÊý,ÎÒÏë´æ´¢ÎªËüµÄÊ®Áù½øÖƱíʾ"4B53B89B"
лл..
ÆäʵÎÒÊÇÏëstrftime ......