winceÏÂʹÓÃsqliteµÄ¿ìËÙ²éѯ£¿
´ó¼ÒºÃ£º
×î½üÔÚwinceÏÂʹÓÃsqlite£¬µ«ÊÇÓÉÓÚ±íµÄÄÚÈÝÁ¿´ó£¬ËùÒÔ²éѯЧÂʺܵͣ¬²»ÖªµÀʲôÎÊÌâ¼°Ôõô½â¾ö¡£
ÎҵıíµÄ½á¹¹ÈçÏ£º
name wlon elon nlat slat scale
Ò»¹²¾ÍÒ»ÕÅ±í£¬Áù¸ö×ֶΣ¬·Ö±ðÊÇͼƬµÄÃû×Ö£¬Í¼Æ¬µÄ·¶Î§£¨¾Î³¶È·¶Î§£©ºÍ±ÈÀý³ß¡£
µ±Ä³¸ö±ÈÀý³ßϵÄͼƬºÜÉÙµÄʱºò£¬²éѯ»¹Ëã¿ìµÄ£¬µ«Êǵ±scale= 24000ʱ£¬¸Ã±ÈÀý³ßÏÂͼƬΪ30Íò×óÓÒ¡£ÎÒʹÓÃÏÂÃæµÄ²éѯÓï¾ä£º
select * from bitmap_table where scale = 24000 and name = '12.png';
ʱ£¬¾ÍÏûºÄÁËÊ®¼¸¶þÊ®ÃëµÄʱ¼ä²Å²éѯµ½½á¹û²¢»ñÈ¡Æä¾Î³¶ÈÊý¾Ý£¬ÔÚpcÏÂʱ¸Ã¹ý³ÌºÄʱ´óÔ¼ÊÇ0.8Ãë¡£
ÇëÎÊ¿¼Âǵ½winceµÄ×ÊÔ´ÎÊÌâºó£¬Õâ¸öʱ¼äÊDz»ÊÇÕý³££¿
ÓÐûÓиĽøµÄ·½·¨£¿ÒòΪ»¹ÓиüÏêϸµÄͼ²ã£¬Í¼Æ¬¸ü¶à£¬²éѯҳ¾Í»á¸üÂýÁË¡£
ÁíÍâ²¹³äһϣ¬ÎÒ²éѯµÄʱºò¶¼ÊǸù¾Ý¾Î³¶È²éѯµÄ£¬¶øÕâЩ×Ö¶ÎÒѾÊǽ¨ÁËË÷ÒýÁ˵ģ¬ÕâÀï¾ÙÀýµÄ²éѯÓï¾ä¼òµ¥Ö»ÊÇΪÁË˵Ã÷ÎÊÌâ¡£
»¹ÓÐÎÒÿ´Î²éѯÂú×ãÌõ¼þµÄͼƬ×î¶à¾Í4ÕÅ¡£
²»ºÃÒâ˼£¬ÏîÄ¿ÔÝʱͣÁË¡£Ä¿Ç°Ã»Ê±¼äÔÙÈ¥Ñо¿Õâ¸öÎÊÌâÁË¡£
²»¹ý»¹ÊÇлл¹Ø×¢£¬ÏȽáÌùÁË¡£ÒÔºóÓлú»áÔÙѧϰÊý¾Ý¿â²éѯµÄ֪ʶ¡£
Ïà¹ØÎÊ´ð£º
ÇóVB6.0Á¬½ÓSqliteÊý¾Ý¿â¼°²éѯ´úÂ룬½â˵ԽÏêϸԽºÃ£¬ÒòΪÎÒ»¹Ã»ÓÐÓùýSQLite£¬Ð»Ð»£¡
Éϴζ¼²»¸øÎÒ·Ö¡£¡£
×¢²ásqltp30.dllÕâ¸öActiveX DLL
ÓÃÀïÃæµÄSQLiteDBÀཨÁ¢¡¢Á¬½ÓÊý¾Ý¿âÎļþ£¬¾ÍÏñADODBÀïµÄConnecti ......
żÏ뱸·ÝÊý¾Ý±í£¬Ð´ÁËÒ»¸öÅú´¦Àí£¬ÓÐÏֳɵÄÊý¾Ý¿â¡£µ«ÊÇÅú´¦Àíдµ½Ò»°ë²»»áÁË£¬»¹Çë°ïæ¿´¿´£¬ÔõôÍùÏ¡£¡£¡£
@echo off
echo ÕýÔÚϵͳÊý¾Ý¿â±¸·Ý£¬ÇëÉÔ ......
×îºÃÊ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 ......
ÎÒÓÃsqliteadmin½¨ÁËÒ»¸öÊý¾Ý¿âtest.sdb,¿ÉÊÇÔõôҲ´ò²»¿ªÌáʾÈçÏ´íÎó£ºFile opened that is not a database file
file is encrypted or is not a database¡£
ÎÒµÄÁ¬½Ó×Ö·û´®ÈçÏÂÂ¥ÉϵĿɲ»¿ÉÒÔ°ïÎÒ¿´¿´
S ......