Ȩ > ±â¼úÁö¿ø > ¹¯°í´äÇϱâ

Question and Answer 3331
Ref#: 1311
Intouch ¿¡¼­ Access(MDAC) ¿¡ data Áö¿ì´Â ¹æ¹ý

· ¿î¿µÃ¼Á¦: [¿µ¹®] 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 ÆÄÀÏÇü½ÄÀÔ´Ï´Ù.

ÀÛ¼ºÀÚ: viewlee
ÀÛ¼ºÀÏ: 2018-12-28 ¿ÀÀü 11:28:00
Á¶È¸¼ö: 1310

ÀÌÀü±Û: Á¤È¸¿ø µî¾÷ ºÎŹµå¸³´Ï´Ù.
´ÙÀ½±Û: Intouch ¿¡¼­ Microsoft data Access(MDAC) ¿¡ data ÀúÀåÇÏ´Â ¹æ¹ý