delphiÖÐÈçºÎ½«Ò»¸öaccess±íµÄÊý¾Ýµ¼Èëµ½ÁíÒ»¸ö±íÖУ¿
ллÁË¡£×îºÃÓдúÂë
Insert into Table2(field1,field2,...) select value1,value2,... from Table1
insert into ±íÒ» select * from ±í¶þ
Èç¹û×ֶβ»Ò»Ö£¬ÒªÖ¸¶¨×Ö¶Î
insert into ±íÒ»(A,B) select C,D from ±í¶þ
ͬһ¸öÊý¾Ý¿âÖÐ:
with adoquery1 do
begin
close;
sql.text := 'insert into tb select * from t1';
ExecSql;
end;
²»Í¬µÄÊý¾Ý¿âÖУ¬ÏȲéѯ£¬È»ºóÑ»·insert.
Delphi(Pascal) code:
select * into table1 from table2
»òÕß
Insert into Table1(field1,field2,...) select value1,value2,... from Table2
ÍüÁË¡£ÎÒÏëÔÚdelphiÖÐдÕâЩ´úÂë¡£ÈçºÎÐ´ÄØ£¿¸ø¸öÀý×Ó×îºÃÁË
Ïà¹ØÎÊ´ð£º
ÈçÌâ¡£
¸Ð¾õÈçºÎ£¿½»Á÷Ï¡£
ûÓÐÑо¿¹ý£¬ºÇºÇ
ÓÐɶÑо¿Í·£¿
ÄǸö¶«Î÷£¬ÊǸö¼¦Àߣ¬£¬Ã»ÓÐʲôÒâ˼£¬·¢ÏÖ£¡£¡
ÓÃÀ´×öB/S¼Ü¹¹µÄMISϵͳµÄ»°Ó¦¸Ã¿ÉÒÔÌá¸ß½çÃæ¿ª·¢µÄЧÂʰɣ¿
ÒòΪ²»ÊìϤDelphi £ ......
ÒÑÖªPython ÖУº
s = unicode("²âÊÔ", "gb2312")
s = u'\u6d4b\u8bd5'
print s
²âÊÔ
ÔÚDelphiÀïÃæÈçºÎ½«\u6d4b\u8bd5ÕâÑùµÄ»¹Ô³ÉGb2312µÄºº×ÖÄØ£¿
ÕÒµ½¸ö·½·¨
......
_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
int ret = 0;
_RecordsetPtr pset;
CString sql;
& ......
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡
Ò»´ÎÈ«²¿¶ÁÍê ......