Sqlite·µ»Ø¶à½á¹û¼¯ÎÊÌâ
Sqlite·µ»Ø¶à¸ö²éѯ½á¹û¼¯µÄʱºò£¬ÓÐʲô°ì·¨ÄÜÒÆ¶¯µ½ÏÂÒ»¸ö½á¹û¼¯ÉÏÈ¥
±ÈÈç
ÓÐÓï¾ä
select * from sqlite_master where type='table';select * from sqlite_master where type='index';
Õâ¸öÓï¾äÖ´ÐÐÆðÀ´£¬¾Í»á·µ»ØÁ½¸ö½á¹û¼¯
ÇëÎÊÓÐûÓÐÌṩAPIº¯ÊýÔÚÁ½¸ö½á¹û¼¯Çл»µÄ£¿
²»ÊÇÓõÄADO,¾ÍÊÇÓõÄSqlite×Ô¼ºµÄdll¿â
Õâ¸ö¿ÉÒÔÖ´ÐжàÌõÓï¾ä°¡£¬Ö»ÒªÓ÷ֺŷָî¾Í¿ÉÒÔÁË£¬ÓÃsqlite3.exeÖ´ÐÐÁ½Ìõ¶¼ÐУ¬Ö»ÊÇËû°ÉÁ½ÌõÓï¾äµÄÁ½¸ö½á¹û¼¯×ۺϷµ»ØÁË¡£
²»ÖªµÀÕâλ˵µÄ recordsets[0], recordset[1]£¬ÔõÑùÓã¡ÇëÏêÊö£¬Ð»Ð»
ÎÒÊÇÓõÄDelphi£¬ÓõÄZeosLib¿Ø¼þ×飬Õâ¸ö¶«Î÷Ò²ÊÇÓõÄSqliteµÄ¿ª·ÅAPI½Ó¿ÚʵÏֵģ¡ÀïÃæÓÐTZQuery;
query: TZQuery;
begin
query := TZQuery.create(nil);
query.con := ZConnection;
query.sql.add('select * from sqlite_master where type=''table'';');
query.sql.add('select * from sqlite_master where type=''index''; ');
query.open;
end;
ÄãÓá¡ZeosLib£¬Ó¦¸Ã²éѯһÏÂZeosLibµÄ°ïÖú¡£
ÎÊÌâÒѾ¸ã¶¨£¬£¡½á
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¡
sqlite×Ö¶ÎΪfloatÐ͵ÄÖµÔõÑù·ÃÎÊ£¿
ÊÔ¹ýÓÃsqlite3_column_double£¬È··µ»ØµÄÊý¾Ý²»ÕýÈ·£»
ûÓùý,°ï¶¥.
Ò»Ñù°¡£¬·µ»ØÈ«ÊÇ string
ÄãµÄ´úÂëÊÇʲô£¿
double sqlite3_column_double(sqli ......
ÎÒÖªµÀ´ó¼Ò¶¼ËµÊÇ64λϵͳϲ»ÄÜÓÃ32λµÄsyste.sqlite.dll¡£Õâ¸öÎÒÒѾ»»ÁË
VS2008ÖÐÔËÐж¼Ã»ÎÊÌ⣨ͬһϵͳÏ£©
Ò»·Åµ½IISÖоͱ¨´í£º
δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°System.Data.SQLite¡±»òËüµÄijһ¸öÒÀÀµÏî¡£ÊÔͼ¼ÓÔØ¸ ......
¿ª·¢ÓïÑÔ£ºevc
Êý¾Ý¿â£ºSQLite
˵Ã÷£ºÓÐÁ½¸ö½çÃæ
½çÃæÒ»¸öÊÇÓÃÀ´½¨Á¢Êý¾Ý¿â£¬²¢ÇÒ½øÐÐÊý¾Ý¹ÜÀí¹¦ÄÜ£¬°üÀ¨ctrlist¿Ø¼þÏÔʾÊý¾Ý¿âÄÚÈÝ£¬Ôö¼Ó£¬É¾³ý£¬Ð޸ĵȹ¦ÄÜ£»
½çÃæ¶þ£¬Êǵ÷ÓÃÊý¾Ý¿â£¬½øÐвéѯ£¬ÏÔʾ½á ......
ÎÒ°²×°ÁËÒ»¸ösqlite developer,Ò»¸ö¿ÉÊÓ»¯µÄ¹¤¾ß¡£
½Ó×Å£¬ÎÒÓÖ°²×°ÁËSQLite.NET,²¢ÔÚVSÀïÃæÌí¼ÓºÃÁËdll¡£
ÏÖÔÚ£¬ÎÒÔÚsqlite developerÀï´´½¨ÁËÒ»¸öÊý¾Ý¿â£¬¿âÖаüº¬ÎÒ×Ô¼º¶¨ÒåµÄÒ»ÕÅ±í¡£
ÎÊÌ⣺ÈçºÎ ......
ÒªÔÚlinuxÉÏʹÓÃsqliteÊDz»ÊÇÒªÏȱàÒë°²×°£¿Ôõô°²×°£¿
c#+sqlite+linuxµÄÏà¹ØÓ¦ÓÃÓÐûÓÐһЩÏà¹Ø×ÊÁÏ£¿
linux ÉÏÄÜÔËÐУ㣡¡?
Äã¿ÉÒÔÏÂÔØ±àÒëºÃµÄ£¬Ò²¿ÉÒÔÏÂÔØÔ´´úÂëÔÙ×Ô¼º±àÒë
http://www.sqlite.org/downl ......