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

Question and Answer 3088
Ref#: 1137
SQL Data °ü·Ã

· ¿î¿µÃ¼Á¦: [¿µ¹®] Windows
· »ç¿ëÁ¦Ç°: 10.0

SQLSelect(); ÇϽŠ´ÙÀ½
SQLNumRows(); ÇÏ°Ô µÇ¸é °¹¼ö¸¦ °¡Á® ¿É´Ï´Ù.

ex) NumberofRows = SQLNumRows(ConnectID);

°¨»çÇÕ´Ï´Ù.

[¹®ÀÇ ³»¿ë]

· ¿î¿µÃ¼Á¦: 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,"#.##");

ÀÌ·¸°Ô »ç¿ëÇؼ­ ãÀº ÃÑ°¹¼ö¸¦ º¸·Á°í Çߴµ¥ Àß ¾ÈµÇ´õ¶ó°í¿ä.
¾î¶²½ÄÀ¸·Î »ç¿ëÇØ¾ß ÇÒ±î¿ä?

ÀÛ¼ºÀÚ: cibion
ÀÛ¼ºÀÏ: 2013-08-29 ¿ÀÀü 11:29:00
Á¶È¸¼ö: 1997

ÀÌÀü±Û: HMIÀÇ Åë½Å
´ÙÀ½±Û: ¼­¹ö¿Í Ŭ¶óÀ̾ðÆ®ÀÇ ¹öÀü

°ü·Ã±Û
Title Author Date Qry.
SQL Data °ü·Ã woody 2013-08-27 2313
>> Re: SQL Data °ü·Ã cibion 2013-08-29 1997