AccessÖеİ´´°ÌåɸѡÊÇʲôÒâ˼£¿
AccessÖеİ´´°ÌåɸѡÊÇʲôÒâ˼£¿
Me.´æÊé²éѯ×Ó´°Ìå.Form.Filter = strWhere
Me.´æÊé²éѯ×Ó´°Ìå.Form.FilterOn = True
ʵ¼ÊÉϾÍÊǰ´×Ó´°ÌåµÄ¹ýÂËÌõ¼þ½øÐÐɸѡ
ʵ¼ÊÉϾÍÊǰ´×Ó´°ÌåµÄ¹ýÂËÌõ¼þ½øÐÐɸѡ
°´´°Ìå¿Ø¼þÉϵÄÄÚÈÝ×÷Ìõ¼þ¶ÔÊý¾Ý½øÐÐɸѡ
ÉÏÏÂÎÄÊÇʲô£¿
¡°°´´°Ìåɸѡ¡® Õâ¸öÊõÓïû¼û¹ý¡£
Ïà¹ØÎÊ´ð£º
IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)
'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......
_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
int ret = 0;
_RecordsetPtr pset;
CString sql;
& ......
ʱ¼ä¸ñʽ£¿
±ðÄÃcoldatatime ºÍCTimeʲôµÄ˵Ê¡£¡£ËµµãÓÐÓõġ£¡£¡£ËùÓлý·ÖÏàËÍ
ʲôÎÊÌ⣿
format(#2009-1-1#,'yyyy-mm-dd')£¿
select #2009-1-1#
insert into table (mydate) values ( ......
access Êý¾ÝÈçºÎµ¼Èëµ½SQLÖÐ Çë¸ø³öÏêϸ¹ý³Ì £¬Ð»Ð»
ÒýÓÃ
access Êý¾ÝÈçºÎµ¼Èëµ½SQLÖÐ Çë¸ø³öÏêϸ¹ý³Ì £¬Ð»Ð»
Èç¹ûÖ»Êǵ¼Êý¾Ý,ʹÓÃDTS»òSSISµ¼Èë¼´¿É,ûʲôÏêϸ¹ý³Ì,°´ÕÕ½çÃæÒ»²½Ò»²½×ß¼´¿É.
DTS ²»Ê ......