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

Access×Ö·û´®´¦Àíº¯Êý

 1.Asc     
˵Ã÷:·µ»Ø×ÖĸµÄAcsiiÖµ
¾ÙÀý:select Asc("A")·µ»Ø65
2.Chr     
˵Ã÷:½«asciiֵת»»µ½×Ö·û
¾ÙÀý:select chr(65)·µ»Ø"A"
3.Format
˵Ã÷:¸ñʽ»¯×Ö·û´®
¾ÙÀý:Select Format(now(),"yyyy-mm-dd")·µ»ØÀàËÆÓÚ"2008-04-03"
     Select Format(3/9,"0.00")·µ»Ø0.33
4.InStr   
˵Ã÷:²éѯ×Ó´®ÔÚ×Ö·û´®ÖеĵÚÒ»¸ö³öÏÖµÄλÖÃ,ûÓзµ»Ø0
¾ÙÀý:select Instr("abc","a") ·µ»Ø1
5.LCase    
˵Ã÷:·µ»Ø×Ö·û´®µÄСдÐÎʽ
¾ÙÀý:select LCase("ABC") ·µ»Ø"abc"
6.Left    
˵Ã÷:×ó½ØÈ¡×Ö·û´®
¾ÙÀý:select Left("ABC",1) ·µ»Ø"A"
7.Len   
˵Ã÷:·µ»Ø×Ö·û´®³¤¶È
¾ÙÀý:select Len("ABCÄãºÃ")·µ»Ø5
8.LTrim   
˵Ã÷:×ó½ØÈ¡¿Õ¸ñ
¾ÙÀý:select LTrim(" 111") ·µ»Ø"111"
9.Mid
˵Ã÷:È¡µÃ×Ó×Ö·û´®
¾ÙÀý:select mid("abcd",1,2) ·µ»Ø"ab"
10.Right   
˵Ã÷:ÓÒ½ØÈ¡×Ö·û´®
¾ÙÀý:select Right("ABC",1) ·µ»Ø"C"
11.RTrim   
˵Ã÷:ÓÒ½ØÈ¡¿Õ¸ñ
¾ÙÀý:select Right("ABC ") ·µ»Ø"ABC"
12.Space
˵Ã÷:²úÉú¿Õ¸ñ
¾ÙÀý:select Space(5) ·µ»Ø5¸ö¿Õ¸ñ
13.StrComp
˵Ã÷:±È½ÏÁ½¸ö×Ö·û´®ÊÇ·ñÄÚÈÝÒ»ÖÂ(²»Çø·Ö´óСд)
¾ÙÀý:select StrComp("abc","ABC")·µ»Ø0
     select StrComp("abc","123")·µ»Ø-1
14.Trim    
˵Ã÷:½ØÈ¡×Ö·û´®Á½Í·µÄ¿Õ¸ñ
¾ÙÀý:select Trim(" ABC ") ·µ»Ø"ABC"
15.UCase   
˵Ã÷:½«×Ö·û´®×ª´óд
¾ÙÀý:select UCase("abc") ·µ»Ø"ABC"   


Ïà¹ØÎĵµ£º

µÃµ½access±í×Ö¶ÎÃûVBS½Å±¾

 
set adoCN   =createobject("ADODB.CONNECTION")
set strCnn  =createobject("ADODB.Recordset")    
set rstSchema   =createobject("ADODB.Recordset")
  Dim   I   
dim n
        str1 ......

·¢Ò»¸öǰһ¶Îʱ¼äдµÄС¹¤¾ßVC+Access(¸½Ô´´úÂë)


´ó¸ÅµÄ¹¦ÄܾÍÊÇÈÕÆÚÌáÐÑ£¬°ÑͨѶ¼ºÍÈÕÆÚÌáÐÑÏà½áºÏ¡£
ÌáÐÑ·½Ãæ×öµÄºÜ²î£¬¼¼ÊõÓÐÏÞ¡£
Ƥ·ôÓõÄÊÇSkin++
µÚÒ»´Î·¢£¬µ«Ö®Ç°Ð޸Ĺý¼¸´Î£¬Ä¿Ç°°æ±¾0.7
×öÕâ¸ö¶«Î÷ÍêÈ«ÊÇÒòΪÎÒ¸öÈËÐèÒª¡£
ÊÇÒ»¸ö¶àÓû§µÄ¹¤¾ß¡£
ÓÐ×Ô¶¯Éý¼¶¹¦ÄÜ¡£
Ó¦Ó÷¶Î§ºÜÕ­¡£
ÏÂÔØµØÖ·£ºhttp://www.cppblog.com/Files/pencil/GoodFriendV0.7.rar
Ô ......

ADOÊý¾Ý¿âÁ¬½ÓAccess

´´½¨»ùÓÚ¶Ô»°¿òµÄÓ¦ÓóÌÐòADO,Ïò¶Ô»°¿òÖÐÌí¼ÓÒ»¸öÁбíÊÓͼ¿Ø¼þ£¬²¢ÎªÆäÌí¼Ó±äÁ¿m_Grid
µÚÒ»²½£ºADO¶ÔÏóµÄµ¼Èë
ÔÚStdAfx.hÍ·ÎļþÖУº
// stdafx.h : include file for standard system include files,
//  or project specific include files that are used frequently, bu
//      are ......

VC/MFCÖеÄACCESSÊý¾Ý¿â·ÃÎÊʵÏÖ

ǰЩÌìŪһ¸ö·ÃÎÊACCESSÊý¾Ý¿âµÄС¶«Î÷£¬·ÑÁËЩÁ¦Æø²ÅŪºÃ¡£
ËäÈ»»¹ÓÐЩ²»¾¡ÈËÒ⣬µ«ÊÇÖÕ¾¿»¹ÊÇ¿ÉÒÔÓÃÁË£¬
ÔÚÕâÀï·ÖÏíÒ»ÏÂ×Ô¼ºµÄʵÏÖ·½·¨ºÍ¾­Ñé¡£
ÀïÃæµÄ¶«Î÷ÍøÉ϶¼ÓУ¬µ«ÊÇ£¬ÕâÀïµÄÊÇ×îÈ«µÄ¡£
VC/MFC·ÃÎÊACCESSÊý¾Ý¿â
·½·¨1£º
1  ´´½¨Ò»¸ö»ùÓÚ¶Ô»°¿òµÄÓ¦ÓóÌÐò¡£
    ·ÅÈëÁ½¸öActiveX ¿Ø¼þ Mic ......

ÕûÀí±È½ÏÈ«µÄAccess SQL×¢Èë²Î¿¼

 Access SQL×¢Èë²Î¿¼
°æ±¾ 0.2.1
(×î½ü¸üР10/10/2007)
Ô­×÷Õß²»Ïê
 
ÃèÊö SQL²éѯ¼°×¢ÊÍ
×¢ÊÍ·û AccessÖÐûÓÐרÃŵÄ×¢ÊÍ·ûºÅ.Òò´Ë"/*", "--"ºÍ"#"¶¼Ã»·¨Ê¹ÓÃ.µ«ÊÇ¿ÉÒÔʹÓÿÕ×Ö·û"NULL"(%00)´úÌæ:
' UNION SELECT 1,1,1 from validTableName%00
 
Óï·¨´íÎóÐÅÏ¢ "[Microsoft][Driver ODBC Micros ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ