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

ÇëÎÊ£º´´½¨Access±íÔÊÐí¿Õ×Ö·û´®

ÇëÎÊ£ºÓÃsqlÓï¾ä´´½¨Access2000Êý¾Ý±íʱ£¬ÈçºÎÉèÖÃij×Ö¶Î(Èç:Field1)ÔÊÐíΪ¡°¿Õ×Ö·û´®¡±
ÎÒÓô˷¨ Create Table MyTable( Field1 VarChar(10) Null , Field2 DateTime Null £©
²»ÄÜÉèΪ¡°¿Õ×Ö·û´®¡±
ÔÚVarChar(10) Null´¦»¹Òª¼ÓÉÏʲô²ÎÊý£¿Ê¹Ö®Õâ¡°¿Õ×Ö·û´®¡±
Ö÷¼ü²»ÄÜΪ¿Õ

²»ÊÇÖ÷¼üÒ²²»ÄÜÉ裬ÈçºÎ½â¾ö£¿

Create Table MyTable(ID int Not Null, Field1 VarChar(10) , Field2 DateTime£©

ºóÃæÉ¶Ò²²»Ð´¾Í¿ÉÒÔΪ¿ÕÁË..(ĬÈÏÊÇ¿ÉÒÔΪ¿ÕµÄ...²»ÄÜΪ¿ÕµÄ²Å±êʶ)

²»Êǿգ¬

¶øÊÇAccess¹æÔòÖеġ°ÔÊÐí¿Õ×Ö·û´®¡±£¡

ÒýÓÃ
²»Êǿգ¬

¶øÊÇAccess¹æÔòÖеġ°ÔÊÐí¿Õ×Ö·û´®¡±£¡

ĬÈϲ»ÊÇÔÊÐíΪ¿ÕµÄ°É,ÄãдNULL²»¾ÍÊÇÄÇÒâ˼

SQL77£ºÄ¬ÈÏÊÇ£º
±ØÌî×ֶΣº¡°·ñ¡±---¼´¿ÉΪ¿Õ£»
ÔÊÐí¿Õ×Ö·û´®:¡°·ñ¡±---¼´²»ÔÊÐí¿Õ×Ö·û´®

ÎÒÊÇÒªÇó£º

ÔÊÐí¿Õ×Ö·û´®:¡°ÊÇ¡±


Ïà¹ØÎÊ´ð£º

Access²éÕÒÖØ¸´ÎÊÌâ

ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ 
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± 
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......

ADOX+access Ìí¼ÓÁеÄÎÊÌâ

ÎÒÔÚʹÓÃadox+access,ʹÓóÌÐòÌí¼ÓÐÂÁеÄʱºò×ÜÊdzöÏÖ´íÎó,¶¼ÓÐÄÄЩÐèҪעÒâµÄѽ,лл!

ÎҵĴúÂëÊÇÕâÑùµÄ!
C/C++ code:

CoInitialize (NULL);
bsSQL = ...(Êý¾Ý¿âÁ¬½Ó×Ö·û´®)
m ......

MSHFelxGrid Óë ACCESS MEMOÀàÐÍ×ֶεÄÒÉÎÊ

×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ

µ±Êý¾Ý¿â×Ö¶ÎΪ¡ ......

ÈçºÎ°ÑÕâ¾ä¸Ä³ÉÔÚaccessÀïÕý³£ÔËÐеÄ?

select max(classname) as classname,max(parentpath) as parentpath,max(rootid) as rootid,max(classid) as classid from prodclass where parentpath like '%0,3%' and Child=0 group by classname order ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ