ÎÒÔÚÄ£¿éÀï×Ô¶¨ÒåÁËÒ»¸öº¯Êý:stradd()
¿ÉÊÇÔÚadoquery1.sql.add('select stradd(author) from book');
ʱÌáʾstradd䶨Òå...
Õâ¸öÎÊÌâÓÐʲô°ì·¨¿ÉÒÔ½â¾öµÄÂð? ·Ç³£¸Ð¼¤!
(ÔÚACCESSµÄ²éѯÀïÖ´ÐÐÕý³£)
²»ÄÜÕâôÓ㬻¹ÊÇÓÃadoqueryÈ¡³öÊý¾ÝÈ»ºóÔÙdelphiÀïÃæÊµÏÖÄãµÄstraddÁË
Delphi(Pascal) code:
adoquery1.sql.add('select '+stradd(author)+' from book');
ÄãµÄstraddº¯ÊýÊÇdelphiÖеÄ,²»ÊÇÊý¾Ý¿âÖеÄ
Delphi(Pascal) code:
adoquery1.sql.add('select '+stradd(author)+' from book');
ÄãµÄstraddº¯ÊýÊÇdelphiÖеÄ,²»ÊÇÊý¾Ý¿âÖеÄ
°ÑÄãµÄstraddº¯Êý£¬ÔÚDElphiÖÐÖØÐ¶¨ÒåÒ»ÏÂ~~
stradd(author)ÖеÄauthorÊDZíbookµÄÒ»¸ö×Ö¶ÎÀ´µÄ
accessµÄ×Ô¶¨Ò庯Êý,¿ÉÒÔÓÃÔÚÄÚ²¿,ÒòΪÊÇvba,¶¨ÒåÒ»¸öÊÓͼ,ÔÚdelphiÖÐÓÃadoqueryµ÷ÓÃÊÓͼ
Õâ¸öÒ²ÊÔ¹ýÁË,¸úÔÀ´Ò»ÑùµÄÌáʾ.
_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
int ret = 0;
_RecordsetPtr pset;
CString sql;
& ......