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

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

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

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

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

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

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

ºÃÏñCB2010ûÓÐÌṩ·ÃÎÊSQLITEµÄ×é¼þ.


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


µÚÒ»,ÎÒ²»ÖªµÀÄÄÀïÏÂÔØÕâ¸öDLL
µÚ¶þ,ÓÐûÓо²Ì¬µÄµ÷Ó÷½·¨?


È¥sqlite¹ÙÍøÓÐdllÏÂÔغÍÔ´´úÂë¡£
cb×Ô´øµÄ×é¼þûÓÐÖ§³ÖsqliteµÄ¡£ÓеÚÈý·½×é¼þ°üÖ§³ÖsqliteµÄ£¬Ãû×ÖÍüÁË¡£

sqliteÓÐ×Ô¼º°ü×°ºÃµÄsqlite3.dll£¬ÌṩÁ˵¼³ö½Ó¿Ú¸øÄãʹÓÃ
http://blog.donews.com/jetport/archive/2007/06/25/1179461.aspx

http://topic.csdn.net/u/20090427/10/47e56aae-0698-487e-903e-e6e1b14d6b72.html

лл¸÷λ´ó´ó»Ø¸´.
ÎÒÏÖÔÚÒѾ­¸ãºÃÁ˾²Ì¬Á´½Ó,²»ÐèÒªDLLÁË.
ÁíÍâÇëÎÊsqliteµÄsqlÓï¾äÊÇutf-8µÄ,»¹ÊÇansiµÄ?



ÒýÓÃ
µ÷Óýӿڲ»Í¬£¬¿ÉÒÔÑ¡ÔñUTF-8£¬Ò²¿ÉÒÔÑ¡ÔñUTF-16£¬Çë²Î¿´SQLiteµÄAPI
ÖÁÓÚÔÚCBÏÂʹÓ㬿ÉÒÔÓÃASQLite C++ ·â×°
Ò²¿ÉÒÔÑ¡Ôñ SQLite µÄ ODBC Çý¶¯ http://www.ch-werner.de/sqliteodbc/
ºÍ DISQLite3 µÈ

µ«ÊÇ SQLite ÔÚCBϵķâ×°£¬ºÃÏñ¶¼²»Ì«ÀíÏ룬ֱ½ÓÓÃAPIµÄ»°£¬»Øµ÷±È½ÏÂé·³£¬²»¹ý¼æÈÝÐԷdz£ºÃ£¬¶øÇÒÊý¾Ý¿â´æÈ¡³¬¿ì£¨ÄÚ´æģʽÏ£©


Õâλ´ó´ó£¬Çë¸æËßÎÒSQLÓï¾äµÄUTF-16·½Ê½ÈçºÎµ÷Óã¿

{{----


Ïà¹ØÎÊ´ð£º

sqliteÊý¾Ý¿â¼àÊÓÎÊÌâ(´¥·¢Æ÷?)

SQL´¥·¢Æ÷¿ÉÒÔµ÷ÓÃÍⲿ³ÌÐò£¬sqlite¿ÉÒÔÂð£¿Èç¹ûÏë¼àÊÓÊý¾Ý¿âijһÕűíµÄijһÏîµÄ¸Ä±ä¸ÃÔõô×ö£¿Óô¥·¢Æ÷»¹ÊÇÆäËûʲô·½·¨£¿
Èç¹ûÑ¡ÔñÓô¥·¢Æ÷¸Ã´úÂë¸ÃÔõôд£¿Çë¸ø³ö˼·»ò´úÂ룬ÆäËû»¹ÓÐʲô·½·¨¿ÉÒÔ¼àÊÓÊý¾Ý¿â± ......

ÈçºÎÔÚsqliteÖÐɾ³ýÇ°NÌõ¼Ç¼

ûÓÐÖ÷¼ü£¬ÎÒֻҪɾ³ýÇ°NÌõ¼Ç¼¡£nÊýÖµ´ó¸ÅÔÚǧÍò¼¶±ðµÄ¡£
ÓÃset rowcount n

ÒýÓÃ
ÓÃset rowcount n


Ö§³Ö

SELECT IDD=IDENTITY(INT,1,1),* INTO #T from TB

DELETE #T WHERE IDD NOT I ......

sqliteÀÏÊDZ¨´íno such column

SELECT qsmallClass.Sname, qproducts.pmodel, qproducts.punit, qmaintain.mcount from qsmallClass INNER JOIN (qproducts INNER JOIN qmaintain ON qproducts.pid = qmaintain.pid) ON qsmallClass.Sid = qproduc ......

SQLITE´æͼƬ

´ó¼ÒºÃ£¬ÇëÎʸ÷λ´óϺ£¬Ë­ÓÐSQLITE´æͼƬ·¾¶µÄ´úÂë»òÀý×Ó°¡£¬Çë°ïæ¸øСµÜ·¢Ò»¸ö£¬tiandaliubin@163.com ÕæµÄºÜ¼±°¡¡£ÏÈллÁË¡£
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers

ÒýÓÃ
http://www.sql ......

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

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

ÒýÓÃ
¶÷£¬²»»á°¡£¬PPCµÄÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ