AccessÖеİ´´°ÌåɸѡÊÇʲôÒâ˼£¿
AccessÖеİ´´°ÌåɸѡÊÇʲôÒâ˼£¿
Me.´æÊé²éѯ×Ó´°Ìå.Form.Filter = strWhere
Me.´æÊé²éѯ×Ó´°Ìå.Form.FilterOn = True
ʵ¼ÊÉϾÍÊǰ´×Ó´°ÌåµÄ¹ýÂËÌõ¼þ½øÐÐɸѡ
ʵ¼ÊÉϾÍÊǰ´×Ó´°ÌåµÄ¹ýÂËÌõ¼þ½øÐÐɸѡ
°´´°Ìå¿Ø¼þÉϵÄÄÚÈÝ×÷Ìõ¼þ¶ÔÊý¾Ý½øÐÐɸѡ
ÉÏÏÂÎÄÊÇʲô£¿
¡°°´´°Ìåɸѡ¡® Õâ¸öÊõÓïû¼û¹ý¡£
Ïà¹ØÎÊ´ð£º
×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ
µ±Êý¾Ý¿â×Ö¶ÎΪ¡ ......
ÎÒÕâÑùдδָÃ÷µÄ´íÎó£º
SQL code:
((select min(pview) from DSolution)-1)
select min(pview)-1 from DSolution
ÒýÓÃselect min(pview)-1 from DSolution
Õý½â¡£
insert into table1 (myvale ......
ÎÒÔÚÄ£¿éÀï×Ô¶¨ÒåÁËÒ»¸öº¯Êý:stradd()
¿ÉÊÇÔÚadoquery1.sql.add('select stradd(author) from book');
ʱÌáʾstradd䶨Òå...
Õâ¸öÎÊÌâÓÐʲô°ì·¨¿ÉÒÔ½â¾öµÄÂð? ·Ç³£¸Ð¼¤!
(ÔÚA ......
ÎÒÔÚÄ£¿éÀï×Ô¶¨ÒåÁËÒ»¸öº¯Êý:stradd()
¿ÉÊÇÔÚadoquery1.sql.add('select stradd(author) from book');
ʱÌáʾstradd䶨Òå...
Õâ¸öÎÊÌâÓÐʲô°ì·¨¿ÉÒÔ½â¾öµÄÂð? ·Ç³£¸Ð¼¤!
......
ЩÁËÒ»¸ö¼òµ¥ÍøÕ¾£¬ÓõÄÊÇaccessÊý¾Ý¿â£¬·¢²¼µ½ÓòÃû¿Õ¼äÉÏÈ¥ºó£¬¿ª³¡Ò³ÏÔʾÕý³££¬ÆäÓà´æÔÚÊý¾Ý¿âÁ´½ÓÊý¾ÝµÄÅ׳öÒì³££¬
Ìáʾ£º'c:\windows\system32\inetsrv\data\longdeng.mdb'²»ÊÇÒ»¸öÓÐЧµÄ·¾¶¡£ È·¶¨ ......