СÃÃÇë½Ì¸÷λǰ±²AccessÀï»òÕßÓï¾äÓ¦¸ÃÔõôд£¡
AccessÀïÎÒÏë×öÒ»¸ö»òÕßµÄSQLÓï¾ä£¬Ó¦¸ÃÔõôд
ÎÒд¸ö´ó¸ÅÒâ˼µÄÓï¾ä¡£
select * from ttbaom where passed='true' and progaram = '»áÔ±' or progaram = '·Ç»áÔ±' or progaram='°æÖ÷' and
company like '*ÕÅÈý*'
´ó¸ÅÕâ¸öÒâ˼°É£¡Çë¸÷λǰ±²À´Ö¸Õý¡£
Ìù¼Ç¼¼°ÒªÇó½á¹û³öÀ´¿´¿´
Õâ¾Í°ÑËùÓеļǼ¶¼ÏÔʾ³öÀ´ÁË£¡
¼Ç¼ÊÇÕâÑùµÄ£¡
id passed progaram company
1 true »áÔ± ÕÅÈý
2 true »áÔ± ÀîËÄ
3 true ·Ç»áÔ± ÍõÎå
4 true °æÖ÷ ÀîÁù
ûÓÐǰ±²Ö¸½ÌÂð£¿
4Â¥µÄ´úÂëÓ¦¸Ã¿ÉÒÔÁË
Ïà¹ØÎÊ´ð£º
accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡
Ò»´ÎÈ«²¿¶ÁÍê ......
±í½á¹¹£º
ProductSeriesID ×Ô¶¯±àºÅ
ProductSeriesName Îı¾
ProductSeriesRemark ±¸×¢
Ö´ÐÐǰ
ProductSeriesID ProductSeriesName ProductSeriesRemark
2 LVϳµ¶ÏµÁÐ LVϳµ¶ÏµÁÐ
3 ÎÙ¸ÖÉá ......
DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿
ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿
Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£
ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......