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

ÓйØSQliteµÄÒ»¸öÎÊÌâ

³ÌÐò´úÂëÈçÏ£º
sqlTime = "select SUM(onlineTimeSpan) from T_OnlineTimeSum where ipAddress = :a AND onlineDate BETWEEN :b AND :c";
                daSpan = new SQLiteDataAdapter(sqlTime, conn);
                daSpan.SelectCommand.Parameters.Add(new SQLiteParameter("a", DbType.String));
                daSpan.SelectCommand.Parameters.Add(new SQLiteParameter("b", DbType.String));
                daSpan.SelectCommand.Parameters.Add(new SQLiteParameter("c", DbType.String));

                daSpan.SelectCommand.Parameters[0].Value = Address;
                daSpan.SelectCommand.Parameters[1].Value = startDate.Date.ToString("yyyy-MM-dd");
                daSpan.SelectCommand.Parameters[2].Value = endDate.Date.ToString("yyyy-MM-dd");
ÕâÑùд²éѯʱ¼äÌìÊýÊÇһλµÄ׼ȷµÄ±ÈÈç 2009Äê12ÔÂ4ºÅ µ½ 2009Äê12ÔÂ6ºÅ ÈçÏ£º
select SUM(TimeSpan) from TimeSum where Address = 'xxxx' AND lineDate BETWEEN '2009-12-4' AND '2009-12-6'
µ«ÊÇÈç¹ûʱ¼ä¿ç¶ÈΪ 2009Äê12ÔÂ14ºÅ µ½ 2009Äê12ÔÂ16ºÅʱºòÕâÑùд¾Í»á²úÉúÎÊÌâÖ»ÄܺϼƵ½ 14£¬15ºÅ2ÌìµÄÖµ£¬
µ«ÊÇÈç¹û¸ÄΪÈçÏ´úÂ룺 <


Ïà¹ØÎÊ´ð£º

Óа취ÔÚÄ£ÄâÆ÷Éϵ÷ÊÔ²Ù×÷sqliteÊý¾Ý¿âÂð£¿

visual studioÏÂÔÚwmÄ£ÄâÆ÷À³ÌÐò²Ù×÷sqlite¶¼Ê§°Ü£¬µ«ÔÚÊÖ»úÉÏûÎÊÌ⣬´ó¼ÒÆÕ±é¶¼ÊÇÕâÑùÂð£¿Ë­Óнâ¾ö°ì·¨£¿±Ï¾¹ÔÚÄ£ÄâÆ÷Éϵ÷ÊÔЧÂʱȽϸߡ£
¶÷£¬²»»á°¡£¬PPCµÄÄ£ÄâÆ÷ÊÇ¿ÉÒԵİ¡..

ÒýÓÃ
¶÷£¬²»»á°¡£¬PPCµÄÄ ......

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

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

Ô´Âë
procedure Tstudent.add_buttonClick(Sender: TObject);
var
  sqlstr:string;
begin
&nb ......

SQLiteÊý¾Ý¿âÊʺϹ«Ë¾×öÍøÕ¾ÓÃÂð£¿

֮ǰ ¹«Ë¾×öÍøÕ¾Ê¹ÓõÄÊÇasp+access£¬ÏÖÔÚÒ²ÔÚʹÓÃsql server 2005 + asp.net £¬Ç°Õ߿϶¨Òª»»´ú£¬ºóÕßsql serverÌ«ÅÓ´óÁË£¬ËùÒÔÏë»»×öÆäËûµÄÊý¾Ý¿â£¬Ñ¡Ãâ·Ñ¿ªÔ´µÄÀàÐÍ£¬Ö»ÒªÂú×ãÆÕͨÆóÒµÐû´«ÐÍÍøÕ¾£¬ÏÖÔÚ ¿´µ½ÁËSQLi ......

winceÏÂʹÓÃsqliteµÄ¿ìËÙ²éѯ£¿

´ó¼ÒºÃ£º
      ×î½üÔÚwinceÏÂʹÓÃsqlite£¬µ«ÊÇÓÉÓÚ±íµÄÄÚÈÝÁ¿´ó£¬ËùÒÔ²éѯЧÂʺܵͣ¬²»ÖªµÀʲôÎÊÌâ¼°Ôõô½â¾ö¡£
      ÎҵıíµÄ½á¹¹ÈçÏ£º
      name&nbs ......

SQLITEÏÂÈçºÎɾ³ýÄÚÈÝÖеĵÚÒ»¸ö<br>

SQLITEÏÂÈçºÎɾ³ýÄÚÈÝÖеĵÚÒ»¸ö<br>
SQLITEϲ»ºÃÓà
Ìáʾ: 
sqlite error 
no such function: stuff 
Ôõô½â¾ö?
SQL code:
--------------------------------------------- ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ