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

AccessÊý¾Ý¿âÖÐÄĸöÊý¾Ý¿â¶ÔÏóÊÇÆäËûÊý¾Ý¿â¶ÔÏóµÄ»ù´¡

AccessÊý¾Ý¿âÖÐÄĸöÊý¾Ý¿â¶ÔÏóÊÇÆäËûÊý¾Ý¿â¶ÔÏóµÄ»ù´¡

A²éѯ
B±í
C´°Ìå
DÄ£¿é
±í

¿¼ÊÔÌâµÄ»°£¬Äã¾ÍÑ¡ B. ±í  ¾ÍÐÐÁË

Èç¹ûÊÇʵ¼ÊÖУ¬Ôò±È½ÏÄѻش𡣠±ÈÈç´°ÌåµÄ»ù´¡ÊÇ ±í/²éѯ ºÍÄ£¿é¡£

±í




Ïà¹ØÎÊ´ð£º

access ²éѯ¼Ç¼µÄÎÊÌâ?

ÎÊÌâÈçÏ£º

ÓòéѯÓï¾ä
select * from tab where fil like 'CK090902'ÄܲéÕÒ³öÒ»Ìõ¼Ç¼²¢ÏÔʾ³öÀ´
¸ÄΪ
select * from tab where fil = 'CK090902'
¾Í²»ÄܲéÕÒµ½£¬Ò²ÏÔʾ²»³öÀ´ ......

ÈçºÎͨ¹ýADOʹÓþۺϺ¯ÊýÀ´²éѯ(Êý¾Ý¿âΪACCESS)

_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
    int ret = 0;
  _RecordsetPtr pset;
CString  sql;
& ......

ʹÓÃRepeater¶ÁÈ¡access±í£¬Ò³Ãæ´ò¿ª·Ç³£Âý

accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í  ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡
Ò»´ÎÈ«²¿¶ÁÍê ......

ACCESSµÄ×Ô¶¨Ò庯ÊýÔÚdelphiÀïÔõôÓÃÄØ...

ÎÒÔÚÄ£¿éÀï×Ô¶¨ÒåÁËÒ»¸öº¯Êý:stradd()

¿ÉÊÇÔÚadoquery1.sql.add('select stradd(author) from book');
ʱÌáʾstradd䶨Òå...

Õâ¸öÎÊÌâÓÐʲô°ì·¨¿ÉÒÔ½â¾öµÄÂð? ·Ç³£¸Ð¼¤!


(ÔÚA ......

accessÈçºÎ±È½Ï2¸ö±íÖеÄÊý¾Ý

±ÈÈçA±íÀïÓд®Êý×ÖÊÇ
Êý×ÖÁÐÀï
4A7118

¶øB±íÀïµÄÊý×ÖÁÐÀï
4A7013,4A7112,4A7114,4A7117,4A7118,4A7120,4A7121,4A7123,4A7124

ÕâÑùÈçºÎÆ¥ÅäËûÃÇ ½«ËûÃDzé³öÀ´
²»Ã÷°×ÄãµÄÒâ˼£¬ÄãÊÇ˵ϣÍû²éµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ