[¹®ÀÇ ³»¿ë]
· ¿î¿µÃ¼Á¦: Windows XP SP3 · »ç¿ëÁ¦Ç°: ÀÎÅÍÄ¡ 10.1
SQL server¿¡ DB¸¦ ÀúÀåÇسù½À´Ï´Ù.
Ser_No - Memory Message Serial_Input - Memory Message = User Input data
SQLSelect(Connect_Id,TableName,BindList,WhereExpr,OrderByExpr);
[°æ¿ì1] WhereExpr = "Ser_No = ¡®" + Serial_input + "¡¯" ;
sqlnumbrows = SQLNumRows(ConnectionID);
°á°ú : sqlnumbrows´Â ãÀº ùÇàÀÇ ³Ñ¹ö¸¦ ¾Ë·ÁÁÖ´Â°Í °°¾Ò½À´Ï´Ù.
[°æ¿ì2] WhereExpr = Speed = " + text(Speed_Input,"#.##");
sqlnumbrows = SQLNumRows(ConnectionID);
°á°ú : °°Àº °ªÀÇ ¸ðµçÇàÀÇ °¹¼ö¸¦ ¾Ë·ÁÁÖ´Â°Í °°¾Ò½À´Ï´Ù.
[Áú¹®] WhereExpr = "Ser_No = ¡®" + Serial_input + "¡¯" + "AND" + Speed = " + text(Speed_Input,"#.##");
ÀÌ·¸°Ô »ç¿ëÇؼ ãÀº ÃÑ°¹¼ö¸¦ º¸·Á°í Çߴµ¥ Àß ¾ÈµÇ´õ¶ó°í¿ä. ¾î¶²½ÄÀ¸·Î »ç¿ëÇØ¾ß ÇÒ±î¿ä? |