· ¿î¿µÃ¼Á¦: [¿µ¹®] Windows · »ç¿ëÁ¦Ç°: Intouch 2014
Intouch ¿¡¼ access ¿¡ data ÀúÀåÇÏ´Â °ÍÀº ¾Æ·¡¿Í °°Àº ¸í·É¾î¸¦ »ç¿ëÇϸé ÀúÀåÀÌ µË´Ï´Ù. ÇÏÁö¸¸ Áö¿ì´Â ¸í·É¾î´Â ¸Þ¼¼Áö°¡ No errors occurred ¶ó°í ¶ß°í data °¡ display °¡ µÇ´Âµ¥ ÇØ´ç data °¡ Áö¿öÁöÁö°¡ ¾Ê½À´Ï´Ù. 1. ÀúÀå: L = StringFromIntg( DB_LINE, 1 ); T_DA = Text($Year, "#") + Text($Month, "0#") + Text($Day, "0#") + Text($Hour, "0#") + Text($Minute, "0#") + Text($Second, "0#") + L ; resultcode=SQLConnect(ConnectionId1,"Provider=MSDASQL;DSN=TestDB;"); ErrorMsg=SQLErrorMsg(resultcode); resultcode2=SQLInsert(ConnectionId1,"Table2","TEST_DB"); ErrorMsg2=SQLErrorMsg(resultcode2);
2. Áö¿ï ¶§:
resultcode3 = SQLConnect( ConnectionId1, "Provider=MSDASQL;DSN=TestDB;" ); ErrorMsq3=SQLErrorMsg(resultcode3); WhereExpr = "Keydatetime like '20181226*' "; resultcode4 = SQLDelete( ConnectionId1, "Table2", WhereExpr ); ErrorMsq4=SQLErrorMsg(resultcode4); SQLDisconnect( ConnectionId1 );
À߸øµÈ ºÎºÐÀÌ ÀÖ´ÂÁö????
Âü°í·Î Access ´Â Access2002 ÆÄÀÏÇü½ÄÀÔ´Ï´Ù. |